| ODBC Instant Client oracle 10g [message #462932] |
Mon, 28 June 2010 13:16  |
beginoracle68
Messages: 1
Registered: June 2010
|
Junior Member |
|
|
Hi,
The version is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi.
for Unix AIX 5
I install the ODBC Driver Manager, Basic Instant Client, ODBC Instant Client packages (libsqora.so, odbc_update_ini.sh).
The error:
[oracle@d4 oracle] $ isql OracleODBC-10g user passtemp -v
[01000][unixODBC][Driver Manager]Can't open lib '/home/oracle/instantclient_10_2/libsqora.so' : file not found
[ISQL]ERROR: Could not SQLConnect
Consiguration
odbcinst.ini
[Oracle10gODBCdriver]
Description = Oracle ODBC driver for Oracle 10g
Driver = /u01/app/oracle/product/10.2.0/db_1/lib/libsqora.so
Setup =
FileUsage =
CPTimeout =
CPReuse =
The documentation explic with exists the file libsqora.so.10.1 but not exists in the ODBC Instant Client packages.
I aplied ln -s libsqora.so.10.1 libsqora.so but the conection not function
odbc.ini
[oradns]
Application Attributes=T
Attributes=W
BatchAutocommitMode=IfAllSuccessful
CloseCursor=T
DisableDPM=F
DisableMTS=T
Driver=Oracle10gODBCdriver
DSN=oradns
EXECSchemaOpt=
EXECSyntax=T
Failover=T
FailoverDelay=10
FailoverRetryCount=10
FetchBufferSize=64000
ForceWCHAR=F
Lobs=T
Longs=T
MetadataIdDefault=F
QueryTimeout=T
ResultSets=T
ServerName=NAME_SERVER_IN_THE_TNSNAME
SQLGetData extensions=F
Translation DLL=
Translation Option=0
userID=
[oracle@d4 oracle] $ echo $LD_LIBRARY_PATH
/usr/lib:/lib:/u01/app/oracle/product/10.2.0/db_1/lib
Thanks for your suggestions
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
