Server=MyServer.ead.dom\sqlexpress
User_Name=MyUserName
Password=MyPassword
Database=InitialDataBaseName
Encrypt=No
ODBCAdvanced=Encrypt=No;TrustServerCertificate=Yes;MARS_Connection=Yes
DriverID=MSSQL
Component Parameters: can be empty
ODBC 18 Allows: Encrypt=Optional
Server=MyServer.ead.dom\sqlexpress
User_Name=MyUserName
Password=MyPassword
Database=InitialDataBaseName
Encrypt=No
DriverID=MSSQL
Component Parameters: can be empty
DriverID=ODBC
ODBCDriver=AspenTech SQLplus
User_Name=DEGUSSA\SampleUser
Password=SamplePassword
ODBCAdvanced=HOST=SV0Sample;PORT=10014;ADS=;TIMEOUT=;MAXROWS=100000;TABLE=;CHARINT=Y;CHARFLOAT=N;CHARTIME=Y;READONLY=Y;ALLFIELDS=N;ROWID=N;CONVERTERRORS=Y;CHARISNULL=Y;TIBCO=N;REALASSINGLE=N
Component Parameters: can be empty
Component Parameters provide possibilities for further tunning.
Avoid old MSSQL Driver, it is Depcicated!
To Test if multiple connection suppored You can use this function:
CIP_MARS_Test()
If it is not supported it will show the the following error message:
Invalid expression.
Error :[FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver]Die Verbindung ist mit Ergebnissen von einem anderen hstmt belegt
Embarcadero official:
https://docwiki.embarcadero.com/RADStudio/Alexandria/en/Connect_to_Microsoft_SQL_Server_(FireDAC)
Embarcadero's new (D11.2) prefered Driver Order:
FindBestDriver( {$IFDEF MSWINDOWS} [C_2018_ODBC, C_2017_ODBC, C_2012_NC, C_2016_ODBC, C_2012_ODBC, C_2008, C_2005, C_2000] {$ENDIF} {$IFDEF POSIX} [C_2018_ODBC, C_2017_ODBC, C_2016_ODBC, C_2012_ODBC, C_FreeTDS], C_FreeTDSLib {$ENDIF}