Re: Does SQL Server Compact 3.1 support multi connection?

Thanks, your advice.

I know it already.
It's the point that SQL CE not designed for the situation like a web server
in enterprise environment especially be requested to give many user
connections from remote.

But, our situation is that it will be request user connection under 5 usually.
And we expect worst case is like 10 connections.
Also we'll block the connections to browser to 10 connections.


"Laxmi Narsimha Rao Oruganti [MSFT]" wrote:

Just wanted to add a final note that, though it might be ok to run SQL CE
under web server on a device; I want to inform you and others on the forum
that SQL CE is simply not designed for big web servers (like Apache and IIS
on desktop). Hence, we explicitly check WebHosting and block SQL CE usage.
We also provided a way to surpass this check, but it is upto the
developer/customer to take that risk and Microsoft does not support and is
not responsible.

Thanks,
Laxmi [Disclaimer: All postings are as-is and confer no rights]

"Paul G. Tobey [eMVP]" <p space tobey no spam AT no instrument no spam DOT
com> wrote in message news:uXF3h2c5IHA.1176@xxxxxxxxxxxxxxxxxxxxxxx
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?
    ... 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?
    ... 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. ... 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)