Hello Karl,

I agree, it sounds as if you're connecting just fine to the backend. The problem seems to be when your command builder is creating the command statements for use when sending the changes back to your database.

Can you post the statement you're using to pull the data? Is it pulling from multiple tables, perhaps? If so, did you populate the UpdateSelectStatement property... with a filtering WHERE statement so the connection doesn't timeout when grabbing the schema to create UPDATE/INSERT/DELETE command statements?

Hopefully, this will speed the diagnosis,
---J

>Kevin in the actual case of this error the following was done:
>
>I opened the Northwind example and made the minimal changes shown in the help file
>
>ie:
>
>added reference to vistadb
>
>changed the business object to select between vistadb or sql server
>added a connection string to vistadb
>
>I then used the vistadb migration utility to create a vistadb database from the northwind sql server database
>
>I then added a connection string to the app.config file that would call the vistadb connection
>
>I compiled
>
>ran the app
>
>selected the lists option and chose employees
>
>the employees showed up implying that the database was being read
>
>I chose to add a record
>
>upon completeing this I save and get the error
>
>With regard to my actual code the error is same I agree I should use the createempty dataset call (corrrect form - all constructor code called) but I am not even refering to this code
>
>THE ERROR IS FROM THE NORTHWIND SAMPLE IN MERE MORTALS
>
>IF I DID SOMETHING WRONG THAT IS FINE (WHAT IS IT????)
>
>
>I would be happy to send you the project BUT I really only did what I said!!
>
>If I had to guess it is in the vistadb adapter!!
>
>Cheers,