Home » SQL & PL/SQL » Client Tools » ODBC Instant Client oracle 10g (Client Oracle 10g Unix AIX 5)
ODBC Instant Client oracle 10g [message #462932] Mon, 28 June 2010 13:16 Go to next message
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



Re: ODBC Instant Client oracle 10g [message #462960 is a reply to message #462932] Mon, 28 June 2010 22:44 Go to previous message
BlackSwan
Messages: 26669
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

I see a lot involving ODBC in your post.
Why are you trying to use ODBC to connect to Oracle when other alternatives exist & tend to work with little or no setup?
Previous Topic: unable to get all views in crystal report tool
Next Topic: oracle tools
Goto Forum:
  


Current Time: Fri Apr 03 12:29:10 CDT 2020