Controlling IBM DB2 from Access (1 Viewer)

Alc

Registered User.
Local time
Yesterday, 23:39
Joined
Mar 23, 2007
Messages
2,343
A number of our databases connect to remote data sources via ODBC. These connections are configured using the IBM DB2 application. A recurring problem I have is that the department building the laptops for our staff often fail to do the configuring correctly, resulting in my needing to do it manually later. As with all tasks that get repeated, I'm trying to automate this.

I've gotten as far as using VBA to check if they have this application installed and, if so, to open the Configuration Assistant window, ready to import a working profile.

Now I'm trying to work out how to
1. Select the 'Configure' menu, choose 'Import Profile', then choose 'All'

2. In the displayed window, navigate to where I have a profile saved and select that file

3. Click on 'Open' to import it.

Any pointers gratefully received.
 

Ranman256

Registered User.
Local time
Yesterday, 23:39
Joined
Apr 9, 2015
Messages
3,640
the connnections are actually on the PC under ODBC connections in the PC control panel.
 

Alc

Registered User.
Local time
Yesterday, 23:39
Joined
Mar 23, 2007
Messages
2,343
Thanks for the response.
I wouldn't know where to set them from there. I was hoping to duplicate the steps I'd use for a manual configuration.
 

Users who are viewing this thread

Top Bottom