Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Linked Server Extremly Slow
Message
From
02/08/2005 12:16:20
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 6 SP3
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01037362
Message ID:
01037892
Views:
17
Well, I found.

It was ODBC driver; who knows what destroyed it. I wrote a VFP program which access tables via ODBC driver. It works on workstations, but running directly on server cause a Fatal Error.

Reinstalling ODBC - and everything works fine now.

Linked server with ODBC access to VFP tables is much, much better as it was with VFPOLEDB provider. It's not as fast as it is if tables are directly in SQL server (or acessed in native VFP), but it is acceptable for the use I need.

Thank's, it helped me a lot.

Zlatko.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform