Re: Does SQL Server Compact 3.1 support multi connection?

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?


"Laxmi Narsimha Rao ORUGANTI [MSFT]" wrote:

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

"jpkong" <jpkong@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:19799352-8D6F-48E2-9821-3DFDC9CFE41B@xxxxxxxxxxxxxxxx
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?


"William Vaughn (MVP)" wrote:

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.

"jpkong" <jpkong@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7CADE68E-D269-4230-B377-BAEC634C1F3B@xxxxxxxxxxxxxxxx
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

--
__________________________________________________________________________
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)
____________________________________________________________________________________________






.

Relevant Pages

  • Re: Does SQL Server Compact 3.1 support multi connection?
    ... All apps and web server, SQLCE 3.1 run on the same machine. ... As long as the connections are all on the same machine, ... But I'm meaning simultaneous multiple connections from apps and web server ...
    (microsoft.public.sqlserver.ce)
  • Re: Does SQL Server Compact 3.1 support multi connection?
    ... It's the point that SQL CE not designed for the situation like a web server ... And we expect worst case is like 10 connections. ... But I'm meaning simultaneous multiple connections from apps and web ...
    (microsoft.public.sqlserver.ce)
  • Re: Does SQL Server Compact 3.1 support multi connection?
    ... Does SQL CE 3.1 support simultaneous multiple connections from apps, ... You and Ginny might told me about transactions between apps and web server. ...
    (microsoft.public.sqlserver.ce)
  • Re: Many sockets in SYN_SENT state
    ... because I found a rogue program running on an old web server I had ... > My system is a linux server functioning as web server. ... the connections are held in SYN_SENT ... Today I decided to strace my apache processes, ...
    (comp.os.linux.networking)
  • Re: Many sockets in SYN_SENT state
    ... because I found a rogue program running on an old web server I had ... > My system is a linux server functioning as web server. ... the connections are held in SYN_SENT ... Today I decided to strace my apache processes, ...
    (comp.os.linux.networking)
Loading