From: | greg(dot)campbell(at)us(dot)michelin(dot)com |
---|---|
To: | Josef Springer <Josef(dot)Springer(at)joops(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Problem to connect to the server |
Date: | 2006-09-21 13:50:27 |
Message-ID: | OF9457F8FD.FF0F90F5-ON852571F0.004B92DA-852571F0.004C07AF@michelin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
I it looks like you are using a DSN to connect, and it look like your DSN
does not have a specified server or database in the first log
(psqlodbc.780.log)
DSN info:
DSN='PostgreSQL',server='',port='5432',dbase='',user='',passwd='xxxxx'
therefore
errmsg='Missing server name, port, or database name in call to CC_connect.'
.
This seems a little obvious, so am I missing some facts?
Greg Campbell ENG-ASE/Michelin US5
Lexington, South Carolina
803-951-5561, x75561
Fax: 803-951-5531
greg(dot)campbell(at)us(dot)michelin(dot)com
Josef Springer
<Josef(dot)Springer(at)j
oops.com> To
Sent by: pgsql-odbc(at)postgresql(dot)org
pgsql-odbc-owner@ cc
postgresql.org
Subject
[ODBC] Problem to connect to the
09/21/2006 09:22 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'
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Blitz | 2006-09-21 18:11:34 | Access Violation in VC++ 2005 |
Previous Message | Josef Springer | 2006-09-21 13:22:10 | Problem to connect to the server |