<div>
<div class="content wysiwyg-content">
I have an application written in Delphi 2010 using dbGo components that accesses a SQL Compact 3.5 database.<br />
<br />
The app worked ok against SQL Server 2008 but now i have ported it to Compact 3.5 I am getting problems.<br />
<br />
When I open some datasets using a simple &quot;select * from &lt;tablename&gt;&quot; I get an error message &quot;Object is already open&quot; but other tables can be opened OK.<br />
<br />
This is repeatable after i reboot my PC, and when I move to a test app that just opens one dataset/table.<br />
<br />
Any ideas?<br />

</div>
</div>


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?


Object already open error for SQL Compact 3.5

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.