dataset sql2000 sqlce

  • Thread starter Thread starter Miliuccio
  • Start date Start date
M

Miliuccio

i load a DATASET with SQL2000 TABLE

i am not able to UPDATE with SQLCE DATAADAPTER


how to do?
 
you want a System.Data.SqlClient SqlDataAdapter,
NOT a System.Data.SqlServerCe SqlDataAdapter
if you are working with SQL2000.

You cannot fill a dataset with a SqlClient DataAdapter from SQL2000
and then turn around and call update on a SqlServerCe DataAdapter.

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
 
and how to do the travase?



Darren Shaffer said:
you want a System.Data.SqlClient SqlDataAdapter,
NOT a System.Data.SqlServerCe SqlDataAdapter
if you are working with SQL2000.

You cannot fill a dataset with a SqlClient DataAdapter from SQL2000
and then turn around and call update on a SqlServerCe DataAdapter.

--
Darren Shaffer
.NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
Click to expand...
 
to use rda i must manage an iis server and replicate a sql2000db
i'd like to access directly to main db without any other configuration
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date sql2000 e sqlce 1
copy data from SQL2000 To SqlCE 5
XML to SQLce 4
Transfer over HTTP 3
Only one connection can be created in sqlce2.0? 1
Updating the SqlCe database from a DataSet 5
XML to SQLce 2
Slow loading of sqlce database from sqlserver 1

Back
Top