Another option is connection via "Denominated ODBC sources". It means that in the OS Windows configuration window "ODBC data source manager" the corresponding Provider is selected and configured for database access. This database connection profile has a unique name. The connection string then uses the connection profile name, for example:
dsn=UserNameSource;uid=NameUser;pwd=PasswordUser;Initial Catalog=NameDb;
| Connection string | ODBC - Named ODBC source (default) - dsn=ODBCSourceName;pwd=password; DBase - Provider Microsoft - $.join("Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=","$.path("data",""),";") DBase - Provider Jet.4 - $.join("Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=dBASE IV;Data Source=","$.path("data","")),";") Access - Provider Microsoft - $.join("Driver={Microsoft Access Driver (*.mdb)};Dbq=",$.path("data","dbfile.mdb"),";") Access - Provider Jet.4 - $.join("Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=false;Data Source=",$.path("data","dbfile.mdb"),";") MsExcel 2003 - Provider Jet.4 - $.join("Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel 8.0;HDR=Yes;IMEX=0';Data Source=",$.path("data","file.xls"),";") MsExcel 2007,2010 - Provider Microsoft - $.join("Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};ReadOnly=0;Dbq=",$.path("data","file.xlsx"),";") MsSql - SQL Server (Windows authentication) - provider=SQLOLEDB;Server=.\SQLEXPRESS;Database=db_name;Integrated Security=SSPI; MsSql - SQL Server (SQL user) - provider=SQLOLEDB;Server=.\SQLEXPRESS;Database=db_name;Uid=owner;Pwd=password; MySql - MySQL ODBC 8.0 Driver - Driver={MySQL ODBC 8.0 Unicode Driver};Server=localhost;Database=dbname;User=username;Password=password;Option=3; PostgreSQL - psqlODBC Driver - Provider=MSDASQL;Driver={PostgreSQL UNICODE};Server=localhost;Port=5432;Database=dbname;Uid=username;Pwd=password; |
|---|---|
| When working with file databases, it is necessary to modify the path to the file or data files folder in the created connection string. |