[unixODBC-support] Library issue on Solaris and Oracle 11g

Jones, Tyrone TJones at l1id.com
Thu Oct 7 17:27:35 BST 2010


Hi,
I've successfully built and configured things on Solaris (as best I can tell) and am now trying to test things but getting the following error when using isql or iusql:

tyrone at aldev3:/usr/local/unixODBC/bin>isql alcisdev alint54a
[ISQL]ERROR: Could not SQLConnect
tyrone at aldev3:/usr/local/unixODBC/bin>iusql alcisdev alint54a
[ISQL]ERROR: Could not SQLDriverConnect

The generated trace log shows:
[ODBC][8801][1286461889.271971][SQLAllocHandle.c][493]
                Exit:[SQL_SUCCESS]
                        Output Handle = 2b5d0
[ODBC][8801][1286461889.272095][SQLConnect.c][3654]
                Entry:
                        Connection = 2b5d0
                        Server Name = [alcisdev][length = 8 (SQL_NTS)]
                        User Name = [alint54a][length = 8 (SQL_NTS)]
                        Authentication = [NULL]
                UNICODE Using encoding ASCII 'char' and UNICODE 'UCS-2-INTERNAL'

[ODBC][8801][1286461889.276545][SQLConnect.c][1106]Can't open lib '/dbora01/app/oracle/product/11.2.0/dbhome_1/lib/libsqora.so.11.1' : file not found

So I've tried updating the LD_LIBRARY_PATH, copying the above library to other locations /usr/lib, usr/local/unixODBC/lib but the error remains.

Any ideas? Thoughts? I've checked to mail archive back 3 years and didn't see anything.
Entries from the ini files below:

Odbcinst.ini

[ODBC]
Trace=Yes
TraceFile=/tmp/sql.log
ForceTrace=No
Pooling=No
UsageCount=1

[Oracle_ODBC_Driver_TJ]
Description=Oracle 11g R2 ODBC driver.
Driver=/dbora01/app/oracle/product/11.2.0/dbhome_1/lib/libsqora.so.11.1
Setup=
FileUsage=
CPTimeout=
CPReuse=
UsageCount=1


.odbc.ini
[alcisdev]
Application Attributes=T
Attributes=W
BatchAutocommitMode=IfAllSuccessful
CloseCursor=T
DisableDPM=F
DisableMTS=T
Driver=Oracle_ODBC_Driver_TJ
DSN=alcisdev
EXECSchemaOpt=
EXECSyntax=T
Failover=T
FailoverDelay=10
FailoverRetryCount=10
FetchBufferSize=64000
ForceWCHAR=F
Lobs=T
Longs=T
MetadataIdDefault=F
QueryTimeout=T
ResultSets=T
ServerName=172.28.10.80
SQLGetData extensions=F
Translation DLL=
Translation Option=0
UserID=alint54a
Password=alint54a
tyrone at aldev3:/usr/local/unixODBC/etc>cat ~/.odbc.ini
[alcisdev]
Application Attributes=T
Attributes=W
BatchAutocommitMode=IfAllSuccessful
CloseCursor=T
DisableDPM=F
DisableMTS=T
Driver=Oracle_ODBC_Driver_TJ
DSN=alcisdev
EXECSchemaOpt=
EXECSyntax=T
Failover=T
FailoverDelay=10
FailoverRetryCount=10
FetchBufferSize=64000
ForceWCHAR=F
Lobs=T
Longs=T
MetadataIdDefault=F
QueryTimeout=T
ResultSets=T
ServerName=172.28.10.80
SQLGetData extensions=F
Translation DLL=
Translation Option=0
UserID=alint54a
Password=alint54a
tyrone at aldev3:/usr/local/unixODBC/etc>cat ~/.odbc.ini
[alcisdev]
Application Attributes=T
Attributes=W
BatchAutocommitMode=IfAllSuccessful
CloseCursor=T
DisableDPM=F
DisableMTS=T
Driver=Oracle_ODBC_Driver_TJ
DSN=alcisdev
EXECSchemaOpt=
EXECSyntax=T
Failover=T
FailoverDelay=10
FailoverRetryCount=10
FetchBufferSize=64000
ForceWCHAR=F
Lobs=T
Longs=T
MetadataIdDefault=F
QueryTimeout=T
ResultSets=T
ServerName=172.28.10.80
SQLGetData extensions=F
Translation DLL=
Translation Option=0
UserID=alint54a
Password=alint54a
Tyrone Jones

[cid:image001.gif at 01CB6619.A679B240]<http://www.l1id.com/>

ph 978-215-2595
cell 508-572-7505

tjones at l1id.com<mailto:tjones at l1id.com>

www.L1ID.com<http://www.l1id.com/>



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20101007/d016f5ac/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 3621 bytes
Desc: image001.gif
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20101007/d016f5ac/attachment-0001.gif>


More information about the unixODBC-support mailing list