Private deploy of Delphi app using SDAC and MS Compact

tonis · Post by **tonis** » Tue 01 Feb 2011 10:32

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?

tonis · Post by **tonis** » Tue 01 Feb 2011 11:44

It seems that SDAC is not checking provider from machine.config. From where it checks that SQL Compact Data Provider is not installed?

AndreyZ · Post by **AndreyZ** » Wed 02 Feb 2011 08:49

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.

tonis · Post by **tonis** » Wed 02 Feb 2011 11:05

Thank you! Works now!

AndreyZ · Post by **AndreyZ** » Wed 02 Feb 2011 11:56

Feel free to contact us if you have any further questions about SDAC.