Connecting to AzureSQL

[CharlyTango]

  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]

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]

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.

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]

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]

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.