471,108 Members | 1,239 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

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.

Jul 23 '05 #1
1 1674
fr33dom101 (fr********@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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Lauren Quantrell | last post: by
13 posts views Thread by Eric E | last post: by
11 posts views Thread by Philip Wagenaar | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.