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

Problem to connect to the server

From: Josef Springer <Josef(dot)Springer(at)joops(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Problem to connect to the server
Date: 2006-09-21 13:22:10
Message-ID: 45129202.3070600@joops.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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'
          
onlyread='0',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'
          
onlyread='0',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'
          
onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
          conn_settings='',conn_encoding='OTHER'
          translation_dll='',translation_option=''

Josef 

Responses

pgsql-odbc by date

Next:From: greg.campbellDate: 2006-09-21 13:50:27
Subject: Re: Problem to connect to the server
Previous:From: rjoy rjoyDate: 2006-09-21 13:14:51
Subject: Re: Undefined Symbol error trying to connect with OpenOffice

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group