odbc --call failed

[Mukesh]

We have 4 MS Access Databases with few tables on each DB. There are
some reports which uses ODBC. When I try to use the report and input
date range and click ok I get error "ODBC --call failed" it happens on
my computer only. I have just setup Windows XP SP2 with latest updates
and MS Office Prof. 2000 and in ODBC I have same dirvers installed as
other users who are able to access reports without any problem.

Can anybody tell me what setting I need to do on my computer.


Thanks,
Mukesh

 

[Jeff L]

There should be more to the error message than what you posted. It
might be helpful if you posted that too. Often times when you get that
message you either:
1. Don't have the ODBC driver connection set up at all
2. You have the ODBC connection set up, but it has the wrong name.

Usually the message says "ODBC call failed - Connection to ODBCName
failed" You need to make sure that when you set up your ODBC
connection that you use whatever ODBCName is.

Hope that helps!

 

[MN Badger]

I support a company who is trying to do what sounds like the very same thing.
They enter a date range and get the exact same error listed. No more, no
less I have screenshots to prove it. So the initial posting was very
accurate as I was hoping to find a solution because that is the exact problem
all users at this company are experiencing. They were able to access the
info on Monday just fine, did a restore and that had no impact.