ProIV & SQL Server 2005
Posted 12 July 2006 - 02:36 PM
I'm not sure if it's our application architecture, but we have had problems with locking and deadlocks. It appears that SQL 2K5 has a new locking algorithm - a search for "SQL Server 2005 locking" on Google may provide some insights.
Please note that PROIV do not support SQL Server 2005 until PROIV v6.
Posted 13 July 2006 - 12:00 AM
Posted 14 July 2006 - 11:05 AM
I have only done a quick simple test as a one user against SQL 2005 Express.
I did not get any issues but as you all now the moment you include more than one user things start to happen.
So always useful to know if anyone has been there first
Posted 18 October 2007 - 12:59 PM
This is done using a pro-iv non-paging screen, with one file in change mode, and no full-function sql - ie a plain pro-iv function.
Session 1 reads a record in change mode
Session 2 tries to read the same record, and gets a record lock, waiting for file
Session 1 accepts the changes by entering through the screen, and gets a deadlock rollback.
Session 2 then gets the record, and can carry on and save it's changes.
Very strange, if we get a resolution to this, I will post it here.
Posted 20 June 2008 - 07:20 AM
Had 5.5r543 running on a client site on Express
Our one dev server runs 55r543 with SQL2005 Enterprise
So yes it does work and in theory you shouldn't have any issues as long as you use the correct ODBC driver....
Reading Mike's post above, we did get around this by setting an environment variable. Can't remember what it was off hand...
Edited by Neil Hunter, 20 June 2008 - 07:22 AM.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users