>I make DSNless connections to either a VFP DBC or an SQL Server database based on values in an INI file. I can do a SELECT or an UPDATEe on both databases using the same statement fine. Whenever I try an INSERT, the statement works fine against SQL Server, but fails against the VFP DBC. Any hints on how to start tracking down this one?
How does your connection string look like? Do you have a default database specified on it? If not, you might be issueing the command to the master database instead of the one that you want to.
Hector Correa