Need help using PHP ODBC to connect Postgress 7.1.1

From: "Allan Rafuse" <allan(at)freeview(dot)com>
To: "PG-General" <pgsql-general(at)postgresql(dot)org>
Subject: Need help using PHP ODBC to connect Postgress 7.1.1
Date: 2001-05-16 23:06:31
Message-ID: E150AN4-0004LI-00@mailer.freeview.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)freeview(dot)com
web: http://www.freeview.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-05-16 23:06:48 Re: Re: Queries across multiple databases (was: SELECT from a table in another database).
Previous Message Tom Lane 2001-05-16 23:01:44 Re: Restore from a dead machine.