Problem to connect to the server

--------------060606090702020407050909
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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='',pass wd='xxxxx'

onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',sho wsystable='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='',pass wd='xxxxx'

onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',sho wsystable='0'
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''
DSN info:
DSN='PostgreSQL',server='SEIFERT',port='5432',dbase='OfficeT alk',user='postgres',passwd='xxxxx'

onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',sho wsystable='0'
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''

Josef


--------------060606090702020407050909
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit





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='',pass wd='xxxxx'

          onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',sho wsystable='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='',pass wd='xxxxx'

          onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',sho wsystable='0'

          conn_settings='',conn_encoding='OTHER'

          translation_dll='',translation_option=''

DSN info: DSN='PostgreSQL',server='SEIFERT',port='5432',dbase='OfficeT alk',user='postgres',passwd='xxxxx'

          onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',sho wsystable='0'

          conn_settings='',conn_encoding='OTHER'

          translation_dll='',translation_option=''

Re: Problem to connect to the server

--0__=0ABBFB63DFD8144A8f9e8a93df938690918c0ABBFB63DFD8144A
Content-type: multipart/alternative;
Boundary="1__=0ABBFB63DFD8144A8f9e8a93df938690918c0ABBFB63DF D8144A"

--1__=0ABBFB63DFD8144A8f9e8a93df938690918c0ABBFB63DFD8144A
Content-type: text/plain; charset="us-ascii"
Content-transfer-encoding: quoted-printable


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=3D'PostgreSQL',server=3D'',port=3D'5432',dbase=3D'',user =3D'',passwd=3D=
'xxxxx'
therefore
errmsg=3D'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.campbell@us.michelin.com



=
=20
Josef Springer =
=20
=20
oops.com> To=
=20
Sent by: pgsql-odbc@postgresql.org =
=20
pgsql-odbc-owner@ cc=
=20
postgresql.org =
=20
Subject=
=20
[ODBC] Problem to connect to the =
=20
09/21/2006 09:22 server =
=20
=
=20
=
=20
=
=20
=
=20
=
=20
=
=20




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=3D'PostgreSQL',server=3D'',port=3D'5432',dbase=3D'',user =3D'',passwd=3D=
'xxxxx'

onlyread=3D'0',protocol=3D'6.4',showoid=3D'0',fakeoidindex=3 D'0',showsystab=
le=3D'0'
conn_settings=3D'',conn_encoding=3D'OTHER'
translation_dll=3D'',translation_option=3D''
conn =3D 70792624, PGAPI_Connect(DSN=3D'PostgreSQL', UID=3D'OfficeTalk',
PWD=3D'xxxxx')
Global Options: Version=3D'08.01.0100', fetch=3D100, socket=3D0,
unknown_sizes=3D254, max_varchar_size=3D8190, max_longvarchar_size=3D707927=
52
disable_optimizer=3D1, ksqo=3D1, unique_index=3D1,
use_declarefetch=3D0
text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0,
bools_as_char=3D1 NAMEDATALEN=3D64
extra_systable_prefixes=3D'dd_;', conn_settings=3D''
conn_encoding=3D'OTHER'
CONN ERROR: func=3DPGAPI_Connect, desc=3D'Error on CC_connect', errnum=3D20=
1,
errmsg=3D'Missing server name, port, or database name in call to CC_connect=
..'
------------------------------------------------------------
henv=3D70792568, conn=3D70792624, status=3D0, num_stmts=3D16

==================== =====3D=
==================== =====3D=
====================
psqlodbc.1148.log
DSN info:
DSN=3D'PostgreSQL',server=3D'',port=3D'5432',dbase=3D'',user =3D'',passwd=3D=
'xxxxx'

onlyread=3D'0',protocol=3D'6.4',showoid=3D'0',fakeoidindex=3 D'0',showsystab=
le=3D'0'
conn_settings=3D'',conn_encoding=3D'OTHER'
translation_dll=3D'',translation_option=3D''
DSN info:
DSN=3D'PostgreSQL',server=3D'SEIFERT',port=3D'5432',dbase=3D 'OfficeTalk',us=
er=3D'postgres',passwd=3D'xxxxx'


onlyread=3D'0',protocol=3D'6.4',showoid=3D'0',fakeoidindex=3 D'0',showsystab=
le=3D'0'
conn_settings=3D'',conn_encoding=3D'OTHER'
translation_dll=3D'',translation_option=3D''

Josef

--1__=0ABBFB63DFD8144A8f9e8a93df938690918c0ABBFB63DFD8144A
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable

I it looks like you are using a DSN to connect, and it look like your DS=
N does not have a specified server or database in the first log (psqlodbc.7=
80.log)

DSN info: DSN=3D'PostgreSQL',server=3D'',port=3D'5432',dba=
se=3D'',user=3D'',passwd=3D'xxxxx'

therefore

errmsg=3D'Missing server name, port, or database name in c=
all 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.campbell@us.michelin.com



6" height=3D"16" alt=3D"Inactive hide details for Josef Springer <Josef.=
Springer@joops.com>">Josef Springer <Josef.Springer@joops.com>

8144A8f9e8a93df9@michelin.com); background-repeat: no-repeat; " width=3D"40= %"> Josef Springer <Josef.Springer@joops.com> nt> Sent by: pgsql-odbc-owner@postgresql.org 09/21/2006 09:22

8f9e8a93df9@michelin.com" border=3D"0" height=3D"1" width=3D"58" alt=3D""><= br> To "> =3D"0" height=3D"1" width=3D"1" alt=3D""> pgsql-odbc@postgresql.org 8f9e8a93df9@michelin.com" border=3D"0" height=3D"1" width=3D"58" alt=3D""><= br> cc "> =3D"0" height=3D"1" width=3D"1" alt=3D""> 8f9e8a93df9@michelin.com" border=3D"0" height=3D"1" width=3D"58" alt=3D""><= br> Subject "100%"> der=3D"0" height=3D"1" width=3D"1" alt=3D""> [ODBC] Problem to connect to the server 8f9e8a93df9@michelin.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> td> helin.com" border=3D"0" height=3D"1" width=3D"1" alt=3D"">