To add to what Hector said: If you order the MSDE CD (free + s&h) it comes with a free copy of the SQL Dev. edition.

M.

>Hi all,
>
>My first FoxPro job in 2.5+ years and my first ever involving SQL Server (MSDE at this point).
>
>I have a single-table .DBC that I successfully used the Upsizing Wizard to create a MSDE database/table and 'load' data to it. I confirmed this with a simple SQLEXEC(nHandle,"Select * from Mapmerch"), browsing the result.
>
>Now I have a program that is to add or update info in that MSDE database/table.
>
>I get a connection handle just fine but any attempt to run SQLEXEC on that handle always fails.
>
>The command is simply nResult=SQLEXEC(nHandle,cSQLIns1) and I have a rather lengthy SQL-Insert statement in cSQLIns1. But I have also tried with the following in cSQLIns1:
>" cSQLIns1='INSERT INTO Mapmerch (MERCHANTNO, BUSNAME) VALUES ("9898989","NELSON TEST BY HAND")' " and
>" cSQLIns1='INSERT Mapmerch (MERCHANTNO, BUSNAME) VALUES ("9898989","NELSON TEST BY HAND")' ".
>
>My experience is sadly lacking and I'm sure that something more needs to be done, but I don't know what.
>
>Your help will be appreciated.
>
>Thanks