Error: undefined symbol SQLAllocEnv at PHP

[my5660]

Hello,

I am not able to connect to a sybase database via unixODBC in PHP, but testing with isql its able to connect. my server is using based on the SuSE 9.3 distribution,

here my ODBC Setting
ODBC.ini stored in etc/unixODBC

[ODBC Data Sources]
ts_dsn=Adaptive Server Anywhere 9.0

[ts_dsn]
Userid=xxx
Password=yyy
ServerName=hsab_sbs2003
CommLinks=tcpip(host=192.168.0.12;port=2936)
Driver=lbdbodbc9.so

testing with isql its able to connect

For testing the connection I used this file: /srv/www/project/test.php
<?
echo "Begin";
$conn=odbc_connect("ts_dsn","xxx","yyy")
or die ("Failure");

echo "End";
?>

When calling this file, there ist only the text "Begin" displayed in the
browser window. No error. But an error is logged in
/var/log/apache2/error_log:
"/usr/sbin/httpd2-prefork: error while loading shared libraries:
/usr/lib/php/extensions/unixODBC.so: undefined symbol: SQLAllocEnv"

Do you have got an idea what went wrong?

[till]

PHP cant load the unixODBC.so. Is the file:

/usr/lib/php/extensions/unixODBC.so

there?. Have you installed the unixODBC extension from your linux distribution or did you compile PHP manually?

[my5660]

Originally Posted by till

PHP cant load the unixODBC.so. Is the file:

/usr/lib/php/extensions/unixODBC.so

there?. Have you installed the unixODBC extension from your linux distribution or did you compile PHP manually?

yes i installed the unixODBC extension from my linux distribution, and yes unixODBC.so is in /usr/lib/php/extensions/unixODBC.so

[falko]

Originally Posted by my5660

yes i installed the unixODBC extension from my linux distribution, and yes unixODBC.so is in /usr/lib/php/extensions/unixODBC.so

Have you enabled it in your php.ini? Don't forget to restart Apache afterwards.

[my5660]

Originally Posted by falko

Have you enabled it in your php.ini? Don't forget to restart Apache afterwards.

its enabled by default

[falko]

Does it show up as enabled when you run

PHP Code:

phpinfo(); 


in a PHP script?

[my5660]

do you mean UnixODBC or ODBC..?

[till]

Please have a look here:

http://www.susewiki.org/index.php?title=PHP4_ODBC

[my5660]

Originally Posted by till

Please have a look here:

http://www.susewiki.org/index.php?title=PHP4_ODBC

wow,its working...thanks alot till