Hi Everyone,

I have just started migrating from ASP to ASP+ and have just been leaning dbconnections. Im wondering how you go about creating a global connection object and including into the Pages you require it as #include is not support in the Page_Load sub.

eg. my connection code is:

Sub Page_Load
Dim objConn, DBComm, strSQL, DBRead
objConn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; DATA Source=C:\Inetpub\wwwroot\ASPTutorials\TestCode\da tabase\Clients.mdb")
objConn.Open()
End Sub

What is the replacement for the in ASP.NET

Thanks Tim


TDA

__________________
TDA

You could create a connection class, wherein one of the methods was something like DBconnect() that executes the code you described. You would just call that method in your Page_Load event.

I suggest that you store your connection string in a globally accessible location, such as the web.config file.

At the end of your web.config file enter this:

</system.web>
    <appSettings>
        <add key="you_name_it"
         value="Provider=Microsoft.Jet.OLEDB.4.0; data source=C:/DB/db_here.mdb" />
    </appSettings>
</configuration>

Then you can use this code:
Dim strConn As String = ConfigurationSettings.AppSettings("you_name_it")

Oh and BTW, you might want to change your connection.inc to connection.asp

.inc files can be viewed in a web browser as plain text. with the asp extension it gets sent to the asp.dll file and nothing gets returned to the browser/hacker.

Ohhh. Thats not good at all. Thanks i will change that.

Tim :)

TDA