Home > Archive > PostgeSQL ODBC > November 2005 > [ psqlodbc-Bugs-1000416 ] Tables not shown when linking from Access to the server. Prior drivers wo









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author [ psqlodbc-Bugs-1000416 ] Tables not shown when linking from Access to the server. Prior drivers wo
noreply@pgfoundry.org

2005-11-14, 8:23 pm

Bugs item #1000416, was opened at 2005-11-08 16:24
You can respond by visiting:
http://pgfoundry.org/tracker/?func=...roup_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Tables not shown when linking from Access to the server. Prior drivers worked.

Initial Comment:
Versions used:
- psqlODBC 08.01.0100
- PostgreSQL 8.1 in windows
- Access 2000

Problem:
From Access, using the new ODBC driver, when trying to link to the tables of the server... we are shown the system tables but not the user ones (those from the public scheme).

Expected results:
We should see all the tables so we could make links to the tables we need.

Additional comments:
- We tried it from two computers and the results were the same.
- There was no problem using psql from any computer.
- In the same Access database, we programmed some code to read the data of the tables, via ODBC, and there was no problem (so it seems it is not a problem of permissions).
- We switched back to the "snapshot" psqlodbc-08_01_0005.zip and it worked!. Maybe is a regression bug?



I'm available to do whatever tryings are needed.

Keep up the good work. Thanks for it all!




----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=...roup_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com