DSXchange

Hi,
while I am trying to connect to db2 server by using ODBC table definition to load columns in Designer, I am getting the following problem.

DSR.MetaGeta(GET.TABLES)(SQLConnect('bhi','bhi')): BCI Error:
SQLSTATE=IM997,CODE=0,[DataStage][SQL Client]An illegal configuration option was found

Can anybody give me what is the problem. If at all to clear what files need to be modified, such as : ODBC.ini, dsenv. etc.

If you can provide configuration file examples, It is most appreciated.

Thanks
Kavuri

Check first in uvodbc.config then in .odbc.ini. You are looking for an illegal configuration option. If you don't find it there you might also look at uci.config in the $DSHOME directory.

Once you got the entry for DB2 configured, here what I recommended trying before trying the connectivity from DataStage:

1) source your dsenv file (in DESngine directory: ". ./dsenv"
2) go to ../server/branded_odbc/demo directory
3) run the demoodbc program and try to connect to your database, like this:

[dsadm@lbc-01 demo]$ ./demoodbc
./demoodbc DataDirect Technologies, Inc. ODBC Sample Application.
Usage: ./demoodbc [-uid username] [-pwd password] [-xml] DSN.

example: ./demoodbc -uid mike -pwd mypass MyDB2

it should come back and say that EMP table not found, which is okay ... it means that it connected to the database but was unable to find the request table (EMP). Now you can try connecting from DataStage to your DB2

we have recreated the .odbc.ini and uvodbc.config files . It solved our problem.

Thanks
Kavuri

What did you do that was different, and fixed the problem?