Hi,
I'm trying to setup the ODBC connectivity to DB2 database by adding the following DSN details at .odbc.ini file.
[DB2_SEMATST]
Driver=/fs2/IBM/InformationServer/Server/branded_odbc/lib/VMdb222.so
Description=DataDirect DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=11.16.154.52
IsolationLevel=CURSOR_STABILITY
Location=SEMATST
LogonID=idmusr
Password=idmusr
Package=db2inst1
PackageOwner=
TcpPort=50000
WithHold=1
Also updated the uvodbc.config file at the project level with the following entries:
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
<ORA_EPIMRKT>
DBMSTYPE = ODBC
<DB2_SEMSTST>
DBMSTYPE = ODBC
While trying to import the table definitions through ODBC I'm getting the following error.
DSR.MetaGeta(GET.DSNINFO)(SQLConnect('DB2_SEMSTST','idmusr')): BCI Error:
SQLSTATE=IM002,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Data source name not found and no default driver specified
Any help would be appreciated.
Thanks
Vijay R
Db2-ODBC Connectivity Issue (AIX 5.3)
Moderators: chulett, rschirm, roy
Db2-ODBC Connectivity Issue (AIX 5.3)
Thanks
Vijay R
Vijay R
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: