will try... thanks ryan. On 5/5/05, Ryan Sabir <[EMAIL PROTECTED]> wrote: > > I was getting the JRUN Connection Error fairly regularly.. until I > switched to using the Microsoft JDBC drivers instead of the supplied > MM ones. > > Get the driver from here (watch wrapping): > http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en > > And here's how to install it: > http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18652 > > bye! > > Thursday, May 5, 2005, 10:19:52 AM, you wrote: > > SB> Well, the driver failed in terms of JRUN. (ie JRUN Connection Error) > > SB> One thing of note: > > SB> "...We have a DSN setup to a standard SQL DB... If we check "Maintain > SB> Connection" via DSN/ADVANCED the SQL CPU goes to 100%.. yet if we > SB> uncheck it, SQL goes to a stable 0-10% cpu but JRUN climbs to 50% CPU? > SB> any ideas? > > SB> At first we thought it was a rogue query but the queries aren't > SB> consistent in that its not isolated to a specific query.." > > > SB> On 5/4/05, Tim McAuliffe <[EMAIL PROTECTED]> wrote: > >> Hi Scott, > >> > >> Yep, this is a bug. I had the same problem a while back in a gig at > >> Australand. Looks like you've found the right KB article too. We used the > >> updated drivers as instructed and it fixed the problem. > >> > >> HTH > >> > >> Tim > >> > >> > We are having some issues here at work with our CFMX 6.1 --> SQL > >> > connections, in that it seems to constantly spike in terms of CPU (RAM > >> > itself doesn't seem to move as much). > >> > > >> > At first we thought it was a rogue query, but closer inspection there > >> > is no consistent pattern (ie we scoped out Enterpise Manager and took > >> > a snapshot of what queries are being fired off). > >> > > >> > It's as if Coldfusion MX requests a query to be initiated to SQL > >> > Server, SQL Server proceeds to carry out that instruction but can't > >> > hand it back to Coldfusion server, and simply places itself in a > >> > holding pattern until coldfusion can accept it.. ie loss of connection > >> > or something along those lines. > >> > > >> > It strongly hints at: > >> > http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=3Dtn_18807 > >> > > >> > Now the thing that has changed since we last looked at it, was that we > >> > dropped a NT DOMAIN from our network? can anyone explain or know of > >> > what causes the > >> > > >> > 52851 - 100% CPU utilization when SQL server unexpectedly closes a > >> > connecti= > >> > on. > >> > > >> > Bug? > >> > > >> > > >> > --=20 > >> > Regards, > >> > Scott Barnes > >> > http://www.mossyblog.com > >> > http://www.flexcoder.com (Coming Soon) > >> > >> --- > >> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > >> To unsubscribe send a blank email to [EMAIL PROTECTED] > >> Aussie Macromedia Developers: http://lists.daemon.com.au/ > >> > > ----------------------- > Ryan Sabir > Newgency Pty Ltd > 2a Broughton St > Paddington 2021 > Sydney, Australia > Ph (02) 9331 2133 > Fax (02) 9331 5199 > Mobile: 0411 512 454 > http://www.newgency.com/index.cfm?referer=rysig > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ >
-- Regards, Scott Barnes http://www.mossyblog.com http://www.flexcoder.com (Coming Soon) --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
