Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Problems connecting to db using SA 11.0.1.2376 on linux

3 posts in General Discussion Last posting was on 2010-02-19 20:58:55.0Z
Bill Williams Posted on 2010-02-19 13:19:11.0Z
From: "Bill Williams" <billwilliams@qcsoftware.com>
Newsgroups: ianywhere.public.general
Subject: Problems connecting to db using SA 11.0.1.2376 on linux
Lines: 61
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b7e8fcf$1@forums-1-dub>
Date: 19 Feb 2010 05:19:11 -0800
X-Trace: forums-1-dub 1266585551 10.22.241.152 (19 Feb 2010 05:19:11 -0800)
X-Original-Trace: 19 Feb 2010 05:19:11 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7898
Article PK: 6928

We have SA 11.0.1.2376 installed on a linux computer. We also have SA
10.0.1.3974 on this same computer. When a user logs in, they choose which
version they wish to run and then we run the correct sa_config.sh.

We have been using the version 10 for quite a while within our odbc
configuration files and iAnywhere JDBC with no problems. When I tried to
configure and use 11 in our odbc config files, we cannot connect to the
database using iAnywhere JDBC or the dbisql program.

Here is the entry in our odbcinst.ini file:

[Sybase SA 11.0.1]
Description = Sybase SQL Anywhere 11.0.1 driver
Driver = /opt/sybase/SYBSsa11/lib32/libdbodbc11_r.so
Setup = /opt/sybase/SYBSsa11/lib32/libdbodbc11_r.so
FileUsage = 1


It is basically identical to our 10 definition except for path and library
name.

Then in our odbc.ini, I simply change the Driver definition fpr the
connection I'm testing from "Sybase SA 10.0.1" to "Sybase SA 11.0.1".
That's the only change we make and from that point, we can no longer
connect.

Here is the dump of our program trying to connect with iAnywhere JDBC:

Unable to load 'Sybase SA 11.0.1' errno=2
Unable to load 'libodbc.so' errno=2
java.sql.SQLException: [Sybase][ODBC Driver Manager] Unable to load driver
Sybase SA 11.0.1
at ianywhere.ml.jdbcodbc.jdbc3.IDriver.makeODBCConnection(Native
Method)
at ianywhere.ml.jdbcodbc.jdbc3.IDriver.connect(IDriver.java:769)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at
Library.Database.DbConnectionManager.getConnection(DbConnectionManager.java:351)
at Products.QcApp.QcAppDbConn.openDb(QcAppDbConn.java:112)
at Products.QcApp.QcAppDbConn.openDb(QcAppDbConn.java:93)
at Products.QcApp.TaskThread.<init>(TaskThread.java:157)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at Products.QcApp.Config.setupThreads(Config.java:621)
at Products.QcApp.Config.load(Config.java:160)
at Products.QcApp.QcApp.qcAppMain(QcApp.java:170)
at Products.OrderMgr.OrderMgr.main(OrderMgr.java:47)

If we try to run dbisql, we get the first two lines above as an error. Now,
if we use dbisqlc, we can connect (doesn't that use jConnect?).

Another interesting thing is if we run the "isql" program that came with
unixODBC, it can connect as well so I'm not sure what's going on.


Karim Khamis [Sybase iAnywhere] Posted on 2010-02-19 14:23:49.0Z
From: "Karim Khamis [Sybase iAnywhere]" <kkhamis@sybase.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Problems connecting to db using SA 11.0.1.2376 on linux
References: <4b7e8fcf$1@forums-1-dub>
In-Reply-To: <4b7e8fcf$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b7e9ef5$1@forums-1-dub>
Date: 19 Feb 2010 06:23:49 -0800
X-Trace: forums-1-dub 1266589429 10.22.241.152 (19 Feb 2010 06:23:49 -0800)
X-Original-Trace: 19 Feb 2010 06:23:49 -0800, vip152.sybase.com
Lines: 78
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7900
Article PK: 6931

Bill,

I'm not sure why things were working for you in SA 10, except perhaps
simply because you had libodbc.so linked to the SA 10 ODBC driver.
However, the iAnywhere ODBC Driver Manager does not use odbcinst.ini
file, so in you odbc.ini, you cannot have:

Driver=Sybase SA 11.0.1

Instead, your odbc.ini file should have:

Driver=opt/sybase/SYBSsa11/lib32/libdbodbc11_r.so

Does that help, or did I misinterpret your information below?

Karim

Bill Williams wrote:
> We have SA 11.0.1.2376 installed on a linux computer. We also have SA
> 10.0.1.3974 on this same computer. When a user logs in, they choose which
> version they wish to run and then we run the correct sa_config.sh.
>
> We have been using the version 10 for quite a while within our odbc
> configuration files and iAnywhere JDBC with no problems. When I tried to
> configure and use 11 in our odbc config files, we cannot connect to the
> database using iAnywhere JDBC or the dbisql program.
>
> Here is the entry in our odbcinst.ini file:
>
> [Sybase SA 11.0.1]
> Description = Sybase SQL Anywhere 11.0.1 driver
> Driver = /opt/sybase/SYBSsa11/lib32/libdbodbc11_r.so
> Setup = /opt/sybase/SYBSsa11/lib32/libdbodbc11_r.so
> FileUsage = 1
>
>
> It is basically identical to our 10 definition except for path and library
> name.
>
> Then in our odbc.ini, I simply change the Driver definition fpr the
> connection I'm testing from "Sybase SA 10.0.1" to "Sybase SA 11.0.1".
> That's the only change we make and from that point, we can no longer
> connect.
>
> Here is the dump of our program trying to connect with iAnywhere JDBC:
>
> Unable to load 'Sybase SA 11.0.1' errno=2
> Unable to load 'libodbc.so' errno=2
> java.sql.SQLException: [Sybase][ODBC Driver Manager] Unable to load driver
> Sybase SA 11.0.1
> at ianywhere.ml.jdbcodbc.jdbc3.IDriver.makeODBCConnection(Native
> Method)
> at ianywhere.ml.jdbcodbc.jdbc3.IDriver.connect(IDriver.java:769)
> at java.sql.DriverManager.getConnection(DriverManager.java:582)
> at java.sql.DriverManager.getConnection(DriverManager.java:154)
> at
> Library.Database.DbConnectionManager.getConnection(DbConnectionManager.java:351)
> at Products.QcApp.QcAppDbConn.openDb(QcAppDbConn.java:112)
> at Products.QcApp.QcAppDbConn.openDb(QcAppDbConn.java:93)
> at Products.QcApp.TaskThread.<init>(TaskThread.java:157)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
> at Products.QcApp.Config.setupThreads(Config.java:621)
> at Products.QcApp.Config.load(Config.java:160)
> at Products.QcApp.QcApp.qcAppMain(QcApp.java:170)
> at Products.OrderMgr.OrderMgr.main(OrderMgr.java:47)
>
> If we try to run dbisql, we get the first two lines above as an error. Now,
> if we use dbisqlc, we can connect (doesn't that use jConnect?).
>
> Another interesting thing is if we run the "isql" program that came with
> unixODBC, it can connect as well so I'm not sure what's going on.
>
>


Bill Williams Posted on 2010-02-19 20:58:55.0Z
From: "Bill Williams" <billwilliams@qcsoftware.com>
Newsgroups: ianywhere.public.general
References: <4b7e8fcf$1@forums-1-dub> <4b7e9ef5$1@forums-1-dub>
Subject: Re: Problems connecting to db using SA 11.0.1.2376 on linux
Lines: 85
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b7efb8f$1@forums-1-dub>
Date: 19 Feb 2010 12:58:55 -0800
X-Trace: forums-1-dub 1266613135 10.22.241.152 (19 Feb 2010 12:58:55 -0800)
X-Original-Trace: 19 Feb 2010 12:58:55 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7904
Article PK: 6933

That took care of it!

Thanks!

"Karim Khamis [Sybase iAnywhere]" <kkhamis@sybase.com> wrote in message
news:4b7e9ef5$1@forums-1-dub...
> Bill,
>
> I'm not sure why things were working for you in SA 10, except perhaps
> simply because you had libodbc.so linked to the SA 10 ODBC driver.
> However, the iAnywhere ODBC Driver Manager does not use odbcinst.ini file,
> so in you odbc.ini, you cannot have:
>
> Driver=Sybase SA 11.0.1
>
> Instead, your odbc.ini file should have:
>
> Driver=opt/sybase/SYBSsa11/lib32/libdbodbc11_r.so
>
> Does that help, or did I misinterpret your information below?
>
> Karim
> Bill Williams wrote:
>> We have SA 11.0.1.2376 installed on a linux computer. We also have SA
>> 10.0.1.3974 on this same computer. When a user logs in, they choose
>> which version they wish to run and then we run the correct sa_config.sh.
>>
>> We have been using the version 10 for quite a while within our odbc
>> configuration files and iAnywhere JDBC with no problems. When I tried to
>> configure and use 11 in our odbc config files, we cannot connect to the
>> database using iAnywhere JDBC or the dbisql program.
>>
>> Here is the entry in our odbcinst.ini file:
>>
>> [Sybase SA 11.0.1]
>> Description = Sybase SQL Anywhere 11.0.1 driver
>> Driver = /opt/sybase/SYBSsa11/lib32/libdbodbc11_r.so
>> Setup = /opt/sybase/SYBSsa11/lib32/libdbodbc11_r.so
>> FileUsage = 1
>>
>>
>> It is basically identical to our 10 definition except for path and
>> library name.
>>
>> Then in our odbc.ini, I simply change the Driver definition fpr the
>> connection I'm testing from "Sybase SA 10.0.1" to "Sybase SA 11.0.1".
>> That's the only change we make and from that point, we can no longer
>> connect.
>>
>> Here is the dump of our program trying to connect with iAnywhere JDBC:
>>
>> Unable to load 'Sybase SA 11.0.1' errno=2
>> Unable to load 'libodbc.so' errno=2
>> java.sql.SQLException: [Sybase][ODBC Driver Manager] Unable to load
>> driver Sybase SA 11.0.1
>> at ianywhere.ml.jdbcodbc.jdbc3.IDriver.makeODBCConnection(Native
>> Method)
>> at ianywhere.ml.jdbcodbc.jdbc3.IDriver.connect(IDriver.java:769)
>> at java.sql.DriverManager.getConnection(DriverManager.java:582)
>> at java.sql.DriverManager.getConnection(DriverManager.java:154)
>> at
>> Library.Database.DbConnectionManager.getConnection(DbConnectionManager.java:351)
>> at Products.QcApp.QcAppDbConn.openDb(QcAppDbConn.java:112)
>> at Products.QcApp.QcAppDbConn.openDb(QcAppDbConn.java:93)
>> at Products.QcApp.TaskThread.<init>(TaskThread.java:157)
>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>> Method)
>> at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>> at
>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>> at
>> java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>> at Products.QcApp.Config.setupThreads(Config.java:621)
>> at Products.QcApp.Config.load(Config.java:160)
>> at Products.QcApp.QcApp.qcAppMain(QcApp.java:170)
>> at Products.OrderMgr.OrderMgr.main(OrderMgr.java:47)
>>
>> If we try to run dbisql, we get the first two lines above as an error.
>> Now, if we use dbisqlc, we can connect (doesn't that use jConnect?).
>>
>> Another interesting thing is if we run the "isql" program that came with
>> unixODBC, it can connect as well so I'm not sure what's going on.
>>