Re: How to do a Pass through query from Access to oracle via ODBC?

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 <alho_at_globalnet.co.uk> wrote in message news:7ojqev$t8a$1_at_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_at_globalnet.co.uk
>
>
Received on Sun Aug 08 1999 - 15:21:30 CDT