Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-07 : 11:31:04
|
| kaustubh writes "i am facing a problem with multiple submissions. From end is ASP and database is SQL server. When i test the application on production system it works fine. But when it goes on the web and say 500 odd ppl accessing simultenously it starts submitting multiple records. This behaviour in random .. i mean it doesent happend with all the records.I change the cursor type to adUseClient still the same error persists... Then i submitted the Insert query directly to connection object without using a recordset .. still the problem persists .. any clues abt this Thanks" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-07 : 11:39:12
|
| Try using the profiler to log what is happenning.I doubt if it is a sql server problem - more likely the client code.Are you sure it is doing two inserts? Not some dodgy code getting the next ID or something.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Multilple submission of records