Postgres 7.1, iODBC and PHP4

Поиск
Список
Период
Сортировка
От Przem Kowalczyk
Тема Postgres 7.1, iODBC and PHP4
Дата
Msg-id 9bpbci$2jpd$1@news.tht.net
обсуждение исходный текст
Список pgsql-general
Hi.

I've encountered some problems with settig up the subject configuration.
It looks like php is able to connect to ODBC, but then ODBC cannot connect
to Posgresql.

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='wisenet',server='',port='',dbase='',user='',passwd=''
          onlyread='',protocol='',showoid='',fakeoidindex='',showsystable=''
          conn_settings=''
          translation_dll='',translation_option=''
conn = 136550944, SQLConnect(DSN='wisenet', UID='nobody ', PWD='')
Global Options: Version='07.01.0004', 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 ERROR: func=SQLConnect, desc='Error on CC_connect', errnum=201,
errmsg='Missing server name, port,
or database name in call to CC_connect.'
            ------------------------------------------------------------
            henv=136439328, conn=136550944, status=0, num_stmts=16
            sock=136557408, stmts=136078640, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=-1, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=136557448, buffer_out=136074536
            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:
---start
[PostgreSQL]
Debug=0
CommLog=1

---end
odbc.ini:
---start
;
;  odbc.ini
;
[ODBC Data Sources]
wisenet = PostgreSQL

[wisenet]
driver          = /www/lib/libpsqlodbc.so
server          = localhost
port            = 5432
dbase           = wisenet
username        = nobody
passwd          = nobody
serverType      = Postgresql
readonly        = no
trace           = yes
tracefile       = /tmp/sql.log
DebugFile       = /tmp/sqldebug.log
---end


Does anybody know, how to make it work? Where did I make a mistake?

Przem


ps
followup to: comp.databases.postgresql.interfaces.odbc



В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Peltonen
Дата:
Сообщение: Re: 7.1 rpm problem
Следующее
От: "postgres"
Дата:
Сообщение: monitor postgres connect session