ODBC Sessions

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

Guest

Is it possible to transfer ODBC sessions configured on a Windows 2000 machine
to a Windows XP machine without having to reconfigure all the sessions? How
can it be done?
 
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\


--
Regards,

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

:
| Is it possible to transfer ODBC sessions configured on a Windows 2000
machine
| to a Windows XP machine without having to reconfigure all the sessions?
How
| can it be done?
 
Dave:

Ok, file DSN's no problem. However, when I search the registry using the
syntax provided, the system can only find one of my ODBC sessions. Any
thoughts?

Doug
 
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\

--
Regards,

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

:
| Dave:
|
| Ok, file DSN's no problem. However, when I search the registry using the
| syntax provided, the system can only find one of my ODBC sessions. Any
| thoughts?
|
| Doug
 
Back
Top