Code-behind oleDB connection (asp newbie)

[gtrscott]

Hi All,

I'm trying to get a code-behind oledbconnection working. There are plenty of same page examples but I can't seem to get things initialized properly in a code-behind page. Is there a declaration similar to the namespace=system.data.oledb for code-behind or am I going about this all wrong?

Thanks!

 

[Veep]

At the top of the code-behind you need to put:
Imports System.Data.OleDB

Then you can:

Dim myConn as OleDBConnection
myConn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\YourDB")
myConn.Open()

The key is that "Imports" statement at the top. Other than that it will be just like the one-page examples.

 

[gtrscott]

Thanks very much!!! That did the trick!

Scott