>I have started using foxpro since foxpro 1:00 and now i am using visual foxpro 8:00 but I am still using the native visual foxpro database >I would like to switch the SQL but I am a little bit confused >from where to start should I use ADO or just the vfp com utility or the old odbc views ?
Pierre:
You have many options. You can use ODBC or OleDB+ADO
You can use:
SQL Pass Through (ODBC)
Remote Views (ODBC)
Cursor Adapter (ODBC or OleDB or XML)
It all depends on your needs and goals.
I would start simply by reading the help files for Client/Server and the following functions:
ADO is powerful but a little more complicated. You would definitely need it to pass data between COM tiers. If you do not do COM in an N-Tier architecture, you can work fine with SPT. Or you can use a CursorAdaptor (a little more learning curve) and switch betwen the two.
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry