http://www.microsoft.com/sql/editions/compact/default.mspx

--
Ginny Caughey
Device Application Development MVP

Re: SQL Compact Edition downloads and content now live by Harry

Harry
Mon Jan 15 13:02:29 CST 2007

So Ginny,

Is this not just a little confusing to anyone but me? I've got SQL Server
CE 2.0 and SQL Server Mobile (SQL Server CE 3.0), SQL Server Everywhere, and
now SQL Server Compact Edition (as if this is a brand new product).

Could you give me a version primer (for idiots) on where all these fall into
place?

Thanks
Harry

"Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in message
news:OqCFH3MOHHA.4244@TK2MSFTNGP04.phx.gbl...
> http://www.microsoft.com/sql/editions/compact/default.mspx
>
> --
> Ginny Caughey
> Device Application Development MVP
>
>
>



Re: SQL Compact Edition downloads and content now live by Ginny

Ginny
Mon Jan 15 13:14:46 CST 2007

Harry,

Don't feel bad. SQL Mobile - the original version - is version 3.0 The
original SQL Mobile could run on dev machines and TabletPCs as well as
mobile devices (although of course using different native DLLs for desktop
vs. mobile devices.) Desktops weren't generally supported (except for dev
machines and TabletPCs) so we needed a new version 3.1 that removed that
desktop restriction. Version 3.1 was called SQL Server Everywhere during the
beta, but because of confusion with other database products, Microsoft
decided to rename it SQL Server Compact Edition. Version 3.1 is data
compatible with 3.0, so you don't need to change your SDF files when you
upgrade to SSCE 3.1 (unlike moving from SQL CE 2.0 to SQL Mobile/SSCE.)

When you install the SSCE Tools for VS 2005 sp1, you now get "SQL Server
Compact Edition" in the data tools instead of "SQL Mobile". But one other
thing that can be confusing is that SQL Server Management Studio still
refers to "SQL Mobile" even after you've updated everything to SSCE, and
this won't be fixed until the next service patch for SQL Server 2005.

HTH,

--
Ginny Caughey
Device Application Development MVP


"Harry Simpson" <harry.simpson@phgt.net> wrote in message
news:uwRE2eNOHHA.2232@TK2MSFTNGP02.phx.gbl...
> So Ginny,
>
> Is this not just a little confusing to anyone but me? I've got SQL Server
> CE 2.0 and SQL Server Mobile (SQL Server CE 3.0), SQL Server Everywhere,
> and now SQL Server Compact Edition (as if this is a brand new product).
>
> Could you give me a version primer (for idiots) on where all these fall
> into place?
>
> Thanks
> Harry
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in
> message news:OqCFH3MOHHA.4244@TK2MSFTNGP04.phx.gbl...
>> http://www.microsoft.com/sql/editions/compact/default.mspx
>>
>> --
>> Ginny Caughey
>> Device Application Development MVP
>>
>>
>>
>
>



RE: SQL Compact Edition downloads and content now live by Alex

Alex
Tue Jan 30 23:41:00 CST 2007

Hello there

It seems - we the C++/MFC guys should go jump on another wagon... otherwise
- all that I can see is C# and VB samples

So, where should I go from here?

Cheers
Alex

"Ginny Caughey [MVP]" wrote:

> http://www.microsoft.com/sql/editions/compact/default.mspx
>
> --
> Ginny Caughey
> Device Application Development MVP
>
>
>
>

Re: SQL Compact Edition downloads and content now live by Ginny

Ginny
Wed Jan 31 06:07:43 CST 2007

Alex,

The OleDb samples for SQL Mobile should still work for you.

--
Ginny Caughey
Device Application Development MVP


"Alex" <Alex@discussions.microsoft.com> wrote in message
news:BD184801-F9C1-4187-AFE4-3922A0CF7AC0@microsoft.com...
> Hello there
>
> It seems - we the C++/MFC guys should go jump on another wagon...
> otherwise
> - all that I can see is C# and VB samples
>
> So, where should I go from here?
>
> Cheers
> Alex
>
> "Ginny Caughey [MVP]" wrote:
>
>> http://www.microsoft.com/sql/editions/compact/default.mspx
>>
>> --
>> Ginny Caughey
>> Device Application Development MVP
>>
>>
>>
>>



Re: SQL Compact Edition downloads and content now live by jmorris

jmorris
Wed Jan 31 10:55:29 CST 2007

An option for a lightweight but functional database on PocketPC is
Sqlite. We're using is for our latest C++, wxWidgets application and
are very pleased with its performance.
http://www.sqlite.org/


Re: SQL Compact Edition downloads and content now live by Alex

