Generic filters
Exact matches only
  1. Home
  2. Knowledge Base
  3. Interfaces & Data Sources
  4. Use Connect Strings with the Interfaces

Use Connect Strings with the Interfaces

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.

Was this article helpful?

Related Articles