Mark Richardson
1/23/2003 6:58:00 PM
Hello,
Every time I run this piece of code. I get the following
error
"An unhandled exception of
type 'Microsoft.Data.Odbc.OdbcException' occurred in
microsoft.data.odbc.dll"
I get this error on the DataConn.Open() line. Can anyone
help me.
Here is my Code Below
Dim DataReader As OdbcDataReader
Dim DataConn As OdbcConnection
Dim DataCmd As OdbcCommand
Dim DataAdapter As OdbcDataAdapter
Dim strConn As String
Dim strQuery As String
strConn = "DNS=EmployeeDB;database=Employee_Database.mdb;"
strQuery = "Select * From tblTest"
DataConn = New OdbcConnection(strConn)
DataCmd = New OdbcCommand(strQuery, DataConn)
DataConn.Open()
DataReader = DataCmd.ExecuteReader()
lblTest.Text = DataReader("Test")
DataReader.Close()
DataConn.Close()