This is usally the result of not closing your database connection or storing it in Session or Application variable. If you store in Session or Application variable don't, this puts more strain on the server and locks the database. It better to create and destory as you go.
--- In [email protected], Charles Carroll <[EMAIL PROTECTED]> wrote: > well a couple of pieces of advice assuming this is not resolved. > > #1 > what connection string are you using? > If you are using the DBQ connection string or a DSN (which uses ODBC a > bad thing) switch to the OLEDB connection string. > > #2 > You should download the exact database and try it locally while > stressing out the database with a WAST request. Keep in mind that > because of the STA problem and 65 simultaneous connections problem the > busy pages (look at logs) displaying data need to be using GetRows and > getString to reduce strain on CPU. > > #3 > longer Connection.CommandTimeOut and server.ScriptTimeout most likley > need to be used with those pages along with code that emails you when > the pages do not suceed so you have a log of how often it is happening > in your Inbox and know when it is definitely fixed. > > #4 > What indexes are on table if any? > > On Wed, 05 Jan 2005 15:21:05 -0000, gog93rpf <[EMAIL PROTECTED]> wrote: > > > > > > Hi all, > > > > I am having problems with some ms access mdb queries that used to work > > fine up to about two weeks ago. All they now do is lock the database > > (produce an ldb file) or say there are key violations. Nothing has > > changed to the asp pages or the database so I am scratching my head > > (amongst other things) to work out what the problem is - any help much > > appreciated to restore sanity! I even get the same errors when I try > > the sql statements below on a local copy of the database (its about > > 50mb) on my local machine. > > > > sql1 > > ----- > > INSERT INTO students (StudentID, School_id, EntryDate, Postcode, > > NoStudents, nickname, age, sexmale, sexfemale, schoolyear, Distance1k, > > Distance2k, Distance3k, Distance5k, Distance6k, Youcycle, TrainPass, > > FamilyNocar, FamilyOneCar, FamilyTwoCar, approved ) Values ('ta0837gte > > sldkf',76,#1/5/2005#,'sldkf',4,'test',10,4,0,'7',0,0,0,0,4,4,0,0,4,0,True) > > ; > > > > sql2 > > ------ > > INSERT INTO surveydata (StudentId, Schooldetails, EntryDate, > > Direction, NoWalk, NoCycle, NoScBus, NoOtherBus, NoTrain, NoCar, > > NoOther, PrefWalk, PrefCycle, PrefScBus, PrefOtherBus, PrefTrain, > > PrefCar, PrefOther, CountOwn, CountAccompany, CountAdults, > > CountFriends, CountMixed, approved) Values ('ta0837gte > > sldkf',76,#1/5/2005#,'to',4,0,0,0,0,0,0,0,0,4,0,0,0,0,0,4,0,0,4,TRUE) ; > > > > tbl structure > > -------------------- > > Download in Word format here - > > http://www.youngtransnet.org.uk/dbstructure.doc > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
