Hi all,
I am getting the error:
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll
on the line
DataAdpt.Fill(DataSet1, "SP_PARCEL")
in the following code:
Dim stcon As String = "Provider=MSDAORA;Data Source=ORA920L;User Id=GVW90;Password=GVW90"
Conn = New OleDbConnection(stcon)
Conn.Open()
DataAdpt = New OleDbDataAdapter("Select * from SP_PARCEL where gid = 1302323", Conn)
CBuild = New OleDbCommandBuilder(DataAdpt)
DataSet1 = New DataSet("SP_PARCEL")
DataTable1 = New DataTable("SP_PARCEL")
DataAdpt.Fill(DataSet1, "SP_PARCEL")
This code works fine if i replace the * in the sqlquery with one or more column names.
Does anyone know why this might be? thanks
lorraine