The format for connect strings varies, depending on the target database. You can define the connect string in the interface configuration, or you can define a Windows Datasource Name (DSN) and reference that DSN in the interface’s configuration.
The following are example connect strings that could be used to connect to databases external to Visual KPI:
SQL Server:
- “Driver={SQL Native Client};Server=.\Demo;Database=SQLDEMO;Trusted_Connection=yes;”
- “Driver={SQL Native Client};Server=.\SQLEXPRESS;Database=SQLDEMO;Trusted_Connection=no;UID=<userid>;PWD=<password>;”
- “DSN=DSNACCESS;”
MS Access:
- “Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Data\Projects\VKPI ODBCWS\db2.mdb;”
Note: If your database resides in SQL Server 2005 Express, the Server portion of the connect string must include the instance name following the period, for example: Server=.\SQLExpress.