Page 1 of 1
Retreive Metadata problem
Posted: Thu Jul 07, 2005 3:21 pm
by 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,
Posted: Sat Jul 09, 2005 12:03 am
by 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.
Posted: Sat Jul 09, 2005 10:06 am
by 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.
Posted: Sun Jul 10, 2005 3:50 am
by 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
Posted: Mon Jul 11, 2005 11:17 am
by anilkona
This is resolved. There was a problem in the odbc.ini file.
Thanks Mat for your time,
-Anil
Posted: Mon Jul 11, 2005 7:00 pm
by 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
Posted: Mon Jul 11, 2005 7:30 pm
by ray.wurlod
ml wrote: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.
Posted: Tue Jul 12, 2005 12:28 pm
by ml
It wasn't my intention to create confusion for dsx users (sorry DSXchange users)
:D