Ah.. I see. Yes I was getting an error when connecting to the DB via the CFMX JDBC...
So I just pointed it to the Windows DSN. I could tone down the amount of memory it's using but still it shouldn't be using 900mb in the first place. ----- Original Message ----- From: "Ryan Kime" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 12:30 PM Subject: RE: cfmx jrun.exe hitting 900mb ram > CFMX's DSN connections use JDBC instead of ODBC. That's why you don't see it > in the ODBC Manager. You can use an ODBC Socket (in cf admin) to connect to > an ODBC that is set up in the Manager. Otherwise you can use the JDBC SQL > Server driver provided in the cf admin. > > Also, you can modify the amount of memory CFMX (jrun.exe) can use by > changing the memory parameters under "Java and JVM" in the cf admin. Not > sure if that will solve your problem, but you can try it. > > Ryan > > > -----Original Message----- > From: JLH All Turbo [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 15, 2002 10:48 AM > To: CF-Talk > Subject: Re: cfmx jrun.exe hitting 900mb ram > > > 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.. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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