Re: Does SQL Server Compact 3.1 support multi connection?

It's running fine on our Windows CE 5.0-based devices.

Paul T.

"jpkong" <jpkong@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:40AD7902-CE00-41C6-8EE8-BD1EE0FE4C2B@xxxxxxxxxxxxxxxx
Thanks so much.

I know all we need prototyping.
So I asking it to you before that. :)

Also, I'm really appreciate your new asking.

I consider to use SQL CE 3.5 on WinCE 5.0 if it doesn't need any license
cause we'll use it as internal usage only in one machine with one
connection
from Crystal Report.

But someone told me that SQL CE 3.5 couldn't be used with WinCE 5.0 only
with WinCE 6.0.
As I think I saw it support WinCE 5.0 so I just like to check it..


Could I use SQL CE 3.5 with WinCE 5.0?
And what's the points it's better to use 3.5 than 3.1 for like our
project?


"Ginny Caughey MVP" wrote:

Yes, but why not SQL CE 3.5? And as always, you should prototype whatever
you want to do to make sure your proposed solution meets your needs.

--

Ginny Caughey
Device Application Development MVP


"jpkong" <jpkong@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:24673230-D9BB-4404-A580-2E133E23BB4A@xxxxxxxxxxxxxxxx
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)
____________________________________________________________________________________________










.

Relevant Pages

  • 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?
    ... Just wanted to add a final note that, though it might be ok to run SQL CE ... All apps and web server, SQLCE 3.1 run on the same machine. ... 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?
    ... I consider to use SQL CE 3.5 on WinCE 5.0 if it doesn't need any license ... 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 ...
    (microsoft.public.sqlserver.ce)
  • 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: Connection issues
    ... If a process is sleeping, a connection is established, but no commands have ... SP_who2 on the SQL server. ... > Our web server and db server are on 2 sep. machines. ... > of the connections were timing out. ...
    (microsoft.public.sqlserver.connect)
Loading