ODBC -Call Failed?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bruce Bruce - 31 Jul 2006 21:13 GMT

What does this mean and how can I fix it?

IT recently conducted a server change (moved data from old server to new)
When I attempt to run a report in Access (which is linked to SQL) I get the
ODBC error.

Help please and please use laymen's terms as I am not too familiar withthe
program.

Thanks

Reply to this Message

Rick Brandt - 31 Jul 2006 21:22 GMT

> What does this mean and how can I fix it?
>
[quoted text clipped - 6 lines]
>
> Thanks

It means (more or less) "Something went wrong". Normally a second message
follows "ODBC Call Failed" which has a more specific error like "server not
found", "SELECT permissions Denied", etc.. We would need to know what that
second message was to be able to offer any advice.

Try opening a table link or passthrough query pointing at the server
directly instead of using a report or form. Many times that will give you
the REAL error. My guess would be that since they moved the server that
your ODBC DSN in Control Panel is still looking for the old server location.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

jmonty - 31 Jul 2006 21:30 GMT

One possibility:
If the name of the server or database was changed and your ODBC Connection
is using a DSN (Data Source Name) to connect, it will not work. A DSN is a
named connection to a server and database that is saved on your computer.
Each time you open the connection it uses this file to know where to connect
to. If you changed the location of the target, of course the connection will
not work. You may have to create a new DSN to connect to the new location.
Open the database and click on Tools, Database Utilities, Linked-Table
Manager. Select the linked tables one by one and check the box that says to
prompt for a new location then click OK. Go through each to make sure each
re-connects.

jmonty

> What does this mean and how can I fix it?
>
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Bruce Bruce - 31 Jul 2006 22:29 GMT

Thank you so much for the information! I followed the steps you gave below
but now there is no data showing up when I run the reports. Any suggesstions?

Thanks again

> One possibility:
> If the name of the server or database was changed and your ODBC Connection
[quoted text clipped - 20 lines]
> >
> > Thanks

Reply to this Message

jmonty - 01 Aug 2006 15:52 GMT

Can you open and see the data in the table or query the report is based on?
Or does the report use SQL in the RecordSource?

Open the report in design mode. From the View menu, click Properties. On the
Data tab, in the Record Source property, you should see either the name of
the table, query or possibly SQL statement in quotes. If it is the name of a
table or query, go to the relevant tab and try to open the table. What
happens? What do you see?

jmonty

> Thank you so much for the information! I followed the steps you gave below
> but now there is no data showing up when I run the reports. Any suggesstions?
[quoted text clipped - 25 lines]
> > >
> > > Thanks

Reply to this Message