Me thinks Cerebrus is right. In MS SQL table is a reserved keyword for sure. Haven't worked on Oracle in a few years, but it seems likely this is the problem.
-Chris On Jul 7, 12:46 pm, Cerebrus <[email protected]> wrote: > Hint: Isn't "table" a reserved keyword ? > > On Jul 7, 1:39 am, Averroes <[email protected]> wrote: > > > > > Hi all, > > I have used the following code to connect to an oracle data base > > successfully: > > > ============= > > string connectionString = "provider=MYPROVIDER; data > > source=MYDATASOURCE;user id=ME;password=MYPASSWD"; > > OleDbConnection myOleDbConnection = new > > OleDbConnection(connectionString); > > myOleDbConnection.Open(); > > > OleDbDataAdapter myAdapter; > > > myAdapter = new OleDbDataAdapter("SELECT filed FROM table", > > myOleDbConnection); > > DataSet objDataset1 = new DataSet(); > > myAdapter.Fill(objDataset1 , "TrDateKey"); > > myOleDbConnection.Close(); > > =============== > > > however when i replace the query "SELECT filed FROM table" by > > "SELECT * FROM table", an error occurs. > > > Can any one help me with this ? > > > Thanks a lot
