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?
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