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
ODBC connection
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: ODBC connection
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
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
Those who throw objects at crocodiles should be asked to retreive 'em.
Re: ODBC connection
we have recreated the .odbc.ini and uvodbc.config files . It solved our problem.
Thanks
Kavuri
Thanks
Kavuri
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: