Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle remote views have incorrect field sizes?
Message
 
To
30/03/2000 10:24:09
Paul De Niverville
Deniverville Econometric Research Ltd.
Victoria, British Columbia, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00349742
Message ID:
00352747
Views:
21
>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.

Michael G. Emmons
memmons@nc.rr.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform