I almost exclusively use the MS ODBC for Oracle. The only time I use the Oracle driver is when I need to call a stored procedure in Oracle. The MS driver will not work for this type of SQL command.
>Hi All,
>
>I've been testing ways to speed up my queries. I have tested 3 different ways to establish my connection to the database. 1st & 2nd using the
Oracle8 ODBC. The 3rd using the
MS ODBC for Oracle.
>
>lnSatHandle = SQLCONNECT('DSATN', 'PROD', 'SATN')
>
>lcConString = "dsn=DSATN;UID=PROD;PWD=SATN"
>lnSatHandle = SQLSTRINGCONNECT(lcConString)
>
>lcConString = "Driver=Microsoft ODBC for Oracle;Server=DSATN;UID=PROD;PWD=SATN"
>lnSatHandle = SQLSTRINGCONNECT(lcConString)
>
>I found that in some cases my queries took 1/4 the time using the 'MS ODBC' Especially where large amounts of records were returned.
>
>My problem is: I like the speed of the MS ODBC. But I’ve seen a lot of posts on the net where they say to stay away from that ODBC. What I’d like to know is what the VFP community has to say about the MS ODBC. Should I stay with the Oracle8 ODBC? Will I have serious problems with the MS ODBC?
>
>If it helps, we only use
VarChar2, Number, Date & Long data types.
>
>VFP6 SP5
>Oracle ODBC Version = 8.01.01.00
>MS ODBC Version = 6.01.8630.1
>
>TIA
>Mike
Mark McCasland
Midlothian, TX USA