By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,007 Members | 1,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,007 IT Pros & Developers. It's quick & easy.

Transferring ODBC Connections from one PC to another

P: n/a
Does anyone have a checklist of the files/operations that are needed
to clone the DB2 ODBC connections that are one one desktop system to
another?

I did this successfully a while ago with another desktop but the
latest one blows up when I attempt to establish a connection through
DBArtisan.

What I did was:
1) ensure that the sqlnodir and sqlnobak diretories exist and are
populated with my files
2) copied the Registry entries for DBArtisan's settings to the DB2
servers
3) copied the Registry entries for ODBC connections to the DB2 servers

I found that I had to modify the HKEY_LOCAL_MACHINE entries for
DBArtisan to HKEY_CURRENT_USER before DBArtisan would pick them up.

When Rob gets back, I'll try modifying the ODBC Registry file the same
way.

In the meantime, can anyone think of anything that I need to do that I
haven't done already?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
In article <b4*************************@posting.google.com> , Byrocat
(bd******@sympatico.ca) says...

In the meantime, can anyone think of anything that I need to do that I
haven't done already?


You can export all settings with 'db2cfexp' and import them on
another system with 'db2cfimp'.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.