Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle remote views have incorrect field sizes?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00349742
Message ID:
00352742
Views:
20
>>I've heard a few people recommend MS drivers too, but I have yet to be able to get them to work.
>
>I have used the MS Driver for Oracle almost exclusively now for 2 years. I have yet to come across a problem I could not resolve or work around. I had such a bad initial experience with the Oracle drivers with respect to MS front-end products, that I have used the MS drivers ever since. Maybe the Oracle drivers have improved significantly. A little experimentation may now be warranted. It is just hard to do when what you currently use works fine.

Actually, I should clarify. I've not been able to get the Microsoft Oracle ODBC driver to work on NT machines. I haven't had time to troubleshoot the TNS errors it gives yet. On Win9x machines it works fine.

On my informal testing, the Microsoft drivers are about 4x as fast. Pulling 10,000 records from a table takes 26.72 seconds using the Oracle drivers and 6.87 seconds using MS drivers. So, once I can resolve the NT issues I'll be switching.

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

Click here to load this message in the networking platform