Xref: alice comp.databases.oracle.misc:37982 Path: alice!news-feed.fnsi.net!netnews.com!isdnet!newsfeed.icl.net!newsfeed1.news.nl.uu.net!sun4nl!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.misc Subject: Re: How to do a Pass through query from Access to oracle via ODBC? Date: Sun, 8 Aug 1999 22:21:30 +0200 Message-ID: <934143697.23515.0.pluto.d4ee154e@news.demon.nl> References: <7ojqev$t8a$1@gxsn.com> Reply-To: "Sybrand Bakker" X-Trace: news.demon.nl 934143697 pluto:23515 NO-IDENT sybrandb.demon.nl:212.238.21.78 X-Complaints-To: abuse@demon.net X-Newsreader: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Lines: 43 Hi Andrew, The problem is not with M_PRODUCTS. The problem is your use of the left function, which doesn't exist in Oracle. Be aware when using passthrough queries, your query directly goes to the Oracle parser: VB features and syntax not allowed anymore. The prompt should be an one-time operation as you will be allowed by Access to save the password. The alternative here is changing the queries properties. Verify with a few other ones how to do it. Hth, Sybrand Bakker, Oracle DBA Andrew Houghton wrote in message news:7ojqev$t8a$1@gxsn.com... > 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 > >