ODBC Connection failed after importing linked tables

From: "ben sewell" <mosherben(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC Connection failed after importing linked tables
Date: 2006-08-01 12:59:04
Message-ID: bf6c74d80608010559w5a340140j41aaa3ddd675f424@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,
I'm running a postgresql 8.1 server on Windows 2002 Small Business Server. I
am in the middle of a migration from an MS Access backend to a PostgreSQL
backend. The existing MS Access 2000 frontend will be used. I'm using the
pgSQL ODBC driver (latest) on Windows XP Pro SP2.

I have using the linked table wizzard to link tables to the PostgreSQL,
which had no problems and I setup the relationships on the front end.
However, when I try to open the database, it is saying this error message
"ODBC--connection to '{PostgreSQL}10.0.0.2' failed". This is strange because
I can ping the server and use telnet to connect to postgresql. I've done a
google search and this seems to be a problem that seems to happen to MySQL
databases. What I was wondering is, can anyone offer any solutions on how to
solve this problem?

Cheers,
Ben

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Philippe Lang 2006-08-01 17:33:27 Re: TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through ODBC)
Previous Message Ludek Finstrle 2006-08-01 12:20:39 Re: usage of option ByteaAsLongVarBinary?