Connection string format (JDBC and ODBC)

JDBC connection string format

Neteza JDBC
-------------------------------------------------
JDBC: netezza: // IPaddress: portnumber/database_name
Org. netezza. Driver

Sybase 12.5
-------------------------------------------------

JDBC: Sybase: TDS: Hostname: portnumber/database_name
Com. Sybase. jdbc2.jdbc. sybdriver

SQL Server 2005
-------------------------------------------------
Com. Microsoft. sqlserver. JDBC. sqlserverdriver
JDBC: sqlserver: // hostname: portnumber; database = database_name

SQL Server 2000
-------------------------------------------------
JDBC: Microsoft: sqlserver: // hostname: portnumber
Com. Microsoft. JDBC. sqlserver. sqlserverdriver

Oracle
-------------------------------------------------
JDBC: oracle: thin: @ hostname: portnumber: database_name
Oracle. JDBC. Driver. oracledriver

IBM DB2
-------------------------------------------------
Type2
JDBC: DB2: ibm_db28
Com. IBM. db2.jdbc. App. db2driver
Type4
JDBC: DB2: // hostname: portnumber/database_name
Com. IBM. db2.jcc. db2driver

My SQL
-------------------------------------------------
JDBC: mysql: // hostname: portnumber/database_name
Com. MySQL. JDBC. Driver

Teradata
-------------------------------------------------
JDBC: teradata: // hostname
Com. NCR. teradata. teradriver

 

OS/390
-------------------------------------------------
JDBC: DB2: // hostname: portnumber/database_name

JDBC: DB2: // hostname: portnumber/database_name

Com. IBM. db2.jcc. db2driver

Progress type2
-------------------------------------------------
JDBC: jdbcprogress: T: Hostname: portnumber: database_name

Com. Progress. SQL. JDBC. jdbcprogressdriver

Progress type4 (10.1b)
-------------------------------------------------

JDBC: DataDirect: OpenEdge: // hostname: portnumber; databasename =

Com. ddtek. JDBC. OpenEdge. openedgedriver

Sybaseiq 12.7
-------------------------------------------------
JDBC: Sybase: TDS: Hostname: portnumber
Com. Sybase. jdbc3.jdbc. sybdriver

Sybase
-------------------------------------------------
JDBC: Sybase: TDS: Hostname: portnumber
Com. Sybase. jdbc3.jdbc. sybdriver

Informix 11

-------------------------------------------------
JDBC: Informix-sqli: // hostname: portnumber/database_name: informixserver = xxx; db_locale = en_us.57372

Com. Informix. JDBC. ifxdriver

Informix
JDBC: Informix-sqli: // hostname: portnumber/database_name: informixserver = xxxx

Com. Informix. JDBC. ifxdriver

-------------------------------------------------
Derby 10.2
JDBC: Derby: C:/Derby/database_name; Create = true
Org. Apache. Derby. JDBC. embeddeddriver

 

ODBC connection string format:

 

IBM DB2:
-------------------------------------------------
Driver = {IBM DB2 ODBC driver}; database = xxx; hostname = xxx; Port = 50000; Protocol = TCPIP; uid = xxx; Pwd = xxx;

MSSQL Server 2005:
-------------------------------------------------
Driver = {SQL native client}; server = xxx; database = xxx; uid = xxx; Pwd = xxx;

MSSQL Server 2000:
-------------------------------------------------
Driver = {SQL Server}; server = xxx; database = xxx; uid = xxx; Pwd = xxx;

MySQL:
-------------------------------------------------
Driver = {MySQL ODBC 3.51 driver}; server = xxx; database = xxx; user = xxx; Password = xxx; option = 3;

Sybase 12.5:
-------------------------------------------------
Driver = {Sybase ase odbc driver}; NA = xxx, portnumber; uid = xxx; Pwd = xxx;

Microsoft Excel 2003:
-------------------------------------------------
Driver = {Microsoft Excel Driver (*. xls)}; driverid = xxx; DBQ = C:/excel_database.xls; defaultdir = C:/mypath;

Access 2003:
-------------------------------------------------
Driver = {Microsoft Access Driver (*. mdb)}; DBQ = C:/access_database.mdb; uid = xxx; Pwd =; xxxx
 
Driver = {Microsoft Access Driver (*. mdb)}; DBQ = C:/access_database.mdb; systemdb = C:/secured. MDW;

Text:
-------------------------------------------------
Driver = {Microsoft text Driver (*. txt; *. CSV)}; DBQ = C:/text_file; extensions = ASC, CSV, tab, txt;