RE: Microsoft Access versus Programmatic Data Access

From: Cowboy (Gregory A. Beamer) - MVP (NoSpamMgbworld_at_comcast.netNoSpamM)
Date: 11/09/04 

Date: Tue, 9 Nov 2004 14:34:03 -0800

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!
***************************
"Dave52" wrote:
> 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.

Relevant Pages

  • Re: Registry free DB Connection.
    ... The SQLConnect uses the registry to look the DSN ... What i want to do is the, connect to the DB without registry. ... We ship the database connection drivers with our product. ... Tony Toews, Microsoft Access MVP ...
    (comp.databases)
  • Microsoft Access versus Programmatic Data Access
    ... I am accessing an Oracle database using a Microsoft Access ... front end, making use of linked tables, via a DSN. ...
    (microsoft.public.data.odbc)
  • Microsoft Access versus Programmatic Data Access
    ... I am experiencing an inconsistency in relation to accessing Oracle data via ... I am accessing an Oracle database using a Microsoft Access front end, ... via a DSN. ... I can view but not modify the data using Microsoft Access. ...
    (microsoft.public.data.odbc)
  • Microsoft Access versus Programmatic Data Access
    ... I am experiencing an inconsistency in relation to accessing Oracle data via ... I am accessing an Oracle database using a Microsoft Access front end, ... via a DSN. ... I can view but not modify the data using Microsoft Access. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OracleClient Connection string ..
    ... Oracle is a bit trickier. ... DSN. ... to switch to ODBC to connect, although it is a slow connection. ... > imports system.data.OracleClient ...
    (microsoft.public.dotnet.framework.adonet)