Hi Beth,
There's only one recent book on VFP+SQL Server
Client-Server Applications with Visual FoxPro and SQL Server 7.0 http://www.hentzenwerke.com/catalog/csvfp.htm>
> We are going to be moving up to vfp8 soon, and I am doing some pratice. I have installed MSDE 2000 which came with vfp8, the VFP8 SP1, and I am working on a WinNT 4.0 SP6 machine.
> After several failed attemps at installing it, I finally got it intalled and It runs. I upsized one of our databases into it and am now trying to set the program up so that it can get the data from MSDE and show it in foxpro.
> I read the help info on sqlconnect and create connection, and thought I had it, but when I run the code, I get the error SQL State: 08004, SQL Server Error: 4060, Server rejected the connection; Access to selected database has been denied. But if I just select the database again in the UI form that comes up with the userid and password already filled in, it gets the connection just fine. Of course, the first time I try to do SQL-pass through, it bombs.
>
> Can someone either give me an idea of what I am doing wrong, or point me at a good (simpleton style,please) SQL book.
>
--sb--