AlexEg
May 7th, 2004, 10:59 AM
Hi,
I have two apllications connected to MSSQL2000 server at the same time. One connection is via ODBC, second use OLEDB. When SQL server run on single-processor HW (for example my notebook) everything is ok. But when I test it on server with 2 processors both communications generate errors "deadlock on locked resource". I tried to select in the SQL server settings that SQL can use only one processor, but it had no effect.
Have you any idea?
Thanks, Alex.
I have two apllications connected to MSSQL2000 server at the same time. One connection is via ODBC, second use OLEDB. When SQL server run on single-processor HW (for example my notebook) everything is ok. But when I test it on server with 2 processors both communications generate errors "deadlock on locked resource". I tried to select in the SQL server settings that SQL can use only one processor, but it had no effect.
Have you any idea?
Thanks, Alex.