Oracle ODBC's driver v1.15 and up

This is a multi-part message in MIME format.

--------------29A347773CB3

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

Has anyone had problems using parameter queries in Access 2.0 with Oracle's ODBC driver (v1.15 and v1.16)? I keep getting an "ODBC-call failed" error message. No errors with v1.11 or v.10. The Oracle database version is 7.2.3.

I captured the SQL that Access sends to the ODBC data source and put it in the attachment. IMHO, Oracle doesn't like the "?". They'd rather have a ":1".

Let me know if you've seen this, so I can better plead my case with Oracle. You can easily try it in Access; just look up "parameter query" in Access Help.

Thanks,
  Doug

P.S. I get these results on Win 3.1, Win95, and NT (3.51 & 4.0).

-- 


-----------------------------------------------


  Doug Lane               v: (502) 329-3754
  Programmer/Analyst      f: (502) 329-3597
  United Parcel Service   e: app1del_at_is.ups.com
  "Opinions expressed belong to me, not UPS."



--------------29A347773CB3


Content-Type: text/plain; charset=iso-8859-1; name="sqlout.txt"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline; filename="sqlout.txt"

SQLExecDirect: SELECT "A245AA"."TLDTLNK"."CUR_PRC_OGZ_CNY_CD" ,"A245AA"."=
TLDTLNK"."CUR_PRC_OGZ_NR" ,"A245AA"."TLDTLNK"."NXT_PRC_OGZ_CNY_CD" ,"A245=
AA"."TLDTLNK"."NXT_PRC_OGZ_NR" ,"A245AA"."TLDTLNK"."RTE_TNS_DY_QY" ,"A245=
AA"."TLDSVCD"."SVC_TYP_CD_MNE_TE" ,"A245AA"."TLDSRCD"."SRT_TYP_CD_MNE_TE"=
 ,"MS1"."SRT_TYP_CD_MNE_TE"  FROM "A245AA"."TLDSVCD","A245AA"."TLDTLNK","=
A245AA"."TLDTLSV","A245AA"."TLDSRCD","A245AA"."TLDSRCD" "MS1" WHERE (((("=
A245AA"."TLDTLSV"."ALW_SVC_TYP_CD" =3D "A245AA"."TLDSVCD"."SVC_TYP_CD" ) =
AND ((("A245AA"."TLDTLNK"."CUR_PRC_OGZ_CNY_CD" =3D 'US' ) AND ({fn rtrim(=
"A245AA"."TLDTLNK"."CUR_PRC_OGZ_NR" )}=3D  ? ) ) AND ("A245AA"."TLDTLNK".=
"SYS_RTE_TNS_NR" =3D "A245AA"."TLDTLSV"."SYS_RTE_TNS_NR" ) ) ) AND ("A245=
AA"."TLDTLNK"."CUR_PRC_SRT_TYP_CD" =3D "A245AA"."TLDSRCD"."SRT_TYP_CD" ) =
) AND ("A245AA"."TLDTLNK"."NXT_PRC_SRT_TYP_CD" =3D "MS1"."SRT_TYP_CD" ) )=
 ORDER BY "A245AA"."TLDTLNK"."NXT_PRC_OGZ_CNY_CD" ,"A245AA"."TLDTLNK"."NX=
T_PRC_OGZ_NR" ,"A245AA"."TLDTLNK"."NXT_PRC_SRT_TYP_CD" ,"A245AA"."TLDSVCD=
"."SVC_TYP_CD_MNE_TE"  =




--------------29A347773CB3--