Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Who really uses the VFPOleDB.1 provider?
Message
From
03/10/2006 12:47:09
 
 
To
03/10/2006 03:59:03
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01158763
Message ID:
01158946
Views:
33
>A SWAG - maybe you could try installing Visual Studio + SPs on one of the servers (just install it, don't actually use it), so you have the same environment there as on your dev box.

When I ran more tests on the development PC, I was able to simulate the same situation. It is just that it takes more time as this is not the same power as the servers.

>If that makes a difference, look very closely at file/.DLL versions on the servers vs. those on your dev machine.
>
>Another SWAG - is there any difference in the AV products used on the various machines?

On the development PC, we have McAfee Online Virus Scan and the server version on the servers.

Last night, I started to migrate to SQL Server a portion of the components. I ran a big test for 20 minutes. I did it twice. The SQLClient provider is answering about 3 times faster than the VFP OleDb provider. So, I was able to send three times more hits than the previous tests. I didn't have one single error. This was working extremely fast without any error at all.

But, I need to migrate fully and send the full set of tests as soon as I will be able to. But, this seems to be exactly as I saw it at first. The VFP OleDb provider doesn't seem to be in the game.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform