ODBC -Call Failed? Bruce Bruce 31.07.2006 20:13:02 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

Re: ODBC -Call Failed? "Rick Brandt" <rickbrandt2[ at ]hotmail.com> 31.07.2006 20:22:01 Bruce Bruce wrote: [Quoted Text] > 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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com

RE: ODBC -Call Failed? jmonty 31.07.2006 20:30:01 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 "Bruce Bruce" wrote: [Quoted Text] > 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

RE: ODBC -Call Failed? Bruce Bruce 31.07.2006 21:29:02 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 "jmonty" wrote: [Quoted Text] > 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 > > > "Bruce Bruce" wrote: > > > 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

RE: ODBC -Call Failed? jmonty 01.08.2006 14:52:02 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 "Bruce Bruce" wrote: [Quoted Text] > 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 > > "jmonty" wrote: > > > 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 > > > > > > "Bruce Bruce" wrote: > > > > > 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