Sql Compact Edition

I found the answr here:



http://www.automatedqa.com/newsgroups/d.cgi?cmd=article&group=automatedqa.public.testcomplete&item=34815&utag=

However...sigh



The Connection string is:

Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5; Data Source=C:\myCEDb.sdf



And it can access tables that have fields of type nvarchar with length 100, but not with length 150. I found this by using custom query to filter out the fields that have a length of 150, and it returns the table data, but if i include those fields, it throws error as attached. Any suggestions?



Thanks

Hello Chet,





Looks like a known problem, with no resolution though:

SQL Server Compact 3.5 nvarchar limitation

Alex,



Thanks for the verification. I am using a Connected Application as a workaround, but of course I cannot use the DBCheckpoint function.



Regards