linux odbc db2V9.7

 

/opt/Sybase/EAServer6/odbc/odbc.ini

 

[EAServer Default Sybase]

Driver          = SYBASE

Trace           = no

Server          = SYBASE

Port            = 5000

Database        = tempdb

uid             = sa

 

[EAServer Default ASA]

Driver          = SYBASA

Trace           = no

TraceFile       = sql.log

Port            = 4000

ServerName      = default

TDS_Version     = 5.0

//在linux redhat 5.4 的db2cc(用db2inst1登陆)没有看到ODBC的连接，有“标准，CLI，JDBC”

//在db2里把JDGJJ及JDGJJ222都配置好

[ODBC Data Sources]

JDGJJ=IBM DB2 ODBC Driver(本机的)

JDGJJ222=IBM DB2 ODBC Driver（远程的）

 

[JDGJJ]

Driver=/opt/ibm/db2/V9.7/lib32/libdb2.so

Description=JDGJJ DB2 ODBC Database

Database=JDGJJ

[JDGJJ222]

Driver=/opt/ibm/db2/V9.7/lib32/libdb2.so

Description=JDGJJ222 DB2 ODBC Database

Database=JDGJJ222

 

EASERVER6.3里的Ping 就通了