July 12, 2011 at 7:49 am
Hi ,
I need to copy an odbc system dsn , but I am not able to locate it. Where should I look for it ?
What will the file extension be?
Any solutions?
July 12, 2011 at 8:37 am
Is it a User DSN, a System DSN or a File DSN? I believe the first two (User and System) are stored in the Registry -- so the easiest thing is to just recreate the DSN on the new server. A File DSN is a file in the file system that you should be able to copy from one machine to another.
One gotcha I've run into with DSNs is if you're moving between 32 and 64 bit OSs and making sure you are configuring your DSN in the correct area.
July 12, 2011 at 8:38 am
System and user DSNs are held in the registry, export the system DSN from the following registry location
HKEY_LOCAL_MACHINE\SOFTWARE\OBDC\ODBC.INI\ODBC Data Sources
for each DSN listed here it will have a registry branch under
HKEY_LOCAL_MACHINE\SOFTWARE\OBDC\ODBC.INI\DSN Name
On 64 bit systems 32bit DSNs appear under the WOW6432Node registry branch, so
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\OBDC\ODBC.INI\ODBC Data Sources
and
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\OBDC\ODBC.INI\DSN Name
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2011 at 8:56 am
Thank you! And should any changes be made after copying the file? I am copying it from win 2003 to win 2008
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply