I’m struggling on how to get my VB.net test app to connect to different databases. I’ve been googling the topic for a couple of days now. It seems to be something a lot of people struggle with.
With the current PowerBuilder application, we use the registry to point to a database. Before the current local app runs, it writes the database name to the registry from a config file. At the very top, we get the database name from the registry. We then construct a connection string. We put all of this into the SQLCA structure. And then connect. Effectively, we control what database we connect to by manipulating the configuration file which helps create the registry.
I’m looking to duplicate the ability to control the database connection for my test app without using the registry if possible.
How can i accomplished this task?