Connecting to AzureSQL lazarus / 16-Databases ---------------------------------------------------------------------- Stag76 · 2026-05-04 08:09 I'm currently using Lazarus 2.2.6, FPC 3.2.2 and ZEOSlib 7.2.14, using ntwdblib to connect to MSSQL DataBases I now need to be able to connect to AzureSQL DataBases. Which Versions of Lazarus and ZEOSlib are required for this connection, and what is the preferred connection method? ---------------------------------------------------------------------- paweld · 2026-05-04 10:21 Zeos 8 and OleDB as the Protocol ---------------------------------------------------------------------- Stag76 · 2026-05-05 06:56 Thanks for that. Will I also have to upgrade to the current Lazarus Software from Version 2.2.6, FPC 3.2.2 ---------------------------------------------------------------------- paweld · 2026-05-05 08:16 Quote from: Stag76Will I also have to upgrade to the current Lazarus Software from Version 2.2.6, FPC 3.2.2 In general, I recommend using the most recent version of Lazarus/FPC, but it’s not required - Zeos 8 should work fine with FPC 3.2.2 and Lazarus 2.2.6 ---------------------------------------------------------------------- Stag76 · 2026-05-05 10:53 Thanks again. ---------------------------------------------------------------------- Stag76 · 2026-05-12 06:49 Is there anything to be aware of when installing multiple versions of Lazarus in separate folders on the same machine. ---------------------------------------------------------------------- paweld · 2026-05-12 07:31 Just make sure that each installation has its own configuration folder. ---------------------------------------------------------------------- Stag76 · 2026-05-13 04:41 Thanks for that. Up until now, I've been using the 32-bit versions of Lazarus, converting Data from very old Interbase and FireBird (Version 1.5) DataBases to SQL Server. Is this a reason to continue with the 32-bit versions, or is a switch to the 64-bit Version compatible with these DataBases, and therefore preferable. ---------------------------------------------------------------------- Thaddy · 2026-05-13 04:57 SQL server itself is a 64bit database. I would not stick to 32 bit. ---------------------------------------------------------------------- Zvoni · 2026-05-13 06:58 Quote from: Thaddy on May 13, 2026, 06:57:38 amSQL server itself is a 64bit database. I would not stick to 32 bit. The Database itself (as in: the actual Data-Files) is Bit-agnostic. The Bitness matters for the Server-itself (the "program" offering the Database) and/or client libs accessing that Database It doesn't matter if the Server itself runs on 64-Bit, but the clients on 32-Bit (or vice versa). I know that from MySQL, where i actually did have the constellation of Server running 32-Bit, but the clients 64 Bit. No issues whatsoever ---------------------------------------------------------------------- Thaddy · 2026-05-13 07:53 There are no issues, but you should not encourage legacy platforms. And Windows 32 bit IS a legacy platform for over 10 years. ---------------------------------------------------------------------- paweld · 2026-05-13 10:00 I’ve only recently switched to FPC x86_64. Until now, I’d been using the 32-bit version, though I occasionally did cross-compilation to 64-bit for certain projects. Until the switch, I didn’t notice any shortcomings with the 32-bit version, but eventually, due to the large number of components, the Lazarus IDE stopped compiling for me, and I had to switch to x86_64. If you use 32-bit libraries in your projects, I wouldn’t switch. If you use resources from rc files in your projects, I wouldn’t switch either - there’s a bug in stable version, that’s fixed in the fixes and trunk branches. ---------------------------------------------------------------------- Zvoni · 2026-05-13 13:24 Quote from: Thaddy on May 13, 2026, 09:53:46 amThere are no issues, but you should not encourage legacy platforms. And Windows 32 bit IS a legacy platform for over 10 years. Agreed. And i don't "encourage" use of legacy-platforms. I was just correcting a misconception. I could even say, that the Database-Server itself doesn't care, if the clients run on 32-Bit Linux, 64-Bit Windows, 128-Bit MacOS or 1024-bit LCARS, as long as they  follow the communcation-protocol ---------------------------------------------------------------------- Stag76 · 2026-05-14 00:26 Thanks for all the Advice. I've only changed my operating Version of Lazarus when I've changed hardware, so am unsure of the best way to update an existing installation. Which is the recommended method.   1 . Uninstall Current Version, then install the New Version in the same folder (C:\Lazarus).   2. Create a Secondary Installation in a Different Folder. ---------------------------------------------------------------------- Zvoni · 2026-05-14 06:22 Second option ---------------------------------------------------------------------- CharlyTango · 2026-05-14 08:21 Quote from: Stag76 on May 14, 2026, 02:26:37 am  2. Create a Secondary Installation in a Different Folder. definitely the second option. I never upgrade an existing version. When a new verion arrives or i need a testing environment an complete new installation is created in a different folder. severeal installations with different purposes can easyly live beneath each other. At leadt one remains untouched until the new one really works. Have a look at fpcupdeluxe and the possibility to use defmods.ini in the new created folder, so you get a tailored Lazarus installation automatically. ---------------------------------------------------------------------- Stag76 · 2026-05-15 23:57 If I'm creating a Version 4.6 instance of Lazarus separate to my current 2.2.6 Version, it it simply a matter of specifying an empty folder (eg c:\Lazarus_AZURE) in the installation process, or are there other considerations. ---------------------------------------------------------------------- Thausand · 2026-05-16 00:03 Quote from: Stag76 on May 16, 2026, 01:57:14 amIf I'm creating a Version 4.6 instance of Lazarus separate to my current 2.2.6 Version, it it simply a matter of specifying an empty folder (eg c:\Lazarus_AZURE) in the installation process, or are there other considerations. I not know if installer make take care for multiple configuration, wiki https://wiki.freepascal.org/Multiple_Lazarus This important. Have make sure for backup old configuration for restore if need. ---------------------------------------------------------------------- Stag76 · 2026-09-01 03:27 I'm trying to connect to an MSSQL DataBase using Lazarus 4.6 and Zeos 8, OLEDB method. When I Connect, it errors with the following message: Exception Class EZSQLException. SQL Error OLEDB Error SQL State IM002 Native Error 0. Code 0 Message IID_IBDInitialize.initialize. SQL State IM002 appears to relate to ODBC. Do I have to install the ODBC Driver? ---------------------------------------------------------------------- Stag76 · 2026-09-01 08:36 I fixed it by creating a .UDL file, enter the parameters, opening it in Notepad, and copying the Connection String into the DataBase parameter of the TZConnection.