unixODBC error code SQL10007N Message "0" could not be retrieved. Reason code: "3"

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

unixODBC error code SQL10007N Message "0" could not be retrieved. Reason code: "3"

Chaowat Kaewphueag

Dear unixODBC Support,

 

I got an issue when install unixODBC on AIX 7.1. The error message and configuration as detail, please suggest solution.

 

Error:

> isql -v SA_TRN db2inst1 db2lcm13

[     ][unixODBC][IBM][CLI Driver] SQL10007N Message "0" could not be retrieved.  Reason code: "3".

 

[ISQL]ERROR: Could not SQLConnect

 

ENV:

> env

_=/usr/bin/env

MANPATH=${MANPATH}:/opt/ibm/director/man

LANG=en_US

LOGIN=oracle

DB2LIB=/v01/db2/dsdriver/./lib

ODBC_HOME=/v01/ibm/dsdriver

LISTENER_NAME=LISTENER_MFDHSIT

CLCMD_PASSTHRU=1

PATH=/v01/db2/dsdriver/./adm:/v01/db2/dsdriver/./bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:/usr/java71_64/bin:/usr/local/bin:.:/v01/oracle/product/12.1.0/dbhome_1/bin

NLS_LANG=AMERICAN_AMERICA.TH8TISASCII

ORACLE_BASE=/v01/oracle

DB2CODEPAGE=874

LC__FASTMSG=true

ORACLE_HOME_LISTNER=/v01/oracle/product/12.1.0/dbhome_1

CLASSPATH=/v01/db2/dsdriver/./rdf/lib/antlr-3.3-java.jar:/v01/db2/dsdriver/./tools/jline-0.9.93.jar:/v01/db2/dsdriver/./tools/clpplus.jar:/v01/db2/dsdriver/./java/sqlj.zip:/v01/db2/dsdriver/./java/db2jcc.jar:

LOGNAME=oracle

MAIL=/usr/spool/mail/oracle

ORACLE_SID=MFDHSIT

LOCPATH=/usr/lib/nls/loc

IBM_DB_INCLUDE=/v01/db2/dsdriver/./include

PS1=stmmfdhdd1:[oracle@MFDHSIT]:$PWD>

USER=oracle

AUTHSTATE=files

LC_MESSAGES=

DB2_HOME=/v01/db2/dsdriver/./include

SHELL=/usr/bin/ksh

ODMDIR=/etc/objrepos

JAVA_HOME=/usr/java71_64

LD_LIBRARY_PATH_64=/v01/oracle/product/12.1.0/dbhome_1/lib

HOME=/home/oracle

DB2INSTANCE=db2inst1

TERM=vt100

MAILMSG=[YOU HAVE NEW MAIL]

ORACLE_HOME=/v01/oracle/product/12.1.0/dbhome_1

IBM_DB_DIR=/v01/db2/dsdriver/.

PWD=/v01/db2/dsdriver

TZ=Asia/Bangkok

ENV=/home/oracle/.kshrc

AIXTHREAD_SCOPE=S

IBM_DB_LIB=/v01/db2/dsdriver/./lib

A__z=! LOGNAME

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat:/usr/lib/nls/msg/%l.%c/%N:/usr/lib/nls/msg/%l.%c/%N.cat

LIBPATH=/v01/db2/dsdriver/./lib:/v01/oracle/product/12.1.0/dbhome_1/lib

LD_LIBRARY_PATH=/v01/oracle/product/12.1.0/dbhome_1/lib:/v01/oracle/product/12.1.0/dbhome_1/network/lib:/v01/oracle/product/12.1.0/dbhome_1/lib32

 

db2cli.ini:

; Comment lines start with a semi-colon.

 

;[tstcli1x]

;uid=userid

;pwd=password

;autocommit=0

;TableType="'TABLE','VIEW','SYSTEM TABLE'"

 

;[tstcli2x]

; Assuming dbalias2 is a database in DB2 for MVS.

;SchemaList="'OWNER1','OWNER2',CURRENT SQLID"

 

;[MyVeryLongDBALIASName]

;dbalias=dbalias3

;SysSchema=MYSCHEMA

 

[SA_TRN]

Database=SA_TRN

Protocol=TCPIP

Port=50001

Hostname=10.200.145.52

UID=db2inst1

PWD=abcdef

 

odbc.ini:

[ODBC Data Sources]

DEFAULT = Default Connection

SA_TRN = Connection to DB2

 

[DEFAULT]

Description = Default Connection

Driver = DB2_ODBC_DRIVER

 

[SA_TRN]

Description = Connection to DB2

Driver = DB2_ODBC_DRIVER

#DMEnvAttr = SQL_ATTR_UNIXODBC_ENVATTR={DB2_CLI_DRIVER_INSTALL_PATH=/v01/db2/dsdriver/lib:DB2INSTANCE=db2inst1}

DMEnvAttr = SQL_ATTR_UNIXODBC_ENVATTR={DB2_CLI_DRIVER_INSTALL_PATH=/v01/db2/dsdriver/lib}

 

[ODBC]

Trace=Yes

TraceFile=/v01/db2/dsdriver/odbctrace.out

InstallDir=/v01/db2/dsdriver

ConversionTableLocation=/v01/db2/dsdriver/tables

UseCursorLib=0

 

odbcinst.ini:

[DEFAULT]

Description = Default driver

Driver = /v01/db2/dsdriver/lib/db2o.o

FileUsage=1

DontDLClose=1

 

[DB2_ODBC_DRIVER]

Description=IBM DB2 ODBC driver (64-bit)

Driver=/v01/db2/dsdriver/lib/db2o.o

#Driver=/v01/db2/dsdriver/lib32/libdb2.a

 

[ODBC]

Trace=Yes

TraceFile=/v01/db2/dsdriver/trace.out

 

Best regards,

Chaowat Kaewphueag



****************************************************************************************
CONFIDENTIALITY & DISCLAIMER
The information contained in this e-mail may be confidential, proprietary and/or legally privileged.
If you are not the intended recipient of this e-mail, please delete and destroy all copies immediately.
Any review, dissemination, copy, retransmission, distribution or use of this e-mail in any form
for any purpose is strictly prohibited. The sender accepts noresponsibility for any miss transmission
of, or interference with, this e-mail.
Thank you.
****************************************************************************************
_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|

Re: unixODBC error code SQL10007N Message "0" could not be retrieved. Reason code: "3"

Michael König
Hi Chaowat!

I don't think this is a unixODBC issue. I guess you should direct your question to the DB2 folks. Maybe this link solves your issue:

https://www-304.ibm.com/support/docview.wss?uid=swg21474604

Cheers

Michael

Dear unixODBC Support,

 

I got an issue when install unixODBC on AIX 7.1. The error message and configuration as detail, please suggest solution.

 

Error:

> isql -v SA_TRN db2inst1 db2lcm13

[     ][unixODBC][IBM][CLI Driver] SQL10007N Message "0" could not be retrieved.  Reason code: "3".

 

[ISQL]ERROR: Could not SQLConnect

 


_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support