If this is your first SQL/MSDE project, try to get a copy of SQL Server Developers Edition (not sure about the name.) This "developers edition" includes all the GUI tools that SQL Server has and I believe you can use it during development with no licensing issues. It will make your development much easier.

You cannot distribute you applicaion with it, though. You will need to distribute MSDE. That's ok since they both share the same binary code.


>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