SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 04:27 PM
| ||||
| ||||
 PG odbc - MSQuery 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 -- Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-odbc      |
|
04-17-2008, 04:27 PM
| ||||
| ||||
| Re: PG odbc - MSQuery On Tue, Mar 25, 2008 at 1:48 AM, Jeroen van 't Hart <J.vantHart@arpa-intrabouw.nl> wrote: > ERROR: cross-database references are not implemented: > "database.public.table"; Error while executing the query. Are you trying to join to tables from different databases? > 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. Most likely in this case your table is in a schema other than public. -- Regards, Richard Broersma Jr. -- Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-odbc |
 |
« Re: Cannot get psqlODBC to work
|
Re: Access complains : Update or CancelUpdate without AddNew or Edit »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
All times are GMT. The time now is 04:54 PM.
