Is there an API to bind variables to Access 97 SQL statements?
From: Steven Moyano <Steven>
Date: Wed, 09 Dec 98 17:32:59 GMT
Message-ID: <74mc65$klf_at_news.acns.nwu.edu>
We are working with Access 97 as a front end to Oracle 7.3.4. (Oracle ODBC driver ver 2.5). We are unable to make SQL statements built on the Access end run as SQL statements using bind variables on the Oracle end (Access parameter queries are seen by the server as using bind variables but they prompt the user for values rather than accept values from select lists, which is a requirement). Instead of last name = :v, the SQL pool shows individual permutations, such as last name = jones, last name = smith etc.
Date: Wed, 09 Dec 98 17:32:59 GMT
Message-ID: <74mc65$klf_at_news.acns.nwu.edu>
We are working with Access 97 as a front end to Oracle 7.3.4. (Oracle ODBC driver ver 2.5). We are unable to make SQL statements built on the Access end run as SQL statements using bind variables on the Oracle end (Access parameter queries are seen by the server as using bind variables but they prompt the user for values rather than accept values from select lists, which is a requirement). Instead of last name = :v, the SQL pool shows individual permutations, such as last name = jones, last name = smith etc.
Is there an API which would allow us to use Oracle bind variables with Access 97 SQL statements? Other suggestions would be welcome.
Steven Moyano
Northwestern University, Evanston, IL. USA
Steven Moyano <smoyano_at_NWU.EDU>
Received on Wed Dec 09 1998 - 18:32:59 CET