Re: Embedded XP & SQL CE

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank you for your response. i want to go the route of using Com
Interop and use ADO.NET. But any idea if there will be any huge
performance hit if i go this route. especially in a embedded xp
environment ?


On Oct 16, 12:02 pm, "Ginny Caughey MVP"
<ginny.caughey.onl...@xxxxxxxxxxxxxx> wrote:
You can access SQL CE from a C++ app. Usually OleDb is what people use. Here
is a good blog devoted to native development with SQL CE:http://nativemobile.blogspot.com/feeds/posts/default?alt=rss

Although it is possible to use classic ADO with SQL CE, it is not a
supported scenario. For example there is a known issue inserting more than
some number of characters in a nvarchar column. There may be other issues as
well. It just wasn't an intended use of the OleDb provider for SQL CE as I
understand it.

Of course you could use write a C# DLL that uses ADO.NET, which is
supported, to connect to the database and then expose that DLL via COM to
your C++ app, but I don't know if you'd want to go that route.

--

Ginny Caughey
Device Application Development MVP

<devinwhi...@xxxxxxxxx> wrote in message

news:6fca70ad-17c0-4d9c-83e8-107ce6409147@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Ok VistaDB is out. they dont want to run on Embedded xp. Can SQL CE be
used from a C++ COM DLL> can you point me to some samples for that if
any...

On Oct 16, 7:57 am, devinwhi...@xxxxxxxxx wrote:



may be this is what i need to use if i need to use VistaDB or even for
that matter SQL CE as it makes my life easy :)

How to: Register a Component for COM
Interophttp://msdn.microsoft.com/en-us/library/w29wacsy%28VS.80%29.aspx

On Oct 16, 6:52 am, devinwhi...@xxxxxxxxx wrote:

Thank you for your response. All the processes will be on the same
embedded box and it will be one single box using the db.
Also i was looking at using VistaDB as well. Any experience using
that ?

but i have an issue there... all my services are in unmanaged C++
( built in the VS6 era !). They are currently using a COM layer which
then uses ADO to access SQL Server. With SQL CE im sure i can still
keep the COM layer but obviously build a new COM DLL to access SQL CE
via ADO.

But what about VistaDB which supports only .NET ? is there a way for
my C++ COM dll to communicate with the VistaDB ? i know this may be a
question for the VistaDB group :)

On Oct 15, 4:29 pm, "Ginny Caughey MVP"

<ginny.caughey.onl...@xxxxxxxxxxxxxx> wrote:
SQL CE should be fine and a huge improvement over writing your own
data
store. You won't be able to use your stored procedures although you
can
store the statement text as resource strings for easier maintenance..
The
other major thing to be aware of since you mentioned "server product"
is
that although SQL CE does support multiple concurrent connections from
different processes, all those processes must be on the same machine.
If you
need for multiple machines to access the same data concurrently,
you're
better off staying with Express.

--

Ginny Caughey
Device Application Development MVP

<devinwhi...@xxxxxxxxx> wrote in message

news:644555bf-0f91-44ca-85ea-5fe4fcf6428f@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hi,

We have a client server product using SQL Express/Microsoft SQL
Server
as a backend. we have a lot of StoredProcedures we use in the
product.

We are now planning to create a low end version of the server
product
which can run off a device running Windows XP Embedded. So i have
thinking of using SQL CE because of its low footprint instead of SQL
Express. Any reasons why i should not. The other otpion i have is to
build my own data store...

Thanks for the help.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • Re: Deploying sql everwhere
    ... that has updates for sql mobile (there is only the sql everwhere ctp which I ... the sqlcerverce dll: ... need to reference the desktop DLLs, and for a device app you need to ...
    (microsoft.public.sqlserver.ce)
  • Re: Embedded XP & SQL CE
    ... Device Application Development MVP ... is a good blog devoted to native development with SQL CE:http://nativemobile.blogspot.com/feeds/posts/default?alt=rss ... to connect to the database and then expose that DLL via COM to ... Ok VistaDB is out. ...
    (microsoft.public.sqlserver.ce)
  • Re: Deploying sql everwhere
    ... thanks again for your help with the sql everywhere issues. ... that has updates for sql mobile (there is only the sql everwhere ctp ... the sqlcerverce dll: ... installation but the install did not put any new CAB files on ...
    (microsoft.public.sqlserver.ce)
  • Re: Deploying sql everwhere
    ... Microsoft is aware of one of the bugs - I submitted a support request for it ... error that I get 'sql mobile has encountered an error opening the database'. ... this is the dll I referenced in my .NET compact application but perhaps ...
    (microsoft.public.sqlserver.ce)
  • Re: Deploying sql everwhere
    ... that has updates for sql mobile (there is only the sql everwhere ctp which ... this is the dll I referenced in my .NET compact application but perhaps ... installation but the install did not put any new CAB files on my ...
    (microsoft.public.sqlserver.ce)