Re: Does SQL Server Compact 3.1 support multi connection?
- From: jpkong <jpkong@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 14 Jul 2008 06:56:03 -0700
Ginny,
Yes.
All apps and web server, SQLCE 3.1 run on the same machine.
I think misunderstanding was solved.
So, in my case, I can use SQLCE 3.1
Yes or No?
"Ginny Caughey MVP" wrote:
jp,.
As long as the connections are all on the same machine, you should indeed be
able to connect multiple times concurrently.
--
Ginny Caughey
Device Application Development MVP
"jpkong" <jpkong@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B1F4C2D0-A4DF-43BF-86C6-59739880F971@xxxxxxxxxxxxxxxx
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)
____________________________________________________________________________________________
- References:
- Re: Does SQL Server Compact 3.1 support multi connection?
- From: William Vaughn \(MVP\)
- Re: Does SQL Server Compact 3.1 support multi connection?
- From: jpkong
- Re: Does SQL Server Compact 3.1 support multi connection?
- From: Laxmi Narsimha Rao ORUGANTI [MSFT]
- Re: Does SQL Server Compact 3.1 support multi connection?
- From: jpkong
- Re: Does SQL Server Compact 3.1 support multi connection?
- Prev by Date: Re: Does SQL Server Compact 3.1 support multi connection?
- Next by Date: Re: Does SQL Server Compact 3.1 support multi connection?
- Previous by thread: Re: Does SQL Server Compact 3.1 support multi connection?
- Next by thread: Re: Does SQL Server Compact 3.1 support multi connection?
- Index(es):
Relevant Pages
|
