Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Problem to connect to the server



Hi folks,

we use PostgreSQL 8.1 and the ODBC PostgreSQL Unicode 8.01.02.00 / 31.1.2006.

My application can connect on the localhost but not to a remote server. I have switched on the ODBC logging, but i cannot found why ?

The logfiles:
psqlodbc.780.log
DSN info: DSN='PostgreSQL',server='',port='5432',dbase='',user='',passwd='xxxxx'
          ,protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
          conn_settings='',conn_encoding='OTHER'
          translation_dll='',translation_option=''
conn = 70792624, PGAPI_Connect(DSN='PostgreSQL', UID='OfficeTalk', PWD='xxxxx')
Global Options: Version='08.01.0100', fetch=100, socket=0, unknown_sizes=254, max_varchar_size=8190, max_longvarchar_size=70792752
                disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0
                text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64
                extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='OTHER'
CONN ERROR: func=PGAPI_Connect, desc='Error on CC_connect', errnum=201, errmsg='Missing server name, port, or database name in call to CC_connect.'
            ------------------------------------------------------------
            henv=70792568, conn=70792624, status=0, num_stmts=16

======================================================================
psqlodbc.1148.log
DSN info: DSN='PostgreSQL',server='',port='5432',dbase='',user='',passwd='xxxxx'
          ,protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
          conn_settings='',conn_encoding='OTHER'
          translation_dll='',translation_option=''
DSN info: DSN='PostgreSQL',server='SEIFERT',port='5432',dbase='OfficeTalk',user='postgres',passwd='xxxxx'
          ,protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
          conn_settings='',conn_encoding='OTHER'
          translation_dll='',translation_option=''

Josef 


Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group