>>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.

I now know why the insert doesn't work, but don't know why the error is being generated. Thanks for the info.

I'm originally from KCMO, how long have you lived there?