ODBC -Call Failed?

[Guest]

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

 

[Rick Brandt]

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

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.

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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