IID_IDBInitialize interface of sql mobile 2005 problem in VisualStudio2005

Opening a connection to the database in Visual Studio 2005 and while closing the connection donot release the IID_IDBInitialize interface ,properties and not Uninitialising.

Try to open database file using CFile to check existence.

Works perfectly using sqlce2.0 & evc4.0 project.

After upgrading the above project to Visual Studio 2005

Same CFile open method fails at run time

But if close the connection completely i.e. close the IID_IDBInitialize interface also .Then it works perfectly in Visual Studio 2005.

Is there any change in IID_IDBInitialize interface of sql mobile 2005 ?

SQL Mobile *REALLY* commits the changes to DISK FILE at a default flush interval of 10 seconds. So, may be the database might have been created in RAM and is yet to be flushed to DISK and with in this flush interval, you might hit this problem.

Thanks,

Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere, Microsoft Corporation

|||

of course, this default interval (for commit transaction) could be changed and you could ask the SQL CE 3.0 engine to flush in real time (what we do in our development)

HTH,
Fabien.