Connecting to Access via ADO.Net

[stingrae]

Hi,

I'm new to VB.Net (surprise surprise!) and am having trouble with connecting to an .mdb file. I have done it 100s of times in vb.6, so if somebody could help me i'd be most appreciative.

Is somebody able to translate this VB.6 code into VB.Net:

' Define Global Variables
Public gconDatabase As New ADODB.Connection

Public Function ConnectToDatabase()
    gconDatabase.ConnectionString = "Data Source=" & gcDatabasePath & ";" & _
                                    "Persist Security Info=False"
    gconDatabase.Provider = "Microsoft.Jet.OLEDB.4.0"
    gconDatabase.Properties("Jet OLEDB:database Password").Value = gcDatabasePassword
    gconDatabase.Open 
end function

?

thanks

stingrae

[Athley]

Like this should work...

Dim gconDatabase As New OleDbConnection()
Dim gcDatabasePath As String = "D:\test.mdb"
Dim gcDatabasePassword As String = "pass"

gconDatabase.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & gcDatabasePath & ";" & _
                                "Persist Security Info=False;" & _
                                "Jet OLEDB:Database Password=" & gcDatabasePassword & ";"

gconDatabase.Open()
gconDatabase.Close()

Left out the connection function in my example, but that of course does not make a difference, I guess you see the point anyway . =)