Visual Basic .NET Forums - View Single Post - Question Use ODBC DSN's to Access / Manipulate Data

cathalo · #3 (**permalink**) 03-31-2009, 10:54 AM

I receive this message when attempting the code listed below.
Any ideas on this one?

ERROR [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this function

Code:

Dim cn As New OdbcConnection("dsn=Encore50A;uid=;pwd=;")
        Dim cmd As OdbcCommand
        Dim adp As OdbcDataAdapter
        Dim ds As New DataSet

        cn.Open()
        cmd = New OdbcCommand("select * from INVPRICE", cn)
        adp = New OdbcDataAdapter(cmd)
        adp.Fill(ds, "StockCode")

        Me.DataGridView1.DataSource = ds
        Me.DataGridView1.DataMember = "StockCode"
        'MsgBox(cn.State.ToString)
        cn.Close()