Skip site navigation (1) Skip section navigation (2)

PG odbc - MSQuery

From: "Jeroen van 't Hart" <J(dot)vantHart(at)arpa-intrabouw(dot)nl>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: PG odbc - MSQuery
Date: 2008-03-25 08:48:16
Message-ID: 3EA0C8E935E7A044B3FE6DCA33B52E623D6E00@ARPA-SBS01.ai.local (view raw or flat)
Thread:
Lists: pgsql-odbc
I'm having trouble using the pg odbc driver (v. 8.2.5) in MS Query.
When I'm trying to select a column I get:
 
ERROR: cross-database references are not implemented:
"database.public.table"; Error while executing the query.

I also tried a newer and an older version (v 8.3.1 & v8.2.2) which
results in: 
ERROR: relation "public.table" does not exist; Error while executing the
query.
 
In other applications everything works fine.
 
Any idea's?
 
Regards, 
Jeroen vt H

Responses

pgsql-odbc by date

Next:From: Sebastian ReitenbachDate: 2008-03-25 11:49:52
Subject: connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0
Previous:From: Bruce MomjianDate: 2008-03-25 02:11:31
Subject: Re: postgresql in FreeBSD jails: proposal

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group