Hello,

I am trying to create a DB Connection Object called "objDBConn"
I want to re-use this object through my VB.NET application, thus why I am creating an object. My question is: Should I put all connection info in my object such as connection string, etc?

Please any help with this is greatly appreciated.

Thanks in Advance,
Mark

Hey,

I don't know if you want an open connection to a database at a globular level. You can create an object at each form or web page level, then make it accessible to an entire form. But for performance, it is wiser to open and close it only when you need it.

Brian

Hi Brian,

Thanks for the reply. I have been reading about accessing the Database from the system registry...This way it is easier to install the application.

You know anything about that...

Thanks,
Mark

Hey,

Never heard of storing the database, but it is common practice to store the connection string in the database to connect to in the registry.

Brian

Sorry, that is what I meant. I want to store the connection string to the database, in the registry. Then access the connection String in the registry from my objDBConn.
I have most of this figured out and understand it, the only thing I am having trouble with now is, I am not sure if I need to call the string value in my registry.
Example:
In Registry my file is like this:
LocalMachine\Software\MyApp\ConnectionString
Do need to specify it like this
OR do I just need Software\MyApp

Thanks in Advance,
Mark