Transferring ODBC Connections from one PC to another

Byrocat

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

Gert van der Kooij

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