Concurrency problem

11 May 2005 3:14 PM

Jared Burford

Users A and B execute a simple "SELECT FROM ..." statement at the same
time.Both concurrent requests on SQL server 2000 fail with an error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC
SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access
denied.

The SQL requests are from ASP page on a shared SQL server. How do I enable
several users execute my sql statements at the same time (only reading
data). Is locking
causing this problem or something else? Should I use WITH(UNLOCK)?

Jared Burford
Computer IT/Support
supp***@megatech-pc.com

11 May 2005 3:39 PM

Alejandro Mesa

The error has nothing to do with locking. Check the connection and if the
users have rights to access the databse and the table.

AMB

Show quote

"Jared Burford" wrote:

> Users A and B execute a simple "SELECT FROM ..." statement at the same
> time.Both concurrent requests on SQL server 2000 fail with an error message:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC
> SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access
> denied.
>
> The SQL requests are from ASP page on a shared SQL server. How do I enable
> several users execute my sql statements at the same time (only reading
> data). Is locking
> causing this problem or something else? Should I use WITH(UNLOCK)?
>
>
> Jared Burford
> Computer IT/Support
> supp***@megatech-pc.com
>
>
>

14 May 2005 8:54 AM

Jared Burford

Problem solved... I just open tabe, read it, and close, it, set the flag on
that one so it won't check it next time, and move to the next, and repeat.
This way other uses can read the same table without getting stuck.
Show quote

"Alejandro Mesa" <AlejandroM***@discussions.microsoft.com> wrote in message
news:BF533DFA-EC96-4B46-89CD-FE3CD47FFB3C@microsoft.com...
> The error has nothing to do with locking. Check the connection and if the
> users have rights to access the databse and the table.
>
>
> AMB
>
> "Jared Burford" wrote:
>
>> Users A and B execute a simple "SELECT FROM ..." statement at the same
>> time.Both concurrent requests on SQL server 2000 fail with an error
>> message:
>>
>> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>> [Microsoft][ODBC
>> SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access
>> denied.
>>
>> The SQL requests are from ASP page on a shared SQL server. How do I
>> enable
>> several users execute my sql statements at the same time (only reading
>> data). Is locking
>> causing this problem or something else? Should I use WITH(UNLOCK)?
>>
>>
>> Jared Burford
>> Computer IT/Support
>> supp***@megatech-pc.com
>>
>>
>>