RE: Microsoft Access versus Programmatic Data Access

From: Dave52 (Dave52_at_discussions.microsoft.com)
Date: 11/09/04 

Date: Tue, 9 Nov 2004 14:49:08 -0800

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?

"Cowboy (Gregory A. Beamer) - MVP" wrote:

> 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

  • problem in connection string of oracle
    ... I'm trying to connect to my Oracle 10g Database ... i m facing the problem of connection string, following code is that i use, ... protected Oracle.DataAccess.Client.OracleDataReader orcreader; ...
    (microsoft.public.dotnet.framework.aspnet)
  • problem in oracle database connection string
    ... I'm trying to connect to my Oracle 10g Database ... i m facing the problem of connection string, following code is that i use, ... protected Oracle.DataAccess.Client.OracleDataReader orcreader; ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Linked tables in ms access asking for login/password
    ... > I have an Access 2000 database, which contains some native tables, ... > one table native to the mdb file, and another belonging to ORACLE. ... > - pass this info through something like the connection string. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: ODBC connection string
    ... I have setup an oracle10g database. ... connection string is? ... (SERVICE_NAME = orcl) ... I suggest that you use the Oracle ODBC client rather than the one ...
    (comp.databases.oracle.misc)
  • Pass-Through Queries and File DSNs
    ... I have a small Microsoft Access 2002 database application that tracks the ... How do I write the connection string to the file DSN? ... Where do I place the file DSN connection string -- in the ODBC ...
    (microsoft.public.access.queries)