Hi, any know How to create OledbConnection instance?

This is my code:

void Application_Start(object sender, EventArgs e) {
OleDbConnection Application["ConnDB"] = new OleDbConnection ConfigurationSettings.AppSettings["strConnDB"]);
Application["ConnDB"].Open();
}

Thanks for a lot.

OK, first of all you only have to post the question one time.

I do not know if you can do what you are trying, however I noticed a missing parenthesis... What are you trying to accomplish by opening the connection here? It looks kind of odd to me, since I have learned that you should open the connection when needed.

Hope it helps :)

Jacob.

You can create an object, and assign it to the application parameter:

OleDbConnection cn = New OleDbConnection(ConfigurationSettings.AppSettings["strConnDB"]);
Application["ConnDB"] = cn;

Then open and close the connection when needed.

Brian