Jump to content
Xtreme .Net Talk

LJK

Members
  • Posts

    1
  • Joined

  • Last visited

LJK's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. 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
×
×
  • Create New...