php-db | 2001011

[PHP-DB] a strange odbc_connect error message From: Alpay Alkan (aalkan <email protected>)
Date: 01/03/01

Hello everyone,

Using Joachim Steinhauser's installation rules in sqlanywhere group (thanks to Joachim), I have downloaded all of the
following sources and Installed them on Redhat 6.2 Linux

1) Apache_1.3.12
2) Php 4.0.4
3) Sybase ASA 7.0.1
4) UnixODBC-1.8.13

I can start asademo, php_info works well, ODBC DSN tested with DataManager
and odbctest (it is ok), Apache works, but just a single problem occurs:

When I try to connect database with the command
"odbc_connect("demo","dba","sql")", (demo is the nams of the system DSN) it
gives the following error:

"Warning: SQL error: [unixODBC][Driver Manager]Driver's SQLAllocHandle on
SQL_HANDLE_HENV failed, SQL state IM004 in SQLConnect ..."

Is it related with ODBC driver that I have selected in ODBCConfig???

I have added a new driver in ODBCConfig for ASA 7.0.1 with
    driver="opt/sybase/SYBSsa7/lib/libodbc7.so
    setup="opt/sybase/SYBSsa7/lib/libodbc7.so
    file usage=1

options. As I said before, it works in DataManager.

Any help will be very very good. Thanks a lot to everyone that read this
message

Bye

Alpay Alkan