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/
