[MonoDevelop] [Mono-dev] SqlCeServer on mono

[Manuel de la Pena]

Hi all,

I've looked more closely into the matter and the SqliCE database is  
an Ole DB which means that
I should be able to write all the classes in the namespace to access  
a .sdf file (http://www.windowsitlibrary.com/Content/1016/05/1.html).  
I'm not entirely sure if I can use System.Data.Odbc that is already  
in the project or System.Data.OleDb (does anyone know why is not  
maintained???)

I'm no entirely sure  bout the differences between the SqlCe and  
Access databases (http://www.builderau.com.au/architect/database/soa/ 
SQL-Server-CE-vs-Access-CE/0,339024547,320283117,00.htm) Apparently  
Microsoft encourages people to use SqlCE but I if I can I would take  
a look into the current state of using Access DBs in Linux and see if  
I can do anything about that....


On 15 May 2007, at 16:15, Michael J. Ryan wrote:

> Manuel de la Pena wrote:
>> Although the first option is far easier to implement it will mean  
>> that
>> people will have different files according to the platform (Window =
>> sdf, Linux = sqlite), I don't think this is a massive issue,  
>> specially
>> because Linux users could have bigger dbs (.sdf has a max size of  
>> 4Gb)
>> and I could always make a tool to go from one to another....
>
> If SQLite (or Firebird Embedded) are ported to CE, you could  
> probably just use one of them all around... though something  
> transparent to sqlce would be cool...  I'm also not sure what  
> differences there are between .sdf and .mdb (access)... I know  
> there's been some effort to get access databases working in linux,  
> and you may want to look into this.
>
> -- 
> Michael J. Ryan - tracker1(at)theroughnecks(dot)com -  
> www.theroughnecks.net
> icq: 4935386  -  AIM/AOL: azTracker1  -  Y!: azTracker1  -  MSN/ 
> Win: (email)
>
> ... Ferengi Rule of Acquisition #208:  Give someone a fish, you  
> feed him for one day.  Teach him how to fish, and you lose a steady  
> customer
>