>Thanks Michael and Lorne,
>
>I have a VFP/Oracle app using Oracle 7.3. I am currently using the Oracle ODBC driver. I was able to get the MS driver to access the Oracle tables but we never tried it in the production environment.
>
>We are migrating the database to Oracle 8.1.5. I just got the new Oracle ODBC driver but have not had a chance to test it. Are you using this Oracle ODBC driver? If so, is there anything I should watch out for?
>
>Thanks,
>
>Paul
Paul...we are using the 8.01.55.00 Oracle drivers currently. All the Oracle drivers we have tried have been a major headache for us. Turning off the LOBs resolved some of these issues, but oddball problems are still popping up occasionally. As I said in a previous thread we'll be dropping the Oracle drivers for MS drivers as soon as I can resolve the issues I'm having with MS drivers on NT boxes. On my informal testing the MS drivers were about 4x faster than the Oracle drivers when pulling test data of 10,000 records.