Working with ODBC data sources

Starting from SQL Data Examiner 2015, any ODBC data source can be used as source or target database either.

To connect to an ODBC data source you should specify a Data Source Name (DSN) or connection string. Please note that SQL Data Examiner does not configure an ODBC data source and uses specified DSN or connection string “as is”.

ODBC Data Sources

IMPORTANT: When you are running SQL Data Examiner on x64 platform the program works with x64 ODBC drivers only. If you need to connect to 32-bit ODBC driver please use the x86 version of SQL Data Examiner: see Tools > Run SQL Data Examiner (x86)… See the Running SQL Examiner or SQL Data Examiner in x64 environment for details.

Configuring a DSN

  1. Open the ODBC Data Source Administrator: Control Panel > Administrative Tools > ODBC Data Sources (64-bit)
  2. Go to the User DSN or System DSN tab
  3. Click Add to create
  4. Scroll through the list of drivers in the appeared dialog to locate the required driver and then click Finish
  5. The configuration dialog appears
  6. Configure the driver and click Test on the last step
  7. When you have configured the driver, click OK. The configuration window closes, and you can see your new DSN in the list.
  8. Now you can select this DSN in the SQL Data Examiner

Configuring a connection string

http://www.connectionstrings.com/ - a reference for connection string formats for most data sources.

Tested ODBC data sources

We have tested SQL Data Examiner with some ODBC data sources, however we did not test the program with all available ODBC drivers and do not plan to do it. Here the list of the tested data sources:

Data Source ODBC Driver Connection string example
SQLite 3.x SQLite3 ODBC Driver DRIVER={SQLite3 ODBC Driver}; Database=c:\Databases\SQLite\TestDb;
Firebird 2.5.2 Firebird/InterBase(r) driver DRIVER={Firebird/InterBase(r) driver};
UID=SYSDBA;PWD=masterkey;
DBNAME=c:\Databases\Firebird\FIREBIRDDB.GDB;
Interbase 11.0.3 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;
SYBASE 12.1 SQL Anywhere 12 Driver={SQL Anywhere 12};Database=demo;Uid= myUsername;
Pwd= myPassword;
SQLBase 11.7 Gupta SQLBase 11.7 Driver={Gupta SQLBase 11.7};ServerName=Server1;Database=ISLAND;
IBM DB2 10.5.0 IBM DB2 ODBC DRIVER Driver={IBM DB2 ODBC DRIVER};Database=SAMPLE;UID= myDomain\myUsername;PWD=myPassword
Pervasive 11.30 Pervasive ODBC Client Interface Driver={Pervasive ODBC Client Interface}; ServerName=localhost;DBQ=DEMODATA;TransportHint=TCP:SPX;
PostgreSQL 9.3.0 PostgreSQL Driver={PostgreSQL};Server=IP address;Port=5432;
Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Ingres 10.1.0 Ingres II DRIVER={Ingres II};SERVER=(LOCAL);DATABASE=demodb;
Paradox 5.x 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
  • Product: SQL Data Examiner
  • Edition: All
  • Version: 2015 or later

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