SQL Compact problems
-
Has anyone tried to use the new SQL Server Compact version?
I am considering using this in a new project, but during my testing I run into the weirdest errors.
I don't want to use the specialized SqlCeConnection,but OleDbConnection so the application supports any database (theoretically).
I cannot get it to work with datasets though. In my small testapp, I can create tables, insert data and get data with raw sql sentences and OleDbCommands. But when I try to use a Dataset with DataAdapters, then I receive weird errors like:
System.Data.OleDb.OleDbException was caught
Message="The given type name was unrecognized. [,,,,,]"
Source="Microsoft SQL Server 2005 Everywhere Edition OLE DB Provider"
ErrorCode=-2147217872
"Multi-step OleDb operation generated errors. Check each OLE DB status value, if available. No work was done."
Everything works perfectly with Access and SQL Server.
-
This was removed by the editor as SPAM
-
Can you post some code, particularly your connection string.
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices -
Not necessary, I scrapped it.
I got a reply on the MSDN forums, and it seems like the OleDb Provider for SQL Compact only implments a forward only cursor, so using it with Datasets are out of the question...
-
Hi William,
Are you currently working in SQL CE...
R,
Bose.
-
Hello,
No, it didn't suit my needs, so I decided to go for another solution.
I did, however, look into it, so if you have any questions maybe I can help. If not I am sure someone else here or at another forum might be able to
Br
William
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply