Changing ODBC Setup of Default Server Name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We recently added a new server due to size restraints of old server. The
database was moved to this new server, while all the reports we run off of
the database, remain on the old server.

The IT department has manually gone to each computer and configured the ODBC
settings to reflect the location of the new server.

However, when we run a file that existed before the installation of the new
server, the ODBC Setup box appears with the old server name which must be
manually changed each time the report is run.

My boss has asked me to research though I'm not in IT. We have tried linked
Manager but once we close the file, it resets back to the orginal settings.
Any clue as to what the IT Dept may be missing?
 
I'd suspect something along the lines that the ODBC connected tables have
cached password settings related to the old server. You should be able to
get around that by deleting the linked tables and then relinking to the
updated version.

As a side topic, ODBC connections on client machines are stored in the
registry. Your IT boys could have done all the updates via a login script
to update client's registry settings.
 
Back
Top