Does SQL Server Compact 3.1 support multi connection?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jpkong - 14 Jul 2008 01:42 GMT

Hi.

I wonder whether SQL CE editions support multi connection(also multi user),
multi session in connection or not.
If that, how many connections or sessions are supported by it?

For my case, I need the connections from a Web Server and an application to
SQL CE.
And in the application, it need multiple sessions in a connection for
transaction from various parts of the application.

Anyone let me know it?
Thanks in advance.

jp

Reply to this Message

William Vaughn (MVP) - 14 Jul 2008 03:11 GMT

As I discuss in my EBook, the SQLCe engine can support multiple connections,
but only from the same user. This means the DBMS does not know how to share
data between users. I suggest looking at a replication architecture or a
DBMS engine like SQL Server (Express) that supports multiple users.

> Hi.
>
[quoted text clipped - 13 lines]
>
> jp

Signature

__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________

Reply to this Message

jpkong - 14 Jul 2008 05:43 GMT

Sorry, I meant that case as the situation like business logic apps and web
server on the same machine of ARM CPU with WinCE 5.0.

And it that case, apps use multiple connections to DB simultaneously.
Also a web server will needs few connections to DB simultaneously.

Isn't it a single user case?
So, SQLCE 3.1 is apt to our situation. Is it right?

> As I discuss in my EBook, the SQLCe engine can support multiple connections,
> but only from the same user. This means the DBMS does not know how to share
[quoted text clipped - 18 lines]
> >
> > jp

Reply to this Message

Laxmi Narsimha Rao ORUGANTI [MSFT] - 14 Jul 2008 09:07 GMT

Hey JP,

As I understand, you have a mini webserver running on WINCE device. This
web server opens connections to DB and there could be multiple connections.
Which is quite possible with SQL CE. However, as Ginny pointed out we do
not have transactions that deal with multiple connections. All our
transactions are one-to-one with connection.

Thanks,
Laxmi

> Sorry, I meant that case as the situation like business logic apps and web
> server on the same machine of ARM CPU with WinCE 5.0.
[quoted text clipped - 30 lines]
>> >
>> > jp

Reply to this Message

jpkong - 14 Jul 2008 14:21 GMT

Laxmi,

You and Ginny might told me about transactions between apps and web server.

But I'm meaning simultaneous multiple connections from apps and web server
to DB only, not between apps and web server.

If I made misunderstanding, sorry.

I think SQL CE 3.1 support my needs.
Right?

> Hey JP,
>
[quoted text clipped - 41 lines]
> >> >
> >> > jp

Reply to this Message

jpkong - 14 Jul 2008 14:35 GMT

Ok. I'll change my question.

Does SQL CE 3.1 support simultaneous multiple connections from apps, a web
server to it?

As I found this, http://msdn.microsoft.com/en-us/library/ms171750.aspx
I think so.

I'm really curious about it and whether I can use SQLCE 3.1 in my project or
not.

Thanks.

> Laxmi,
>
[quoted text clipped - 53 lines]
> > >> >
> > >> > jp

Reply to this Message

Ginny Caughey MVP - 14 Jul 2008 03:37 GMT

jp,

I'm not sure exactly what you want to do. SQL Compact supports multiple
concurrent connections on the same machine. For example, you can have
multiple threads or apps, each using its own connection, to access a
database. But I don't see how this would allow you to span a transaction
across multiple threads, processes, etc.

Signature

Ginny Caughey
Device Application Development MVP

> Hi.
>
[quoted text clipped - 13 lines]
>
> jp

Reply to this Message