M Miliuccio Oct 3, 2005 #1 i load a DATASET with SQL2000 TABLE i am not able to UPDATE with SQLCE DATAADAPTER how to do?
D Darren Shaffer Oct 3, 2005 #2 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
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
M Miliuccio Oct 4, 2005 #3 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...
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...
D Darren Shaffer Oct 4, 2005 #4 why don't you just use Remote Data Access to SQL 2000 to populate your data in SQL CE? -- Darren Shaffer ..NET Compact Framework MVP Principal Architect Connected Innovation www.connectedinnovation.com
why don't you just use Remote Data Access to SQL 2000 to populate your data in SQL CE? -- Darren Shaffer ..NET Compact Framework MVP Principal Architect Connected Innovation www.connectedinnovation.com
M Miliuccio Oct 5, 2005 #5 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
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
