467,081 Members | 1,212 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,081 developers. It's quick & easy.

Transferring ODBC Connections from one PC to another

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
  • viewed: 2910
Share:
1 Reply
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.

Similar topics

4 posts views Thread by ATK | last post: by
reply views Thread by Julia Baresch | last post: by
26 posts views Thread by Dragon | last post: by
6 posts views Thread by jags_32@yahoo.com | last post: by
9 posts views Thread by Bob Sanderson | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.