473,729 Members | 2,243 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

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

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
3) copied the Registry entries for ODBC connections to the DB2 servers

I found that I had to modify the HKEY_LOCAL_MACH INE entries for
DBArtisan to HKEY_CURRENT_US ER before DBArtisan would pick them up.

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

In the meantime, can anyone think of anything that I need to do that I
haven't done already?
Nov 12 '05 #1
1 3188
In article <b4************ *************@p osting.google.c om>, Byrocat
(bd******@sympa tico.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: ATK | last post by:
Hi, I'm trying to upload a image file to a oracle DB and i need to only use ODBC functions. In db i have a LONG RAW column (if this is not correct, please tell me). I'm getting the error from oracle: ORA-00972: identifier is too long...
by: MLH | last post by:
Using MS Access, I have attached to MySQL servers in other states and other countries on the other side of my router. But when I use the MySQL ODBC driver 3.51 to connect to a MySQL server on my own LAN, the driver tells me it cannot make the connection. Here are the ODBC driver connection parms: Data Source Name: (free field - name my "my linux box" will do nicely) Host/Server Name (or IP) - something like MSQLUserName@ServerName.net...
by: Julia Baresch | last post by:
Everyone, I posted the message below back in February and didn't get any information. I also wasn't able to find any documentation in MS Help, web site, or other groups. I'm posting now with results of my research in case anyone else might need this information. I consulted with my MIS colleague, and he said it would be ok to have each merge file pull the whole database when the criteria screen is opened. His reasoning was that it...
by: Dragon | last post by:
I have an Access 2003 .mde sitting on an SQL Server. The tables for the application also sit on the Server. I'm having a problem with ODBC on only one of about 10 machines. All the other machines using my Access 2003 .mde see the linked tables without a problem. I've configured the User DSN (under Control Panel, Administrative Tools) tab to match what the other machines are set to, but this didn't work. I keep getting an error message...
by: TD | last post by:
Hello All- We are in the process of converting the back end of our large MS Access application to PostgreSQL. My question today concerns linked tables and how their connections are managed by Access. It appears that Access does a *lot* of connecting and disconnecting to these linked tables. This is causing me a major headache, as I'd really like to store some session-based information in the back end that can be referenced by the linked...
by: Greg Strong | last post by:
Hello All, The short questions are 1 Do you know how to make DSN connection close in Access to Oracle 10g Express Edition? &/or 2 Do you know how to make a DSN-less pass-through query work from
by: jags_32 | last post by:
We have spent days trying to perform a proof of concept and I am dissappointed with SSIS to say the least. We are trying to connect and fetch data from a Double Byte Progress database and the "DataReader Source" using a ADO .NET ODBC provider does not work! I understand that SSIS is a totally rewritten version of DTS. What annoys me is that this functionality used to work in DTS and does not in the much talked about SSIS!! Will someone in...
by: Bob Sanderson | last post by:
I'm trying to export a table to an ODBC database using a VBA subroutine. I have tested the ODBC setup manually and it works fine but when I try to do it with VBA, I get a "connection failed" error. This is the code I'm using. Can anyone tell me what is wrong with it? DoCmd.TransferDatabase acExport, "ODBC Database", "ODBC;DSN=*****;UID=*****;LANGUAGE=us_english;" & "DATABASE=*****", acTable, "Test", "Test" Thanks in advance.
by: MLH | last post by:
Am using A97. Have defined Machine Data Source type DSNs in Access' File, Get External Data, Link Tables, Files of Type ODBC, Machine Data Source tab. Have many definitions. Would like to delete some. Would like to edit some. How to delete? I don't think editing is possible.
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.