DSXchange

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

add a blank line after each entry in the project level odbc...I know it sounds weird...and also spell it the same [DB2_SEMATST] and <DB2_SEMSTST>

The names are spelled differently in the two files. Is it DB2_SEMATST or DB2_SEMSTST ?

Thanks to everyone. As pointed out it was typo on DSN names between the .odbc.ini and uvodbc.config files.