Hi Larry, Thanks for the information. I'll check out Appdev to see what they are offering.

Here are some reasons I've decided to "look at the idea" of switching to SQLServer as backend. I've had no luck with stored procedures with ASP/VFP, data retrieval is fast (when only a few users are querying at the same time), and what about database maintenance (PACK REINDEX etc.) I have to take the data offline to a machine that has VFP installed, do maintenance, then repost data. Will I have to do the same using a SQLServer backend?. Unfortunately, not too many hosting companies load VFP on their servers. I am a VFP loyalist, and have been for a couple of years, but it seems that maintaining an ASP application with SQL on the backend makes since as this approach seems to have become the standard on much of the applications being built today.

In saying that, I'm not opposed to sticking with VFP as long as it can perform the same as a SQLServer without the need for third party software. I don't want to use a VFP specific solution. I want to use a decent ASP editor, (there are a couple out there now -- DreamWeaver UltraDev *new* saves coding time...using VID now) ADO for data access. Will this new VFP OLE-DB provider make it possible to call stored procedures from my code? do you know when VFP7.0 (w/OLE-DB provider) is going to be available?

The problem is that there are too many choices...making me crazy!!!!! : )

regards,

John.

>>Uh-oh...another new guy. Yep, I'm ready to dive in and start learning.
>>
>>I would like to start learning SQL Server for use in ASP web applications. I'm using VFP now, but there are many drawbacks to this approach unless I invest in a third party tool and a server running VFP runtimes...not possible at this point. Anyway, I'm looking to make the switch to SQL Server back-end database. Can anyone recommend training classes, or training books-CD-Videos for someone new (as-in never used it before) to SQL Server?
>>
>
>AppDev puts out a video series on SQL Server. While I can't recommend this from personal experience, I've heard good things about their other offerings and this looks to be as good.
>
>As an aside, what drawbacks are there using VFP in an ASP environment other than the fact the ODBC driver is single-threaded? That problem should be alleviated when the OLE-DB provider becomes available in VFP 7.