Re: Does SQL Server Compact 3.1 support multi connection?

jp,

I'm not sure exactly what you want to do. SQL Compact supports multiple concurrent connections on the same machine. For example, you can have multiple threads or apps, each using its own connection, to access a database. But I don't see how this would allow you to span a transaction across multiple threads, processes, etc.

--

Ginny Caughey
Device Application Development MVP


"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

.

Relevant Pages

  • Re: multi thread required for async sockets?
    ... Just note that the article in the MSDN on multithreaded sockets is the ... any part of it to work (the example, of using multiple threads for sockets, gets sockets ... and the CAsyncSocket class converts those messages into ... It's only when you create too many simultaneous connections (like, ...
    (microsoft.public.vc.mfc)
  • Re: Developing recommendations
    ... Any time you need to do multiple bits of work (three connections at a time), you will need to divide the work up. ... This is a bit more complex possibly, but not much, as you are already working with multiple threads. ... As you have your own SMPP connections wired in, it may not be an option without rearchitecting. ... I am going to develop a server application in VS.NET C# for sending SMS ...
    (microsoft.public.dotnet.framework)
  • Re: dbcopy over secure/encrypted line
    ... Why not write a simple python script that has two database ... connections. ... then create multiple threads and do a ... You can do this over an SSH tunnel. ...
    (comp.databases.informix)
  • RE: dbcopy over secure/encrypted line
    ... Why not write a simple python script that has two database ... connections. ... then create multiple threads and do a ... That is exactly what Art's dbcopy utility does, ...
    (comp.databases.informix)
  • Re: maximum number of sessions
    ... I am interested in the maximum number of sessions not connections. ... I.e I can have 15 mapped drives from one machine to ... We have 6 pcs connecting to a 7 pc we call our server. ...
    (microsoft.public.windowsxp.network_web)
Loading