I am looking for help ( at beginnners level ) in the use of the newly released / promoted SQL Server Compact Edition (what used to SSEv ).
I have a single user desktop application - not PDA / mobile, which uses JET database today & I need to convert it to current databse as JET is no longer supported under Vista. I understand that it is SQL Server Compact edition. My application is native c++ with no .NET and I would like to keep it that way. Can someone point me to examples, documentation, or any help which will get me going?
Currently, I am connecting to the JET database using ADO and a connection string ( again ADO, not ADO.NET ). Is it just a matter of changing the connection string and making sure that the righ dlls are included and registered?
Thanks in advance.
Few corrections:
- Just like Jet, SQL CE is in-process database, but it allows for multiple connections to the same database, possibly from different users. Nether Jet nor SQL CE are designed to accept remote connections from multiple users over network like SQL Server does, but it might be possible through extra applications/drivers.
- SQL CE does not require .Net Framework 2.0 (or any other version for that matter) in order to function.
- You don't have to use ADO.Net to access SQL CE, native applications could use OLEDB interface instead.
|||Thank you for the prompt reply - and a Happy New Year. ( My relief is doubled as I got no help at the microsoft.public.vc.database even after identifying myself as a msdn subscriber ).It is obvious that I need to move away from JET. My application is a single user application which installs without Admin privileges and I need to keep it that way. Today, I use ADO to connect to the JET so that (I believe) there is not much different between the JET SQL and the one for SQL Server. I was told that SQL Ce is the choice - or should I go to something like SQLite?
If I am to read what you say correctly, I cannot use SQL Ce without moving my application from native c++ to .NET. This appears to be more work than I bargained for (no experience in .NET for my team ) and I will have some deployment issues in distributing to older versions of Windows ( I have to distribute .NET which will require Admin privileges ).
I will pick up the e-book. Do I need to get the first e-book to understand this?|||Ilya,
Than you for the clarifications.
Assuming that I use the OLEDB intrerface, is there an example that you can point to? Currently my c++ code uses the JET OLEDB connection and a c++wrapper for ADO - am I naive in assuming that I can just change the connection string, have the DLLs needed for SQL Ce in my App directory and I can get started?
Happy New year to you!|||
Just a clarification: whatever you MSDN subscriber or not is irrelevant in MSDN forums like this one or news groups like microsoft.public.vc.database. In both cases answer are provided (or not) by volunteers including your fellow developers and Microsoft's employees. If nobody can (or want) to answer, your post will remain unanswered. If you need a guaranteed answer, you have to use normal paid support channels.
You can use SQL CE from C++ application using OLEDB and there's no need for you to move to .Net unless you want to. There should be NorthwindOleDbsample included with SQL CE.
|||Here is an example of the OLEDB (in vb - but I guess you should be able to understand it)
http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/08/691894.aspx
Ilya is correct in that this forum is kept going by all sorts - just look at the MVP contributions on here - plus some celebrated authors - and also MS employees including some on the development teams.
What a great mutual support forum this is - everyone pat themselves on their backs :-D
No comments:
Post a Comment