Page 1 of 1

Private deploy of Delphi app using SDAC and MS Compact

Posted: Tue 01 Feb 2011 10:32
by tonis
We are trying to create private deploy of Delphi app with MS Compact. We are using TMSCompactConnection component for connecting. For creating installation package we are using Inno Setup.

If i'm only copying DLL-s described here http://msdn.microsoft.com/en-us/library/aa983326.aspx (private file-base deployment), i'm getting error message "Required provider is not installed".
For VS projects, they create entry into app.config file and describe SQL Server Compact Data provider there (http://blogs.msdn.com/b/stevelasker/arc ... vider.aspx).

I know that I can install SQL Server Compact before my program and even run this Compact installation from my installation package and this registers needed data provider, but I'd like to do it without using MS Compact MSI. Have someone done something like that?

Posted: Tue 01 Feb 2011 11:44
by tonis
It seems that SDAC is not checking provider from machine.config. From where it checks that SQL Compact Data Provider is not installed?

Posted: Wed 02 Feb 2011 08:49
by AndreyZ
Hello,

You can deploy your application without installing SQL Server Compact Edition. To do this you should call regsvr32 sqlceoledb35.dll after copying specified libraries.

Posted: Wed 02 Feb 2011 11:05
by tonis
Thank you! Works now!

Posted: Wed 02 Feb 2011 11:56
by AndreyZ
Feel free to contact us if you have any further questions about SDAC.