Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP ODBC driver or VFP OLE DB - thread-safe?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01584613
Message ID:
01584617
Views:
68
>>I must admit that I'm a bit biased against using either of these drivers and prefer moving data to SQL Server instead.
>>
>>I'm pretty darn sure that the VFP ODBC driver is not thread-safe. What about the VFP OleDb driver? I've actually never used it. How does it hold up when used by WCF services? How robust is it?
>>
>>Ideas on either of these two drivers is appreciated.
>
>VFP ODBC driver is thread-safe.
>http://msdn.microsoft.com/en-us/library/ms709357(v=vs.85).aspx

Victor,

With all due respect, there is a KB article that says the following:

"The problem with this design is that the Visual FoxPro ODBC driver is not thread-safe, and as a result, MTS/COM+ (or the objects themselves if they are stand-alone) can fail."

See: http://support.microsoft.com/kb/288863

I've seen your KB and I can't believe what it says. I think there's a lot of confusion going on around the VFP ODBC driver. When I was at MS I tested the VFP ODBC driver and found that it was not thread-safe. And I think by design it was not thread-safe.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform