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/
