Errors in MS Access

[rowens1]

Hey all,

I am attempting to run queries on the pt database to get comfortable performing queries in access so that I may transfer this skill to my day job.

I have sucessfully installed the postgresql ODBC driver and created the linked tables in MS Access. I can currently see all the pt tables, prepare my queries, and I can even run a query or two before I start to run into problems. After running a couple of queries (or even 1 large query) I get an error message that says:

ODBC - Call Failed.
Bindings were not allocated properly. (#15)
Clicking on the help for the error yeilds:

ODBC – call failed. (Error 3146)

Using an ODBC connection, you tried to perform an operation on data in an ODBC data source. This error may occur when the ODBC data source is on a network drive and you are not connected to the network. Make sure the network is available, and then try the operation again.

From my google searches I get the feeling that this is a very general error and I don't have the knowledge dig any deeper. I do suspect that this may be some sort of timeout issue since I am initially able to run queries.

Any help or guidence would really be appreciated.

thanks,
Ryan

[kraada]

Did you create a DSN to link to the PostgreSQL database?

[rowens1]

I didn't specifically set up a DSN. I created a linked table through the "Get External Data" wizard in access. If that answers your question.

[kraada]

You might need to set one up - my experience with Access is a bit limited here, though as we transitioned to PostgreSQL entirely for PT3.