Please enable JavaScript to view this site.

Navigation: Advanced topics

Open Database Connectivity (ODBC)

Scroll Prev Next More

ODBC

Open DataBase Connectivity (ODBC) is a system provided in Windows to allow exchanging data between different database applications.

 

Go to Control Panel -> Administrative tools to find ODBC Data Sources (32&64-bit) applications.

 

PHPRunner allows you to extract data from an ODBC Data Source Name (DSN). A DSN is a convenient way of storing all of the datasource connection information (file name, path, user I.D, connect password, database type, etc.) under a simple name.

 

If you want to use PHPRunner with databases like MySQL, Informix, or MS SQL server, you need to install and configure appropriate ODBC drivers for your database. You can find links to the appropriate ODBC drivers below.

 

Visit the Microsoft documentation site to learn more about ODBC:

 

https://docs.microsoft.com/en-us/sql/odbc/microsoft-open-database-connectivity-odbc

Latest ODBC Drivers

Microsoft databases

https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server.

Oracle

https://www.oracle.com/database/technologies/instant-client/downloads.html

MySQL

https://dev.mysql.com/downloads/connector/odbc/

PostgreSQL

https://odbc.postgresql.org/

Informix

https://www.ciscounitytools.com/Applications/CxN/InformixODBC/InformixODBC.html

DB2

https://www-01.ibm.com/support/docview.wss?uid=swg27016878

SQLite

https://www.devart.com/odbc/sqlite/download.html

See also:

Connecting to the database

Quick start guide

 

Created with Help+Manual 7 and styled with Premium Pack Version 3 © by EC Software