Unable to connect to PostgreSQL 8.0 with any driver...

From: jross(at)wykids(dot)org
To: pgsql-odbc(at)postgresql(dot)org
Subject: Unable to connect to PostgreSQL 8.0 with any driver...
Date: 2005-03-07 18:17:23
Message-ID: 20050307111723.esskxw68g0wc4oow@wykids.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

This is a continuation of my problems with the original 08.00.0100 driver.
08.00.1001 now installs correctly and the driver is available to be configured
in the ODBC control panel.

However, I still cannot connect to Access with it. My PostgreSQL logs do not
even show a connection attempt. The logs on the windows box are:

mylog:

[184]globals.extra_systable_prefixes = 'dd_;'
[184]globals.extra_systable_prefixes = 'dd_;'
[184]IDOK: got ci = 686496
[184]globals.extra_systable_prefixes = 'dd_;'
[184]globals.extra_systable_prefixes = 'dd_;'
[184]IDOK: got ci = 703904

pgsqlodbc:

DSN info: DSN='PostgreSQL',server='',port='',dbase='',user='',passwd='xxxxx'
onlyread='',protocol='',showoid='',fakeoidindex='',showsystable=''
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''
DSN info: DSN='PostgreSQL',server='',port='',dbase='',user='',passwd='xxxxx'
onlyread='',protocol='',showoid='',fakeoidindex='',showsystable=''
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''

The logs from a different computer that successfully logs into the database are
way more voluminous than this. I'll put them up on our web site if someone
needs to see what's going on with a successful connection.

I'd appreciate any ideas.

Thanks,

Jeff Ross

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Kelly Burkhart 2005-03-07 18:42:34 Re: Insert SHRT_MIN fails for int2 column
Previous Message Tom Lane 2005-03-07 17:44:35 Re: Insert SHRT_MIN fails for int2 column