Database connection parameters (connection string)

The connection string contains parameters with assigned values that are separated by semicolon. The most important is the name of the connection Provider, that is usually listed first. The other parameters are required by the corresponding provider for successfull connection.

Another option is connection via "Denominated ODBC sources". It means that in Windows OS 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;

Database connection parameters (connection string):

Database type	ODBC - Named ODBC data source (default) - dsn=ODBCSourceName;pwd=password; dBase - Provider Microsoft - $.join("Driver={Microsoft dBASE Driver (.dbf)};DriverID=277;Dbq=","$.path("data",""),";") dBase - Provider ACE.OLEDB 12.0 - $.join("Provider=Microsoft.ACE.OLEDB.12.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 ACE.OLEDB 12.0 - $.join("Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=false;Data Source=",$.path("data","dbfile.mdb"),";") MsExcel 2003 - Provider ACE.OLEDB 12.0 - $.join$.join("Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 12.0 Xml;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"),";") DB - Firebird (ODBC Driver) - PROVIDER=MSDASQL;DRIVER={Firebird/InterBase(r) driver};SERVER=localhost;DATABASE=pm_data;UID=pm_writer;PWD=pmwriter; MsSql - SQL Server (Windows authentication) - provider=MSOLEDBSQL;Server=.\SQLEXPRESS;Database=pm_data;Integrated Security=SSPI; MsSql - SQL Server (SQL user) - MSOLEDBSQL - provider=MSOLEDBSQL;Server=.\SQLEXPRESS;Database=pm_data;Uid=owner;Pwd=password; MsSql - SQL Server (SQL user) - SQLOLEDB - provider=SQLOLEDB;Server=.\SQLEXPRESS;Database=pm_data;Uid=owner;Pwd=password; MsSql - SQL Server (ODBC Driver) - Driver={SQL Server};Server=.\SQLEXPRESS;Database=pm_data;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; MySql - OLEDB - Provider=MySQLProv;Data Source=mydb;User Id=Username;Password=Password; Oracle - Microsoft ODBC - Driver={Microsoft ODBC for Oracle};Server=ServerAddress;Uid=Username;Pwd=Password; Oracle - Oracle in OraClient11g - Driver={Oracle in OraClient11g_home1};Dbq=myTNSServiceName;Uid=Username;Pwd=Password; PostgreSQL - psqlODBC Driver - Provider=MSDASQL;Driver={PostgreSQL UNICODE};Server=localhost;Port=5432;Database=dbname;Uid=username;Pwd=password;

Database type

ODBC - Named ODBC data source (default) - dsn=ODBCSourceName;pwd=password;

dBase - Provider Microsoft - $.join("Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=","$.path("data",""),";")

dBase - Provider ACE.OLEDB 12.0 - $.join("Provider=Microsoft.ACE.OLEDB.12.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 ACE.OLEDB 12.0 - $.join("Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=false;Data Source=",$.path("data","dbfile.mdb"),";")

MsExcel 2003 - Provider ACE.OLEDB 12.0 - $.join$.join("Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 12.0 Xml;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"),";")

DB - Firebird (ODBC Driver) - PROVIDER=MSDASQL;DRIVER={Firebird/InterBase(r) driver};SERVER=localhost;DATABASE=pm_data;UID=pm_writer;PWD=pmwriter;

MsSql - SQL Server (Windows authentication) - provider=MSOLEDBSQL;Server=.\SQLEXPRESS;Database=pm_data;Integrated Security=SSPI;

MsSql - SQL Server (SQL user) - MSOLEDBSQL - provider=MSOLEDBSQL;Server=.\SQLEXPRESS;Database=pm_data;Uid=owner;Pwd=password;

MsSql - SQL Server (SQL user) - SQLOLEDB - provider=SQLOLEDB;Server=.\SQLEXPRESS;Database=pm_data;Uid=owner;Pwd=password;

MsSql - SQL Server (ODBC Driver) - Driver={SQL Server};Server=.\SQLEXPRESS;Database=pm_data;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;

MySql - OLEDB - Provider=MySQLProv;Data Source=mydb;User Id=Username;Password=Password;

Oracle - Microsoft ODBC - Driver={Microsoft ODBC for Oracle};Server=ServerAddress;Uid=Username;Pwd=Password;

Oracle - Oracle in OraClient11g - Driver={Oracle in OraClient11g_home1};Dbq=myTNSServiceName;Uid=Username;Pwd=Password;

PostgreSQL - psqlODBC Driver - Provider=MSDASQL;Driver={PostgreSQL UNICODE};Server=localhost;Port=5432;Database=dbname;Uid=username;Pwd=password;

History:

Pm8.01.00: Created

PROMOTIC 9.0.31 SCADA system documentation MICROSYS, spol. s r.o.

Send page remark Contact responsible person

Navigation:

- PROMOTIC SCADA/HMI system

- Documentation contents

- Objects of the PROMOTIC system

- Pma objects

- PmaAdo

- ADO

- Database connection parameters (connection string)

Promotic

Database connection parameters (connection string)

Database connection parameters (connection string):

See also:

History: