I am new to Linux but I need to set up an ODBC connection
between Java and PHP applications and SQL Anywhere 11
databases. I have installed unixODBC 2.2.12 on Fedora 10 and
at the moment I have the following settings:

/etc/odbcinst.ini:
[SQLAnywhere11]
Description = ODBC for Sybase SQL Anywhere 11
Driver = /opt/sqlanywhere11/lib32/libdbodbc11.so
Setup = /opt/sqlanywhere11/lib32/libdbodbc11.so
FileUsage = 1
DontDLClose = 1
UsageCount = 1

/home/hans/.odbc.ini:
[elecdata_usr]
Description = elecdata_usr
Driver = SQLAnywhere11
Trace = No
TraceFile =
Database = elecdata
DatabaseFile =
Servername = elecdata_server
Username =
Password =
Port = 2639
Protocol = TCP
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
Host = localhost
Namespace =
Query Timeout = 1
Static Cursors = 0

/etc/sybase.conf:
/opt/sqlanywhere11/lib32

/etc/ld.so.conf:
include ld.so.conf.d/*.conf

Now when the database server is running I can connect to my
database in Sybase Central with a connection profile using
ODBC Datasource name: elecdata_usr so this is okay. However
when I try to connect to ODBC profile: elecdata_usr using
ANY other application that application simply vanishes,
meaning something illegal happens and I suspect the problem
lies in the Sybase driver(s). I have tried many different
settings, including mentioning the driver directly in the
ODBC profile and connecting directly to the database file
instead of to a database server but the problem persists. I
have also tried ODBC system accounts instead of user
accounts but to no avail.

Can someone please point me in the right direction of what I
might be missing or doing wrong? Thanks!

I'll ask for some more information and maybe somebody will pick up on
this....

First of all, what build number of SA11 are you using? When you say
"any other applicaton" can you give an example? How are you using it?
Are you on a 64-bit machine? You're using the 32-bit libraries...is it
a 64-bit application? Is the environment set up correctly for your
application?

You're using the non-threaded libdbodbc11.so, what if you try the
threaded one (libdbodbc11_r.so)? If your application is threaded, this
could certainly be the problem.

What happens if you use our ODBC driver (libdbodm) instead of using the
odbc driver directly?

Thanks,
Phil

Hans Smallegoor wrote:

I'll ask for some more information and maybe somebody will pick up on
this....

First of all, what build number of SA11 are you using? When you say
"any other applicaton" can you give an example? How are you using it?
Are you on a 64-bit machine? You're using the 32-bit libraries...is it
a 64-bit application? Is the environment set up correctly for your
application?

You're using the non-threaded libdbodbc11.so, what if you try the
threaded one (libdbodbc11_r.so)? If your application is threaded, this
could certainly be the problem.

What happens if you use our ODBC driver (libdbodm) instead of using the
odbc driver directly?

Thanks,
Phil

Hans Smallegoor wrote:

I'll ask for some more information and maybe somebody will pick up on
this....

First of all, what build number of SA11 are you using? When you say
"any other applicaton" can you give an example? How are you using it?
Are you on a 64-bit machine? You're using the 32-bit libraries...is it
a 64-bit application? Is the environment set up correctly for your
application?

You're using the non-threaded libdbodbc11.so, what if you try the
threaded one (libdbodbc11_r.so)? If your application is threaded, this
could certainly be the problem.

What happens if you use our ODBC driver (libdbodm) instead of using the
odbc driver directly?

Thanks,
Phil

Hans Smallegoor wrote:

I'll ask for some more information and maybe somebody will pick up on
this....

First of all, what build number of SA11 are you using? When you say
"any other applicaton" can you give an example? How are you using it?
Are you on a 64-bit machine? You're using the 32-bit libraries...is it
a 64-bit application? Is the environment set up correctly for your
application?

You're using the non-threaded libdbodbc11.so, what if you try the
threaded one (libdbodbc11_r.so)? If your application is threaded, this
could certainly be the problem.

What happens if you use our ODBC driver (libdbodm) instead of using the
odbc driver directly?

Thanks,
Phil

Hans Smallegoor wrote:

I'll ask for some more information and maybe somebody will pick up on
this....

First of all, what build number of SA11 are you using? When you say
"any other applicaton" can you give an example? How are you using it?
Are you on a 64-bit machine? You're using the 32-bit libraries...is it
a 64-bit application? Is the environment set up correctly for your
application?

You're using the non-threaded libdbodbc11.so, what if you try the
threaded one (libdbodbc11_r.so)? If your application is threaded, this
could certainly be the problem.

What happens if you use our ODBC driver (libdbodm) instead of using the
odbc driver directly?

Thanks,
Phil

Hans Smallegoor wrote:

I'll ask for some more information and maybe somebody will pick up on
this....

First of all, what build number of SA11 are you using? When you say
"any other applicaton" can you give an example? How are you using it?
Are you on a 64-bit machine? You're using the 32-bit libraries...is it
a 64-bit application? Is the environment set up correctly for your
application?

You're using the non-threaded libdbodbc11.so, what if you try the
threaded one (libdbodbc11_r.so)? If your application is threaded, this
could certainly be the problem.

What happens if you use our ODBC driver (libdbodm) instead of using the
odbc driver directly?

Thanks,
Phil

Hans Smallegoor wrote:

I'll ask for some more information and maybe somebody will pick up on
this....

First of all, what build number of SA11 are you using? When you say
"any other applicaton" can you give an example? How are you using it?
Are you on a 64-bit machine? You're using the 32-bit libraries...is it
a 64-bit application? Is the environment set up correctly for your
application?

You're using the non-threaded libdbodbc11.so, what if you try the
threaded one (libdbodbc11_r.so)? If your application is threaded, this
could certainly be the problem.

What happens if you use our ODBC driver (libdbodm) instead of using the
odbc driver directly?

Thanks,
Phil

Hans Smallegoor wrote:

I'll ask for some more information and maybe somebody will pick up on
this....

First of all, what build number of SA11 are you using? When you say
"any other applicaton" can you give an example? How are you using it?
Are you on a 64-bit machine? You're using the 32-bit libraries...is it
a 64-bit application? Is the environment set up correctly for your
application?

You're using the non-threaded libdbodbc11.so, what if you try the
threaded one (libdbodbc11_r.so)? If your application is threaded, this
could certainly be the problem.

What happens if you use our ODBC driver (libdbodm) instead of using the
odbc driver directly?

Thanks,
Phil

Hans Smallegoor wrote:

I'll ask for some more information and maybe somebody will pick up on
this....

First of all, what build number of SA11 are you using? When you say
"any other applicaton" can you give an example? How are you using it?
Are you on a 64-bit machine? You're using the 32-bit libraries...is it
a 64-bit application? Is the environment set up correctly for your
application?

You're using the non-threaded libdbodbc11.so, what if you try the
threaded one (libdbodbc11_r.so)? If your application is threaded, this
could certainly be the problem.

What happens if you use our ODBC driver (libdbodm) instead of using the
odbc driver directly?

Thanks,
Phil

Hans Smallegoor wrote: