Page 1 of 1

ODBC error

Posted: Thu Jul 10, 2008 2:33 am
by ketanshah123
Hi all

While trying to importing table definition using ODBC table defintion option
I am getting following error. whats this error? How to resolve it?

we have set up new development server on that only getting the error .

Error message :

DSR.MetaGeta(GET.TABLES)(SQLTables): BCI Error: SQLSTATE=S1000,CODE=1248,[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver]Unhandled CodePoint: 35


thanx in advance

Posted: Thu Jul 10, 2008 3:23 am
by ray.wurlod
This error is being generated by the driver. You should contact Data Direct (the supplier of the driver).

Posted: Fri Jul 11, 2008 1:01 am
by keshav0307
do you see any thing like 'QEWSD=38843' in you .odbc.ini file?

Posted: Fri Jul 11, 2008 2:02 am
by arnabdey
Hi

Check whether you have set up the .odbc.ini (in Engine folder) and uvodbc.config file (in the Projects folder). The uvodbc file should mention the data source names and the .odbc.ini file should contain connectivity details like ip address, database driver etc

Thanks

Posted: Fri Jul 11, 2008 2:13 am
by ray.wurlod
Note: if your DataStage server is on Windows, then you will not have a .odbc.ini file - instead, ODBC.INI is a Registry entry. It is maintained using the ODBC Administrator (odbcad32.exe) on the DataStage server machine.