Need help using PHP ODBC to connect Postgress 7.1.1 - Mailing list pgsql-general

I'm having trouble setting up a remote Apache PHP webserver to connect to
our postgres machine using ODBC.

This is what I get when trying to connect with the odbc_connect statement:

Warning: SQL error: Missing server name, port, or database name in call to
CC_connect., SQL state IM002 in SQLConnect in
/www/virtual/firebird/common/pre.php on line 25

I've checked the log, and found:
DSN info: DSN='panoramaSQL',server='',port='',dbase='',user='',passwd=''
          onlyread='',protocol='',showoid='',fakeoidindex='',showsystable=''
          conn_settings='',conn_encoding='OHTER'
          translation_dll='',translation_option=''
conn = 138389968, SQLConnect(DSN='panoramaSQL', UID='remotesite', PWD='password_is_set')
Global Options: Version='07.01.0005', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254,
max_longvarchar_size=8190
                disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
                text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
                extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='OHTER'
CONN ERROR: func=SQLConnect, desc='Error on CC_connect', errnum=101, errmsg='Could not connect to the server'
            ------------------------------------------------------------
            henv=138348392, conn=138389968, status=0, num_stmts=16
            sock=138396432, stmts=138304368, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=-1, reverse=0, errornumber=2, errormsg='Could not resolve hostname.'
            buffer_in=138396472, buffer_out=138385616
            buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0


As you see there is no server or port parameter, but they exist in my
odbcinst.ini and odbc.ini

odbcinst.ini:
    [PostgreSQL]
    Debug=0
    CommLog=1

odbc.ini:
    ;
    ;  odbc.ini
    ;
    [ODBC Data Sources]
    panoramaSQL = Connection to Panorama

    [panoramaSQL]
    Driver = /usr/local/pgsql/lib/libpsqlodbc.so
    Servername=pgsq1.freeview.com
    Username=modularwebsites
    Password=test4sql
    Database=worldofsoccer_com
    Port=5432
    ReadOnly = no
    Trace = 1
    TraceFile = /tmp/odbc.log

    [ODBC]
    InstallDir      = /usr/local/pgsql/lib


PHP Was compiled with: ./configure --with-apache=/usr/src/apache_1.3.12-ssl \
--with-mysql=/usr/local/mysql --enable-track-vars --with-imap --with-jpeg-dir=/usr/local/bin
--with-gd=/usr/local --with-ttf --with-pgsql --with-iodbc

Apache Was Compiled with:
./configure --with-layout=Apache --prefix=/usr/local/apache-ssl --enable-module=info
--enable-module=log_referer --enable-module=mime_magic --enable-module=mmap_static
--enable-module=status --activate-module=src/modules/php4/libphp4.a
--enable-module=rewrite"

iODBC (libiodbc-2.50.3) Compiled with:
./configure  --prefix=/usr/local --with-iodbc-inidir=/etc

Postgres 7.1.1 Compiled with:
./configure  --with-perl --enable-multibyte --enable-unicode-converstion --enable-odbc

Thank you for any help!!!
 -Allan


<- Allan Rafuse ->
Systems Administrator
Freeview Publishing Inc.
email: allan@freeview.com
web: http://www.freeview.com