|
My guess is that the
port number 8889 or the server 'localhost' is incorrect. The ODBC driver appears
to be connecting to something, but not PostgreSQL. As you are running a Redhat
system, it seems unlikely that pgAdmin II would be running on the same machine
as your database :-)
Regards,
Dave.
conn=59783184, PGAPI_DriverConnect(
in)='DRIVER={PostgreSQL};UID=jmd;PWD=;SERVER=localhost;PORT=8889;DATABASE=template1;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=0;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_;COMMLOG=0;DEBUG=0;',
fDriverCompletion=0
Global Options: Version='07.03.0100', fetch=100,
socket=4096, unknown_sizes=0, max_varchar_size=0,
max_longvarchar_size=0
disable_optimizer=0, ksqo=0, unique_index=0,
use_declarefetch=0
text_as_longvarchar=0, unknowns_as_longvarchar=0, bools_as_char=0
NAMEDATALEN=64
extra_systable_prefixes='', conn_settings='' conn_encoding='OTHER'
CONN
ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect', errnum=210,
errmsg='Unexpected protocol character during authentication'
Dave any
idea what is going on here ? I have never seen this error before. I am running
Linux V9 (redhat) and
postgres V7.3. I keep
getting this error and cannot connect. When I connect to my Linux V7.2 maching
and
postgres V7.2 all works just
fine.
Jim Doherty
An IRISH Proverb
"There is no
success without discipline"
Phil 3: 13 - 15 ("Press
On")
Office: 512-372-5443 Fax: 512-241-5443
EMAIL: [EMAIL PROTECTED]
Principal Member Technical
Staff
SBC Laboratories,
Inc.
This e-mail and any files transmitted with it are the property of SBC,
are confidential, and are intended solely for the use of the individual or
entity to whom this e-mail is addressed. If you are not one of the named
recipient(s) or otherwise have reason to believe that you have received this
message in error, please notify the sender at
512 372-5443 and delete this message immediately from your
computer
|
