connect VB net and MS Access ODBC: odbcConnection reference error

[ygs1234]

everything works except for the Dim con As New OdbcConnection( "DSN=yoh;")

why?

thanks!

imports System.Data.Odbc
 
Public Class Class1
    Dim con As New OdbcConnection("DSN=yoh;")
    Dim cmd As New OdbcCommand
 
    Public neym As String
 
    Public Sub New()
        con.Open()
 
        cmd.Connection = con
        cmd.CommandText = "SELECT * FROM table1"
 
    End Sub
 
    Public Sub creates()
        cmd.CommandText = "INSERT INTO table1(Neyms) VALUES('" + neym + "')"
        cmd.ExecuteNonQuery()
 
    End Sub

[yarbrough40]

are you sure this "yoh" data source is configured properly?
You may want to try to connect to the access database directly.

con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Folder1\Folder2\MyAccessDatabase.mdb"