Re: Does SQL Server Compact 3.1 support multi connection?

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.

"jpkong" wrote:

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: pf buggy on 6.1-STABLE?
    ... when application used for load-testing web server running on MS Windows ... reuses source TCP port numbers for these outbound connections. ...
    (freebsd-stable)
  • Re: iptables input DROP rule
    ... > Trying to setup iptables firewall on a web server. ... > Then when I try to access a web page on this server. ... You have made other mistakes like accepting connections ...
    (comp.os.linux.security)
  • Re: iptables input DROP rule
    ... > Trying to setup iptables firewall on a web server. ... > Then when I try to access a web page on this server. ... You have made other mistakes like accepting connections ...
    (comp.os.linux.security)
  • Re: Does SQL Server Compact 3.1 support multi connection?
    ... You and Ginny might told me about transactions between apps and web server. ... web server opens connections to DB and there could be multiple connections. ...
    (microsoft.public.sqlserver.ce)
  • Re: WinXP as a web server
    ... First of all check with your cable company that they will allow you to do ... connections - a connection can be anything from a page to a photo... ... Windows 2000 Server or Windows 2003 Server. ... > Is it possible to set up WinXP Pro as a web server if you ...
    (microsoft.public.windowsxp.setup_deployment)
Loading