>Hi,
>I am trying to connect to SQL server 2005 or 2008 using ADO from VFP6.
>
>what OLE DB Provider should I user?
>what should be the connection string ?
For OLE DB, probably the Native Client is preferred.
http://connectionstrings.com/sql-server-2008http://connectionstrings.com/sql-server-2005
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up