Xref: alice comp.databases.oracle.misc:37957
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!remarQ73!supernews.com!remarQ.com!remarQ69!gxsn.com!not-for-mail
From: "Andrew Houghton" <alho@globalnet.co.uk>
Newsgroups: comp.databases.oracle.misc
Subject: How to do a Pass through query from Access to oracle via ODBC?
Date: Sun, 8 Aug 1999 12:38:08 +0100
Organization: GXSN
Lines: 22
Message-ID: <7ojqev$t8a$1@gxsn.com>
X-Trace: 934112543 1NNUCNF1G54D4C27EC gxsn.com
X-Complaints-To: abuse@gxsn.com
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

Hi all,
Hope someone can assist.

I have a database on Oracle and I also have a Microsoft Acess97 front end
app. It has linked tables to the Oracle database which all open Ok.

All I want to do is to write a query which will execute on the server and
provide me with a result set such as

SELECT * FROM M_PRODUCTS WHERE Left(M_PRODUCTS.PRODUCT,3)="PPT"

each time I have tried to do this (setting the type of query as SQL Pass
Through) it tells me there is no such table or view (#934). However, there
is a table called M_PRODUCTS.
Also I need the query to NOT promt for the UserName, Password or Server.

Many thanks if you can help

Andrew Houghton
alho@globalnet.co.uk