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,
Retreive Metadata problem
Moderators: chulett, rschirm, roy
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.
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.
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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 wrote:u r wlcm.
mat
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.