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: james_doherty@labs.sbc.com
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
