asked on

How to change the connection parameters in VB 6.0 for DB Server

I have about 3 important dbs , two on one server with "xx" as domain and one on another server with "yy" domain , but we wanted to get all the 3 dbs on to server with "xx" domain , now I want to know instead of changing the VB code , can I do it using an INI file and as they are frequently changing the db servers , I only need to change the INI file instead of the VB code
and what is the procedure to do so that it takes the connection from the INI file and not from the VB code .If there are any other suggestions would greatly appreciate.

Thanks
Rads

Lee W, MVP

I'd probably use the registry... and I'm not sure how, exactly, you're trying this, but instead of hard-coding servers, database names, user names, and passwords, why not use variables in their place and then you can have the variables determined by reading from the registry.

Rads R

ASKER

I want to know how to do that if I got to declare those variables and what should be done in the registry and the procedures involved in it

thanks

ASKER CERTIFIED SOLUTION

VBClassicGuy

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rads R

ASKER

Hi VBClassicGuy:

Thanks for your input , would greatly appreciate if you can send the procedures that I have to follow in setting up in the registry

Thanks a lot for your time and cooperation
rads

Rads R

ASKER

thanks