db conn's via global.asax's session_onstart...

deian · January 2nd, 2004, 03:08 PM

Basically I am defining my database connection string from my global.asax (example from a book), but doing it in vb.net 2003 standard is not as easy becuase it's too intelligent. Has anyone else done it this way before?

How do i implement this (below) db connection method with vb.net 2003?? any know? U'd be greatful for any pointers.

This is what I have in my global.asax:

Code:

Sub Session_Start(ByVal sender As Object, ByVal e As EventArgs)
        Dim strDbUrl As String
        strDbUrl = Request.ApplicationPath
        If Right(strDbUrl, 1) <> "/" Then
             strDbUrl &= "/"
        End If
        strDbUrl &= "database/mywebdb.mdb"
        Session("conClass") = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=& Server.MapPath(strDbUrl) &;"
End Sub

(note that the provider is all on one line on my file)

and opening the db from an aspx page would simply be:

conClass = NEW oleDbConnection(session("conclass"))

then u got open or close or wotever u need to do. But doing it this way in VB.NET is not so easy as it refuses to compile correctly.

Thanks,
Dei

planoie · January 2nd, 2004, 03:21 PM

What's the compile error? Is the error in your page or the asax.vb?

Peter
------------------------------------------------------
Work smarter, not harder.

deian · January 2nd, 2004, 03:32 PM

the global.asax page is ok, no complaints form vb.net for that page, the error happens when i try to put the connection string in the aspx or ascx file to open the db:

conClass = NEW oleDbConnection(session("conclass"))vb.net says

conClass is not declared.
oleDbconnection is not defined.

but it's declared in the global.asax isn't it? vb.net is too intelligent, or am i missing something?

planoie · January 2nd, 2004, 05:23 PM

Well, for oleDbConnection, you are probably just missing an Imports statement. You can fully qualify it with System.Data.OleDb.OleDbConnection but seeing as you are probably going to need other data related objects from the OleDb namespace you should import it at the top of your *.aspx.vb class file:

Imports System.Data.OleDb

For conClass:
Unless you have "Dim conClass As oleDbConnection" somewhere in your page, it's not declared. And you don't have it declared in global.asax.vb either. You use it in the session as a collection key, but that doesn't make it declared in the runtime code.

Peter
------------------------------------------------------
Work smarter, not harder.

deian · January 2nd, 2004, 06:00 PM

Cool thanks Peter, i put the import thing in and then i put this:
ByVal conClass As OleDbConnection in where u declare the variables. cool huh, no errors on behalf off vb.net now!

thanks a lot!