Once again show us the code. I know lots of tweaks to code to avoid timeouts and can tell both of you how to tweak yours.
--- In [EMAIL PROTECTED], Tech Stuff <[EMAIL PROTECTED]> wrote: > Hi all, > > I face the same problem too. The code is a standard connection string to connect to the database - absolutely nothing fancy. The connection timeout is set to 72 seconds. > > My system works mostly works fine - but sometime gives a timeout error when 150,000 records are beign processed. I am using SQL 7.0 > > Any pointers will be most helpful. > > Thanks and regards, > TS > > Charles Mark Carroll <[EMAIL PROTECTED]> wrote: > Show us the code then we can advise you. > > > --- In [EMAIL PROTECTED], "Carney Clegg" > <[EMAIL PROTECTED]> wrote: > > > > I'm having trouble with a SQL Server timeout error. My > application > > is designed to transfer data from a SQL Server 6.5 database to SQL > > Server 2000. My timeout error comes during the transaction that > > places data into the SQL Server database. > > > > I'm using a stored procedure to do the insert, am cleaning out my > > table for each test run, and refreshing memory. I've tried > changing > > the Isolation Level to Read Uncommitted, and changing my > connection > > strategy so that I'm using a single connection instead of a > > connection pool. > > > > My memory is 256 MB, so I'm thinking that maybe I don't have > enough, > > but could there be anything else that I'm missing? > > > > Thanks. > > > Yahoo! Groups SponsorADVERTISEMENT > > > --------------------------------- > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > > --------------------------------- > ALL-NEW Yahoo! Messenger - sooooo many all-new ways to express yourself > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> 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/
