Xavier,

You'll get different opinions from different people. Personally, I like to use remote views, so ODBC is the way to go. I know lots of people like ADO also, but I can't really say, having never used it.

~~Bonnie


>Hello Bonnie,
>
>Thanks again for the reply,
>I played a bit last night and got some results but now what I would like to ask is what is the best way to connect to the server ?
>ADO or ODBC, is ODBC old and Obsolete or ODBC and ADO complemente each other.
>By the look of it, ODBC seems much easier as one can use the Fox Cursor.
>
>Have a good day or night !!!
>
>Xavier
>
>>Xavier,
>>
>>I was *afraid* that you'd ask me that! <g> I guess one place to look would be the Client/Server book that Hentzenwerke publishes ( http://www.hentzenwerke.com/catalogavailability/csvfp.htm ) by Gary DeWitt, Chuck Urweiler, Mike Levy and Leslie Koorhan. It will explain how to connect to SQL databases and run queries, etc. using remote views and/or SPT (SQL Pass Thru).
>>
>>You could check VFP help for topics about SQLEXEC(), CURSORSETPROP(), SQLCONNECT() ... I'm sure there are others too.
>>
>>I don't remember if the book goes into using SQLDMO or not (I think it stands for SQL Data Management Objects), but that's a very handy thing to use for manipulating SQL Server database objects. I don't have any handy URL links to post for you, but you could do some searching online at MSDN for SQLDMO.
>>
>>Perhaps someone else will chime in with some links for you, but this may give you a starting point. I highly recommend the book.
>>
>>~~Bonnie