Re: Multiple User Access through ADO?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

SqlCE is can handle connections from multiple applications and threads on the same machine. It can also be used with IIS for multiple web requests for data, but this is still on the same machine.

--

Ginny Caughey
Device Application Development MVP



"Michael" <m.hlavinkamsdn@xxxxxxx> wrote in message news:925ACF4B-E5F0-437A-B185-B1C500F3E82E@xxxxxxxxxxxxxxxx
I hate to be persistent, but when they say it is a multiuser database
platform, where is the multiuser capability?

Michael

"Ginny Caughey MVP" wrote:

I haven't tested it with Terminal Services, but I imagine it is the same.
SqlCE opens the SDF file with an exclusive lock from across a network share,
so other users from different machines are denied access. Multiple
connections from the same machine are allowed, but with Terminal Services
apparently SqlCE doesn't see those connections as coming from the same
machine.

--

Ginny Caughey
Device Application Development MVP



"Michael" <m.hlavinkamsdn@xxxxxxx> wrote in message
news:A1CC391C-88A8-42C1-931A-7F8AED1FC3F9@xxxxxxxxxxxxxxxx
> Is this the same for multiple users logged into a terminal server
> connected
> to the same database residing on the terminal server itself?
>
> If so, what type of multi user access is allowed?
>
> "Ginny Caughey MVP" wrote:
>
>> Michael,
>>
>> Across a network share SqlCE only accepts a single machine's >> connection.
>> This is by design and is the same for ADO.NET. If you need multi-user
>> access, consider SQL Express instead.
>>
>> -- >>
>> Ginny Caughey
>> Device Application Development MVP
>>
>>
>>
>> "Michael" <m.hlavinkamsdn@xxxxxxx> wrote in message
>> news:2E11633C-9CBA-4F25-A5E1-C5793ABB65B3@xxxxxxxxxxxxxxxx
>> > I have a SQLCE database on a terminal server. Opening the database
>> > works
>> > fine for the first user, but fails for subsequent users. The same
>> > failure
>> > occurs if the database is placed on a share and multiple users from
>> > different
>> > systems attempt to open it. The database is opened using ADO with >> > the
>> > following syntax:
>> >
>> > Sub test()
>> > Dim CNN As New ADODB.Connection
>> > CNN.ConnectionString =
>> > "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data
>> > Source='C:\Folder\MyDatabase#1.sdf';"
>> > CNN.Open
>> >
>> > .. Do something to keep the connection open while another user >> > attempts
>> > to
>> > open
>> > End Sub
>> >
>> > Currently, a switch to ADO.Net or OLE DB is not feasible as this is >> > a
>> > very
>> > large program that contains a significant amount of ADO code.
>> >
>> > Thanks for input.
>>
>>

.

Relevant Pages