Moving DSN's

DSN's (data source names) are used to store connection string information in either the registry or the file system. When you upgrade to a new server or move a job or process to a different server, you may have to move related DSN's as well. The process isn't hard, just remember that moving the DSN doesn't move any required libraries or client code, you have to track those down and get installed on the new machine as a separate step.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Michael on 2/24/2011

Excellent!!

Yelena Varshal on 2/24/2011

Hi Andy, Nice video about moving DSNs. It would be good to add more for the real life scenarios: you are moving both your web server and DB server, so your DSNs have to reflect the new DB server name or new Excel or MS ACCESS file locations etc. Also if you are moving stuff to the brand-new 2008 x64 servers. I had to spend a few hours before I even found my drivers on x64! The additional ODBC administrator with the drivers is in C:\Windows\SysWOW64 folder. Also to use theses drivers you have to enable running 32 bit processes in IIS. Best Regrads, Yelena Varshal yelena.varshal@philips.com

tarek on 2/24/2011

it very useful,can we got more of the OBDC videos many thanks

Kerem on 2/24/2011

Great it is a lucky time for me because I have been working with ODBC connections for 150 stores:) Nice job.

Kerem on 2/24/2011

Great it is a lucky time for me because I have been working with ODBC connections for 150 stores:) Nice job.

Charles Prawin on 2/25/2011

good

Scott Schwarze on 2/25/2011

Get to show how to add it to the text list. I just moved 78 DNS's to my new servers.

Scott on 3/3/2011

What about passwords? Where are they kept?

Maurice Ivory on 3/4/2011

I did find it very useful in knowing how to move DSN's

Rebecca Scott on 3/2/2012

Excellent video!

elsa m Platania on 10/11/2012

getting newer computer.. this will be very handy!