Error: undefined symbol SQLAllocEnv at PHP

Discussion in 'Technical' started by my5660, Jan 1, 2006.

  1. my5660

    my5660 New Member

    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?:confused:
     
  2. till

    till Super Moderator

    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?
     
  3. my5660

    my5660 New Member

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

    falko Super Moderator

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

    my5660 New Member

    its enabled by default
     
    Last edited: Jan 2, 2006
  6. falko

    falko Super Moderator

    Does it show up as enabled when you run
    PHP:
    phpinfo();
    in a PHP script?
     
  7. my5660

    my5660 New Member

    do you mean UnixODBC or ODBC..?
     
  8. till

    till Super Moderator

  9. my5660

    my5660 New Member

Share This Page