ODBC provider connection strings

Starting from 2015 version of the SQL Data Examiner you can use any ODBC data sources as a data comparison source or target.

To connect to an ODBC data source you need to specify Data Source Name (DSN) or connection string.

We have tested the SQL Data Examiner with following data sources:

Data Source ODBC Driver Connection string example Version
SQLite SQLite3 ODBC Driver DRIVER={SQLite3 ODBC Driver}; Database=c:\Databases\SQLite\TestDb; 3.x
Firebird Firebird/InterBase(r) driver DRIVER={Firebird/InterBase(r) driver};
UID=SYSDBA;PWD=masterkey;
DBNAME=c:\Databases\Firebird\FIREBIRDDB.GDB;
2.5.2
Interbase InterBase ODBC driver DRIVER={InterBase ODBC driver};UID=SYSDBA;
PWD=masterkey;DIALECT=3;
CLIENT=C:\Program Files\Embarcadero\InterBase\bin\gds32.dll;
DBNAME=127.0.0.1/3051:Demodb;
11.0.3
SYBASE SQL Anywhere 12 Driver={SQL Anywhere 12};Database=demo;Uid= myUsername;
Pwd= myPassword;
12.1
SQLBase Gupta SQLBase 11.7 Driver={Gupta SQLBase 11.7};ServerName=Server1;Database=ISLAND; 11.7
IBM DB2 IBM DB2 ODBC DRIVER Driver={IBM DB2 ODBC DRIVER};Database=SAMPLE;UID= myDomain\myUsername;PWD=myPassword 10.5.0
Pervasive Pervasive ODBC Client Interface Driver={Pervasive ODBC Client Interface}; ServerName=localhost;DBQ=DEMODATA;TransportHint=TCP:SPX; 11.30
PostgreSQL PostgreSQL Driver={PostgreSQL};Server=IP address;Port=5432;
Database=myDataBase;Uid=myUsername;Pwd=myPassword;
9.3.0
Ingres Ingres II DRIVER={Ingres II};SERVER=(LOCAL);DATABASE=demodb; 10.1.0
Paradox Microsoft Paradox Driver (*.db ) Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.X; DefaultDir=c:\Databases\Paradox\;
Dbq=c:\Databases\Paradox\;CollatingSequence=ASCII
5.x
  • Product: SQL Data Examiner
  • Edition: All
  • Version: 2015 or later

Do not see what you are looking for?
Please submit a support request