Change ODBC pointer on workstations after database move

I am by no means a "Database Expert" and have recently been asked to
assist with a SQL 2000 database move to a new server.  I was wondering
if there was an easy way to reconfigure the ODBC pointers on the
workstations?

Thanks for the help in advance.

fr33dom101 (fr33dom101@hotmail.com)  writes:
> I am by no means a "Database Expert" and have recently been asked to
> assist with a SQL 2000 database move to a new server.  I was wondering
> if there was an easy way to reconfigure the ODBC pointers on the
> workstations?

There no such things as an ODBC pointer.

When an application connects to a server, it can use a DSN, which is
defined on the machine. The preferred way today though is DSN-less,
which means that everything is in the connection string. If the
server name is hard-coded in the applications, the application
must be re-built. A good application gets this information from
somewhere, though, for instance user input. So, with some luck,
you really don't have to change anything.

Anyway, you need to find out what exactly what on the workstations
depend on the server name etc, so you know what you need to change.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp