Post reply

ODBC Error

  • July 10, 2002 at 10:36 am

    #79058

    Hi all,

    I use an acces97 db as frontent for an sql2k backend. Now I have two backend databases with the same structure (from two of our customers). When I connect to number one (I use connected tables) a certain query runs fine. Against database two the query doesn't run. I get an ODBC error. Using profiler I found that the query (same query on same frontent db, only different data in backend) runs totaly different against the backend. So the errors seems to come from the odbc-driver. How can I avoid this / solve this problem?

    Hope you can help.

    THX

    Markus

  • July 12, 2002 at 4:54 am

    #432574

    quote:

    I get an ODBC error.

    What does the error message display?

    __________________________________

    Searching the KB articles is like

    picking your nose. You never know

    what you'll find.


    __________________________________
    Searching the KB articles is like
    picking your nose. You never know
    what you'll find.

  • July 15, 2002 at 12:14 am

    #432675

    No records found. (I have the german versionb of access. I think this should be the translation) This error appears wheter there should be records returned.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply