I recently wrote a system for a client, running under the single well (asa9 database), single user proposed recently, need to put the system into a network system, many users use the
So I just changed to SQL server 2000 database, server environment is Windows server 2003 + SQL server 2000, connect to the database parameter is:
The SQLCA. DBMS="OLE DB"
The SQLCA. LogPass='660808'
The SQLCA. LogId="sa"
The SQLCA. The AutoCommit=false
='SQLOLEDB' SQLCA. DBParm="PROVIDER and DATASOURCE='SPPH - E57E4C2855, PROVIDERSTRING=' database=physics'"

The question is: when there are multiple users enter the system, if a user after to do data updates, if saving data, appear crash (mouse into a funnel) phenomenon, if other users to exit the system at this moment, is successfully saved, funnel disappear, then I put the connection parameters SQLCA. The AutoCommit=false to the SQLCA. The AutoCommit=true, problem solved, but this has not solve the problem of concurrent, prawns, please help me, I'm try so hard, thank you

CodePudding user response:

This kind of situation and database lock, and see how it is set!
DW update properties of three kinds of update options, want to choose according to situation!

CodePudding user response:

If the press with several window directly submit upstairs said; If not to change the update statement to use transaction or cursor batch submission,
With pb is essentially a stored procedure submission is also a good way to multi-user mode,