I have a program that is attempting to retrieve data from an Oracle
RDB database using objects within the system.data.odbc namespace (like
connections and dataadapters).

I seem to be able to connect fine (i.e., my connection.open statement
doesn't fail), but when I go to issue a simple SELECT statement
(SELECT location_desc FROM location_code) I get the following error:

ERROR[HY000][Oracle][ODBC][RDB]%SQL-F-Syntax_Error

By the way when I issue the same SELECT statement from MS Access using
a query built on a linked table that touches the same Oracle RDB
database, the statement runs fine and returns records.

Any ideas???????

The portion of my code that deals with the issue that I'm experiencing
looks like this:

Imports System.Data.Odbc

Private cnSource As New OdbcConnection
Private objDataAdapter3 As OdbcDataAdapter
Private objDataSet3 as Dataset

cnSource.ConnectionString =
objDataSet1.Tables("System").Rows(inSystemCounter) .Item("Connection_String_Text")

cnSource.Open()

objDataAdapter3 = New OdbcDataAdapter(strSQL, cnSource)
objDataAdapter3.Fill(objDataSet3, "SourceTableData")

did any one find a way to solve it.
i got does errors too


-
moittes
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message609940.htm