mORMot Open Source

kroaycayiroglu

Member

Registered: 2017-02-02

Posts: 3

Is it possible to connect SQL Compact database file with mORMot?

Hello,

I want to connect a .SDF compact db file with mORMot but i couldn't find how to. Is there way or support to do this?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,231

Website

Re: Is it possible to connect SQL Compact database file with mORMot?

Try to use the regular OleDB/ADO connection string for the corresponding provider.

kroaycayiroglu

Member

Registered: 2017-02-02

Posts: 3

Re: Is it possible to connect SQL Compact database file with mORMot?

I tried but it's not working, or i did a mistake. i will try again.

kroaycayiroglu

Member

Registered: 2017-02-02

Posts: 3

Re: Is it possible to connect SQL Compact database file with mORMot?

I tried again, and get ole db error 80040E4D or 80040E21 everytime. maybe i am doing something wrong;

connection strings i tried;

Persist Security Info=False;Data Source=C:\test.sdf; 
Provider=SQLNCLI11;Persist Security Info=False;Data Source=C:\test.sdf; 
Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Persist Security Info=False;Data Source=C:\test.sdf; 
Provider=sqloledb;Persist Security Info=False;Data Source=C:\test.sdf; 

which i get from connectionstrings.com

Last edited by kroaycayiroglu (2017-04-24 13:18:59)