Re: Server migration - ODBC Connections

If you're using file DSN's, then you can copy them from/to

%ProgramFiles%\Common Files\ODBC\Data Sources


If you use system DSN's then you can create a *.reg file from;

You'll need to get the subkey with the DSN names
HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

and also the subkey for each DSN
HKLM\SOFTWARE\ODBC\ODBC.INI\

Also look for user DSN's in;

HKCU\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

and also the subkey for each DSN
HKCU\SOFTWARE\ODBC\ODBC.INI\


You can also use VBScript
http://cwashington.netreach.net/depo...tType=vbscript



--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect


"Ashenafi" wrote:
>
> Hello everyone
>
> I'm hoping you can give me a bit of help here.
>
> I'll set the scene a little with what we currently have, and what we
> want to achieve.
>
> We currently have a Windows NT4 domain, with more than 30 windows 2003
> member servers.
>
> The windows 2003 member servers are hosting
> - SQL 2000 and 2005 servers where clients' applications are connected
> and get access using ODBC connections
> - File Servers where clients get access using map drives.
> - IIS servers hosting Intranet applications.
> - DNS and DHCP servers (Stand alone windows 2003 servers)
>
> Our target is to migrate the NT4 abc.com domain to xyz.net windows 2003
> Active Directory. We have all the necessary hardware and software
> requirements.
>
> So far we have migrated almost all of user/computer accounts using ADMT
> v3 and we have been successfully efficient on this.
>
> Now we are about to begin the servers migration. The challenge here is
> that the name of the servers will be changed. I.e. from server23 to
> something like DC0000-US-2003 and I believe we will have problems with
> the ODBC connections to the SQL servers and Map drives to the File
> servers.
>
> We can reconnect the Map Drives using Login script but what I would
> like to know is how we can handle the ODBC connections as smooth as
> possible (without business interruptions). I have been scratching my
> head for weeks now and I couldn't come up with a solution.
>
> Thank you in Advance.
>
> Ashe
>
>
> --
> Ashenafi
> ------------------------------------------------------------------------
> Ashenafi's Profile: http://forums.techarena.in/members/53020.htm
> View this thread: http://forums.techarena.in/server-migration/1144516.htm
>
> http://forums.techarena.in
>