The SQL Statement that is in the Stored procedure spans multiple tables, one
of those tables is regularly getting updated. Below is a sample of the code
that actually gets the deadlock error
StrSQL = "SELECT PW, UID, FailedLogins, AllowOF FROM SP_Login('"
& Me.Username & "')"
LogLoginAttempt(Me.RemoteIP, Me.Username, Me.Password)
LoggedIn = False
FBCLogin.CommandText = StrSQL
FBCLogin.Connection = Conn
FBDRLogin = FBCLogin.ExecuteReader
If FBDRLogin.Read = False Then '' This is where the error
occurs.
LoggedIn = False
John Smith
----- Original Message -----
From: "Jiri Cincura" <[EMAIL PROTECTED]>
To: "For users and developers of the Firebird .NET providers"
<[email protected]>
Sent: Tuesday, October 03, 2006 4:06 PM
Subject: Re: [Firebird-net-provider] deadlock
> John Smith wrote:
>> Well from what I can tell is that when the application executes
>> several
>> commands in a row very quickly I get the deadlock error. The type of
>> command
>> I am executing on is a Stored Procedure that accesses several tables at
>
> How are you executing commands?
>
>> once. Should I change the Stored procedure into a View? So I can
>> duplicate
>> the error by executing very short executing statements one after the
>> other.
>
> What is doing the SP? Only select (if you're able to remake it to view)?
> Sounds really weird, that only select can do deadlock.
>
> --
> Jiri {x2} Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Firebird-net-provider mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
