Object already open error for SQL Compact 3.5

I have an application written in Delphi 2010 using dbGo components that accesses a SQL Compact 3.5 database.

The app worked ok against SQL Server 2008 but now i have ported it to Compact 3.5 I am getting problems.

When I open some datasets using a simple "select * from <tablename>" I get an error message "Object is already open" but other tables can be opened OK.

This is repeatable after i reboot my PC, and when I move to a test app that just opens one dataset/table.

Any ideas?
soozhAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
soozhConnect With a Mentor Author Commented:
this probem was related to the dbGo components that could not handle a nvarchar field more than 127 characters long...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.