Alex
Wed Jan 31 15:04:00 CST 2007

Hello Ginny

I have just applied the repl CAB file (following Joao's advise) and managed
to get the Analyzer working to open and browse the Northwind database's
customers table.

But when I tried compiling the sample program Northwind, I get an error on
missing a header file named "atldbcli_ce.h" - maybe I am using the wrong
version of this sample program - will appreciate if you point me to the right
one.

Thanks for your help
Alex


"Ginny Caughey [MVP]" wrote:

> Alex,
>
> The OleDb samples for SQL Mobile should still work for you.
>
> --
> Ginny Caughey
> Device Application Development MVP
>
>
> "Alex" <Alex@discussions.microsoft.com> wrote in message
> news:BD184801-F9C1-4187-AFE4-3922A0CF7AC0@microsoft.com...
> > Hello there
> >
> > It seems - we the C++/MFC guys should go jump on another wagon...
> > otherwise
> > - all that I can see is C# and VB samples
> >
> > So, where should I go from here?
> >
> > Cheers
> > Alex
> >
> > "Ginny Caughey [MVP]" wrote:
> >
> >> http://www.microsoft.com/sql/editions/compact/default.mspx
> >>
> >> --
> >> Ginny Caughey
> >> Device Application Development MVP
> >>
> >>
> >>
> >>
>
>
>

Re: SQL Compact Edition downloads and content now live by Ginny

Ginny
Wed Jan 31 15:26:27 CST 2007

Alex,

Have you searched for that file? Joao uses C++ more than I do so perhaps
he'll jump in.

--
Ginny Caughey
Device Application Development MVP


"Alex" <Alex@discussions.microsoft.com> wrote in message
news:F503B0BA-5723-4CC8-B889-E5D74B140792@microsoft.com...
> Hello Ginny
>
> I have just applied the repl CAB file (following Joao's advise) and
> managed
> to get the Analyzer working to open and browse the Northwind database's
> customers table.
>
> But when I tried compiling the sample program Northwind, I get an error on
> missing a header file named "atldbcli_ce.h" - maybe I am using the wrong
> version of this sample program - will appreciate if you point me to the
> right
> one.
>
> Thanks for your help
> Alex
>
>
> "Ginny Caughey [MVP]" wrote:
>
>> Alex,
>>
>> The OleDb samples for SQL Mobile should still work for you.
>>
>> --
>> Ginny Caughey
>> Device Application Development MVP
>>
>>
>> "Alex" <Alex@discussions.microsoft.com> wrote in message
>> news:BD184801-F9C1-4187-AFE4-3922A0CF7AC0@microsoft.com...
>> > Hello there
>> >
>> > It seems - we the C++/MFC guys should go jump on another wagon...
>> > otherwise
>> > - all that I can see is C# and VB samples
>> >
>> > So, where should I go from here?
>> >
>> > Cheers
>> > Alex
>> >
>> > "Ginny Caughey [MVP]" wrote:
>> >
>> >> http://www.microsoft.com/sql/editions/compact/default.mspx
>> >>
>> >> --
>> >> Ginny Caughey
>> >> Device Application Development MVP
>> >>
>> >>
>> >>
>> >>
>>
>>
>>



Re: SQL Compact Edition downloads and content now live by Alex

Alex
Wed Jan 31 16:20:00 CST 2007

Hello again

Just found the more recent version of this sample application through a web
search

It all works fine, I just miss the good old ADO-CE... I wonder why was that
taken out of VS 2005... Any chance for this coming back one day?

Cheers
Alex



"Ginny Caughey [MVP]" wrote:

> Alex,
>
> Have you searched for that file? Joao uses C++ more than I do so perhaps
> he'll jump in.
>
> --
> Ginny Caughey
> Device Application Development MVP
>
>
> "Alex" <Alex@discussions.microsoft.com> wrote in message
> news:F503B0BA-5723-4CC8-B889-E5D74B140792@microsoft.com...
> > Hello Ginny
> >
> > I have just applied the repl CAB file (following Joao's advise) and
> > managed
> > to get the Analyzer working to open and browse the Northwind database's
> > customers table.
> >
> > But when I tried compiling the sample program Northwind, I get an error on
> > missing a header file named "atldbcli_ce.h" - maybe I am using the wrong
> > version of this sample program - will appreciate if you point me to the
> > right
> > one.
> >
> > Thanks for your help
> > Alex
> >
> >
> > "Ginny Caughey [MVP]" wrote:
> >
> >> Alex,
> >>
> >> The OleDb samples for SQL Mobile should still work for you.
> >>
> >> --
> >> Ginny Caughey
> >> Device Application Development MVP
> >>
> >>
> >> "Alex" <Alex@discussions.microsoft.com> wrote in message
> >> news:BD184801-F9C1-4187-AFE4-3922A0CF7AC0@microsoft.com...
> >> > Hello there
> >> >
> >> > It seems - we the C++/MFC guys should go jump on another wagon...
> >> > otherwise
> >> > - all that I can see is C# and VB samples
> >> >
> >> > So, where should I go from here?
> >> >
> >> > Cheers
> >> > Alex
> >> >
> >> > "Ginny Caughey [MVP]" wrote:
> >> >
> >> >> http://www.microsoft.com/sql/editions/compact/default.mspx
> >> >>
> >> >> --
> >> >> Ginny Caughey
> >> >> Device Application Development MVP
> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Re: SQL Compact Edition downloads and content now live by Ginny

Ginny
Wed Jan 31 16:40:49 CST 2007

Alex,

As far as I know ADOCE isn't coming back, and with managed code I don't
really miss it. I understand your point of view though.

--
Ginny Caughey
Device Application Development MVP


"Alex" <Alex@discussions.microsoft.com> wrote in message
news:DC237E04-12E7-4528-9A8B-EF87B06F2829@microsoft.com...
> Hello again
>
> Just found the more recent version of this sample application through a
> web
> search
>
> It all works fine, I just miss the good old ADO-CE... I wonder why was
> that
> taken out of VS 2005... Any chance for this coming back one day?
>
> Cheers
> Alex
>
>
>
> "Ginny Caughey [MVP]" wrote:
>
>> Alex,
>>
>> Have you searched for that file? Joao uses C++ more than I do so perhaps
>> he'll jump in.
>>
>> --
>> Ginny Caughey
>> Device Application Development MVP
>>
>>
>> "Alex" <Alex@discussions.microsoft.com> wrote in message
>> news:F503B0BA-5723-4CC8-B889-E5D74B140792@microsoft.com...
>> > Hello Ginny
>> >
>> > I have just applied the repl CAB file (following Joao's advise) and
>> > managed
>> > to get the Analyzer working to open and browse the Northwind database's
>> > customers table.
>> >
>> > But when I tried compiling the sample program Northwind, I get an error
>> > on
>> > missing a header file named "atldbcli_ce.h" - maybe I am using the
>> > wrong
>> > version of this sample program - will appreciate if you point me to the
>> > right
>> > one.
>> >
>> > Thanks for your help
>> > Alex
>> >
>> >
>> > "Ginny Caughey [MVP]" wrote:
>> >
>> >> Alex,
>> >>
>> >> The OleDb samples for SQL Mobile should still work for you.
>> >>
>> >> --
>> >> Ginny Caughey
>> >> Device Application Development MVP
>> >>
>> >>
>> >> "Alex" <Alex@discussions.microsoft.com> wrote in message
>> >> news:BD184801-F9C1-4187-AFE4-3922A0CF7AC0@microsoft.com...
>> >> > Hello there
>> >> >
>> >> > It seems - we the C++/MFC guys should go jump on another wagon...
>> >> > otherwise
>> >> > - all that I can see is C# and VB samples
>> >> >
>> >> > So, where should I go from here?
>> >> >
>> >> > Cheers
>> >> > Alex
>> >> >
>> >> > "Ginny Caughey [MVP]" wrote:
>> >> >
>> >> >> http://www.microsoft.com/sql/editions/compact/default.mspx
>> >> >>
>> >> >> --
>> >> >> Ginny Caughey
>> >> >> Device Application Development MVP
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>



Re: SQL Compact Edition downloads and content now live by Alex

Alex
Tue Feb 06 14:41:27 CST 2007

Hello Ginny

Well, as I said on a previous message, I got the Nortwind sample to work
after Joao's help of a repl CAB missing on my device.

BUT - the Microsoft Northwind sample is a WIN32 application. When I tried
creating in VS 2005 a smart device MFC application, and added the support
header files required, my application builds OK, but the first step of
attempting to initialize the process fails on the following call :

CoCreateInstance( CLSID_SQLSERVERCE_3_0,0,CLSCTX_INPROC_SERVER,IID_IDBInitialize,(void**)&pIDBInitialize);

There is no explanation why, but of course from this point onwards, nothing
else can work.

I really need to be able and use MFC and not be restricted back to a 1990
technology...

Hope you can help

Thanks
Alex

"Ginny Caughey [MVP]" wrote:

> Alex,
>
> The OleDb samples for SQL Mobile should still work for you.
>
> --
> Ginny Caughey
> Device Application Development MVP
>
>
> "Alex" <Alex@discussions.microsoft.com> wrote in message
> news:BD184801-F9C1-4187-AFE4-3922A0CF7AC0@microsoft.com...
> > Hello there
> >
> > It seems - we the C++/MFC guys should go jump on another wagon...
> > otherwise
> > - all that I can see is C# and VB samples
> >
> > So, where should I go from here?
> >
> > Cheers
> > Alex
> >
> > "Ginny Caughey [MVP]" wrote:
> >
> >> http://www.microsoft.com/sql/editions/compact/default.mspx
> >>
> >> --
> >> Ginny Caughey
> >> Device Application Development MVP
> >>
> >>
> >>
> >>
>
>
>

Re: SQL Compact Edition downloads and content now live by Ginny

Ginny
Tue Feb 06 15:22:04 CST 2007

Alex,

Joao will probably be your best resource for native apps. I assume you've
double checked the values you're passing to CoCreateInstance? If the sample
is a desktop app I wouldn't be too surprised if it doesn't work as is.

--
Ginny Caughey
Device Application Development MVP


"Alex" <Alex@discussions.microsoft.com> wrote in message
news:F9C12E9E-ED35-4447-8B79-557C51A4B06D@microsoft.com...
> Hello Ginny
>
> Well, as I said on a previous message, I got the Nortwind sample to work
> after Joao's help of a repl CAB missing on my device.
>
> BUT - the Microsoft Northwind sample is a WIN32 application. When I tried
> creating in VS 2005 a smart device MFC application, and added the support
> header files required, my application builds OK, but the first step of
> attempting to initialize the process fails on the following call :
>
> CoCreateInstance(
> CLSID_SQLSERVERCE_3_0,0,CLSCTX_INPROC_SERVER,IID_IDBInitialize,(void**)&pIDBInitialize);
>
> There is no explanation why, but of course from this point onwards,
> nothing
> else can work.
>
> I really need to be able and use MFC and not be restricted back to a 1990
> technology...
>
> Hope you can help
>
> Thanks
> Alex
>
> "Ginny Caughey [MVP]" wrote:
>
>> Alex,
>>
>> The OleDb samples for SQL Mobile should still work for you.
>>
>> --
>> Ginny Caughey
>> Device Application Development MVP
>>
>>
>> "Alex" <Alex@discussions.microsoft.com> wrote in message
>> news:BD184801-F9C1-4187-AFE4-3922A0CF7AC0@microsoft.com...
>> > Hello there
>> >
>> > It seems - we the C++/MFC guys should go jump on another wagon...
>> > otherwise
>> > - all that I can see is C# and VB samples
>> >
>> > So, where should I go from here?
>> >
>> > Cheers
>> > Alex
>> >
>> > "Ginny Caughey [MVP]" wrote:
>> >
>> >> http://www.microsoft.com/sql/editions/compact/default.mspx
>> >>
>> >> --
>> >> Ginny Caughey
>> >> Device Application Development MVP
>> >>
>> >>
>> >>
>> >>
>>
>>
>>



Re: SQL Compact Edition downloads and content now live by Alex

Alex
Tue Feb 06 15:48:02 CST 2007

Hello again

1) My app is intended for a mobile device, not sure what you mean by
"Desktop app"
2) Not sure how to trigger Joao response on this, I just posted the message
here, is he likely to pick it? Or maybe you have an email address for me to
direct it to him?

Cheers
Alex

"Ginny Caughey [MVP]" wrote:

> Alex,
>
> Joao will probably be your best resource for native apps. I assume you've
> double checked the values you're passing to CoCreateInstance? If the sample
> is a desktop app I wouldn't be too surprised if it doesn't work as is.
>
> --
> Ginny Caughey
> Device Application Development MVP
>
>
> "Alex" <Alex@discussions.microsoft.com> wrote in message
> news:F9C12E9E-ED35-4447-8B79-557C51A4B06D@microsoft.com...
> > Hello Ginny
> >
> > Well, as I said on a previous message, I got the Nortwind sample to work
> > after Joao's help of a repl CAB missing on my device.
> >
> > BUT - the Microsoft Northwind sample is a WIN32 application. When I tried
> > creating in VS 2005 a smart device MFC application, and added the support
> > header files required, my application builds OK, but the first step of
> > attempting to initialize the process fails on the following call :
> >
> > CoCreateInstance(
> > CLSID_SQLSERVERCE_3_0,0,CLSCTX_INPROC_SERVER,IID_IDBInitialize,(void**)&pIDBInitialize);
> >
> > There is no explanation why, but of course from this point onwards,
> > nothing
> > else can work.
> >
> > I really need to be able and use MFC and not be restricted back to a 1990
> > technology...
> >
> > Hope you can help
> >
> > Thanks
> > Alex
> >
> > "Ginny Caughey [MVP]" wrote:
> >
> >> Alex,
> >>
> >> The OleDb samples for SQL Mobile should still work for you.
> >>
> >> --
> >> Ginny Caughey
> >> Device Application Development MVP
> >>
> >>
> >> "Alex" <Alex@discussions.microsoft.com> wrote in message
> >> news:BD184801-F9C1-4187-AFE4-3922A0CF7AC0@microsoft.com...
> >> > Hello there
> >> >
> >> > It seems - we the C++/MFC guys should go jump on another wagon...
> >> > otherwise
> >> > - all that I can see is C# and VB samples
> >> >
> >> > So, where should I go from here?
> >> >
> >> > Cheers
> >> > Alex
> >> >
> >> > "Ginny Caughey [MVP]" wrote:
> >> >
> >> >> http://www.microsoft.com/sql/editions/compact/default.mspx
> >> >>
> >> >> --
> >> >> Ginny Caughey
> >> >> Device Application Development MVP
> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Re: SQL Compact Edition downloads and content now live by Ginny

Ginny
Tue Feb 06 16:15:58 CST 2007

Alex,

I wasn't clear if the sample you were working from was targetting a mobile
device or if you were modifying a desktop sample.

Joao checks these newsgroups as he's able to, but we all have day jobs and
some days are a lot busier than others. His website is www.primeworks.pt so
you may find a link there as well as information about his nice products.

--
Ginny Caughey
Device Application Development MVP


"Alex" <Alex@discussions.microsoft.com> wrote in message
news:08E0CA04-F0D6-4C36-AA6C-9CAA5227E43E@microsoft.com...
> Hello again
>
> 1) My app is intended for a mobile device, not sure what you mean by
> "Desktop app"
> 2) Not sure how to trigger Joao response on this, I just posted the
> message
> here, is he likely to pick it? Or maybe you have an email address for me
> to
> direct it to him?
>
> Cheers
> Alex
>
> "Ginny Caughey [MVP]" wrote:
>
>> Alex,
>>
>> Joao will probably be your best resource for native apps. I assume you've
>> double checked the values you're passing to CoCreateInstance? If the
>> sample
>> is a desktop app I wouldn't be too surprised if it doesn't work as is.
>>
>> --
>> Ginny Caughey
>> Device Application Development MVP
>>
>>
>> "Alex" <Alex@discussions.microsoft.com> wrote in message
>> news:F9C12E9E-ED35-4447-8B79-557C51A4B06D@microsoft.com...
>> > Hello Ginny
>> >
>> > Well, as I said on a previous message, I got the Nortwind sample to
>> > work
>> > after Joao's help of a repl CAB missing on my device.
>> >
>> > BUT - the Microsoft Northwind sample is a WIN32 application. When I
>> > tried
>> > creating in VS 2005 a smart device MFC application, and added the
>> > support
>> > header files required, my application builds OK, but the first step of
>> > attempting to initialize the process fails on the following call :
>> >
>> > CoCreateInstance(
>> > CLSID_SQLSERVERCE_3_0,0,CLSCTX_INPROC_SERVER,IID_IDBInitialize,(void**)&pIDBInitialize);
>> >
>> > There is no explanation why, but of course from this point onwards,
>> > nothing
>> > else can work.
>> >
>> > I really need to be able and use MFC and not be restricted back to a
>> > 1990
>> > technology...
>> >
>> > Hope you can help
>> >
>> > Thanks
>> > Alex
>> >
>> > "Ginny Caughey [MVP]" wrote:
>> >
>> >> Alex,
>> >>
>> >> The OleDb samples for SQL Mobile should still work for you.
>> >>
>> >> --
>> >> Ginny Caughey
>> >> Device Application Development MVP
>> >>
>> >>
>> >> "Alex" <Alex@discussions.microsoft.com> wrote in message
>> >> news:BD184801-F9C1-4187-AFE4-3922A0CF7AC0@microsoft.com...
>> >> > Hello there
>> >> >
>> >> > It seems - we the C++/MFC guys should go jump on another wagon...
>> >> > otherwise
>> >> > - all that I can see is C# and VB samples
>> >> >
>> >> > So, where should I go from here?
>> >> >
>> >> > Cheers
>> >> > Alex
>> >> >
>> >> > "Ginny Caughey [MVP]" wrote:
>> >> >
>> >> >> http://www.microsoft.com/sql/editions/compact/default.mspx
>> >> >>
>> >> >> --
>> >> >> Ginny Caughey
>> >> >> Device Application Development MVP
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>