Multi data application...

[Jacek Jurkowski]

I have to write application using both Vfp database
and SqlServer. Should I use only OleDb provider
or use separate OleDb for Vfp and SqlClient.
It's much more work and I'm not sure if SqlClients
performance is so much better than OleDb to make
this sense ...

What is You'r opinion?

 

[Joyjit Mukherjee]

Hi Jacek,

using provider specific classes is always recommended for use with.
SqlClient .NET data provider for Sql Server 2000 (for ver 6.5 & less, use
OleDb) is optimised to give you maximum performance. Use OleDb for your Vfp
Client.

Regards
Joyjit