Last post Dec 20, 2013 01:07 AM by Starain chen - MSFT
Dec 19, 2013 07:31 AM|KavitaAggrawal|LINK
I am using sqlce database in my rest service.I have placed sqlce4.0 database in app_data folder and included all sql ce dlls in my bin folder.
Now if i publish this service to the iis server where sql server compact 4.0 is installed then its accessible but its not accessible where sqlserver compact 4.0 is not installed.
even I have included all sql ce dlls then also its giving me error saying File or directory not found.
I have gone through this link also : http://msdn.microsoft.com/en-us/library/aa983326(v=vs.110).aspx
But no Luck !!!
Could anyone tell me that sql server compact installation is really necessary as our client wont like to have all the s/w installed to access db. There must be some other dlls.
Really looking forward for your reply.
Dec 19, 2013 11:45 AM|Mikesdotnetting|LINK
its giving me error saying File or directory not found.
What line of code throws that error?
Dec 20, 2013 01:07 AM|Starain chen - MSFT|LINK
Based on the link that you mentioned, it says that we can use the Private file-based deployment way. (Just deploy the SQL Server Compact DLLs)
So, I think the SQL Server Compact isn’t necessary installed in the server.
Please follow those steps and try again. (Just included all dlls in the bin folder is useless)
If you still have the issue, please provide the detail error message.