Retreive Metadata problem

[anilkona]

We get the following error when trying to import table definitions. We are making a connection to DB2 database using Ascential's ODBC drivers, IBMrios-odbc-5.0.050414.

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

Any ideas on what this could be?

Thanks and appreciate your help,

[ml]

Hi, did you try to test the connection and the driver?

cd `cat /.dshome`
. ./dsenv
cd ../branded_odbc/demo
./demoodbc
./demoodbc dsnname -uid username -pwd password

(or run ./bin/dssh and then >LOGTO project_name >DS_CONNECT DSN)

then test the driver

cd DSEngine/bin
./ivtestlib DriverName

for AS400 you need to run the bind command.

mat.

[anilkona]

When I try to test the ODBC, we get the following error:

SQLConnect: Failed...
SQLSTATE = 77
NATIVE ERROR = 0
MSG = 523 76

SQLConnect: Retrying Connect.
SQLConnect: Failed...
SQLSTATE = 77
NATIVE ERROR = 0
MSG = 523 76

SQLConnect: Retrying Connect.
SQLConnect: Failed...
SQLSTATE = 77
NATIVE ERROR = 0
MSG = 523 76

SQLConnect: Retrying Connect.
No connection could be established.

[elavenil]

Check all the entries for this datasource in .ODBC.ini file. DSN name and driver name are to be verified in the INI file.

Regards
Saravanan

[anilkona]

This is resolved. There was a problem in the odbc.ini file.

Thanks Mat for your time,
-Anil

[ml]

u r wlcm.

by the way to test the driver you should go to "branded_odbc/bin" directory (instead DSEngine/bin -sorry) and run ./ivtestlib DriverName

mat

[ray.wurlod]

u r wlcm.
mat

You seem to be in a locale where there is a shortage of vowels. Do you create your system documentation thus? Please don't do it here - not everyone here has English as a first language, so these kinds of abbreviation aren't helpful.

[ml]

It wasn't my intention to create confusion for dsx users (sorry DSXchange users)

:D