Microsoft Access versus Programmatic Data Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I am experiencing an inconsistency in relation to accessing Oracle data via
two different routes.

I am accessing an Oracle database using a Microsoft Access front end ,
making use of linked tables , via a DSN.

The user account I am using is limited to read only.

I can view but not modify the data using Microsoft Access.
However when I programmatically access the data (in c#) using various
drivers (Microsoft and Oracle) I can access the database but cannot read the
data. I am told that the table or view cannot be found.This occurs even if I
access the data programmatically using the DSN which works using the
Microsoft Access front end.

Why the difference when I am using the same account and the same DSN?

Any help greatly appreciated.
 
If you are actually attempting with the DSN, you are using a connection that
uses ODBC, while trying to attach with OleDB or OracleClient. I would switch
to a connection string that points to the database instead of trying to use
the DSN. You will find that this may, by itself, solve your issue.


---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 
Thanks Cowboy but tried a DSN-less connection string and ran into the same
problem.

In addition I accessed the Oracle database using the SQLPlus UI and while I
could log on to the database , I couln't access the tables.
The simple explanation is that the account that I'm using has restricted
permissions ...but then why the success when using Microsoft Access?
 
Back
Top