Monday, April 24, 2006

Preparing for SQL Everywhere

Since Microsoft announced that SQL Mobile would run on all desktop platforms under the "SQL Everywhere" name, I have been wondering how easy it would be to set up my development PC in order to start testing the native OLE DB interfaces.

Well, it's easy enough. First, make sure you have Visual Studio 2005 installed (one of the versions that carries the SQL Mobile bits). Second, go to the C:\Program Files\Microsoft Visual Studio 8\Common7\IDE directory and copy all the sqlce*.dll files to your C:\Windows\System32 directory. Third, register the sqlceoledb30.dll file using regsvr32.exe Finally, open the ssceoledb30.h file and copy the SQL Mobile definitions to a header file of their own.

After this very simple routine, I was able to quickly write a desktop C++ application to create an SDF file on my desktop using code borrowed from eVC3/4! You just need to include your new header file after atldbcli.h and you are done... I will give all the details in an upcoming article.

Ah, and don't forget: this only works on development machines with VS 2005 and Windows XP Tablet PC edition. These license limitations should be lifted when we get the Everywhere bits by the end of this calendar year.


Aaron said...

Just so I'm clear, will there be a licence that we can distrubute so end-user's software (not developers) can read/write SQL Anywhere databases?

João Paulo Figueira said...

If I correctly understand Microsoft's statements, the answer is YES.

mendiola_loyola said...

Dear Joao:

Is there a way to use SQlEverywhere with MFC to access data using Ole DB in native VC++?

I'm using the librarys:
#include "ca_merge30.h"
#include "ssceoledb30.h"
#include "ssceerr30.h"

Is there little examples to learn Ole DB with SQlEveryWhere with native Code?

Alfredo Mendiola Loyola
Lima Perú