|
|
Posted by Erland Sommarskog on 12/18/07 22:14
Neil (nospam@nospam.net) writes:
> Using SQL 7 with an Access 2000 MDB front end with ODBC linked tables.
>
> Have a DateModified field which previously was smalldatetime. Changed
> over the weekend to datetime. Field is updated with a trigger that sets
> value to GetDate().
>
> One record in the table now cannot be updated. In Access, get message:
>
> [microsoft][odbc sql server driver]fractional truncation (#0)
> [microsoft][odbc sql server driver]timeout expired (#0)
Note that these errors are from ODBC SQL Server driver, not from
SQL Server.
> In QA (using Update), no message; just hangs.
Did you close down the Access application? While hanging in QA is
consistent with he "timeout expired" in Access (QA does not have
any timeout by default), my suspicion is that the first error
left the row lock and blocked.
You can use sp_who2 to determine if you have any blocking. If there a
non-zero value in the Blk column, that is the spid of the blocker.
Examine further to see which application it's running.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|