Okay, well i added the dsn to ms odbc manager and then had to add it to cfmx's admin via the dsn manager.. and added it as a odbc connection?
i'm not sure how i added it.. i remember it not working with the sql server driver, it kept erroring out... so i had to use like the external odbc.. and pointed it to the windows dsn name... how does cfmx's new dsn stuff work? it's not like 5.0 and i was really confused... add a dsn to cfmx.. and it doesn't show up in windows odbc manager... and vice versa... this is probably where it's broken... how do i correctly add a sql server dsn.. ----- Original Message ----- From: "Carlisle, Eric" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 11:27 AM Subject: RE: cfmx jrun.exe hitting 900mb ram > I'd check out the usual suspects for memory leaks, such as database drivers > and proper use of cflock. > > What driver version are you using for SQL Server? MS Jet drivers for Access > and SQL Server is pretty ruthless for leaking memory. I'm not certain if > this changes with CFMX -- are we using ODBC, JDBC? *scratches head* > > Make certain you're using <cflock> for shared scopes (server, session, > application). Otherwise, that could cause some memory corruption as well. > > > -----Original Message----- > From: JLH All Turbo [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 15, 2002 11:09 AM > To: CF-Talk > Subject: cfmx jrun.exe hitting 900mb ram > > > we're having a problem with jrun.exe hitting 900+mb of ram whenever we > launch our site to the public... > > on the server with 3-4 testers hitting it, it's fine.... > > then we launch and get 1000+ users and it's taking all the ram it can... sql > server stays put at 165mb ram... yet jrun.exe skyrockets.. > > we're using win2k and sql server 2k... any idea what makes jrun go nuts like > that? anything we can look for? > > > thank you > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
