> I have the ODBC connector working with a SQL Server database in my > development environment.
We havent noticed any CFMX ODBC Connection problems in our development box either.. this box has no Load.. just 3 developers on this box. Our tests on development box..didnt have any problems.. thats why we took CFMX to Production with this configuration. However.. as soon as we got some load on CFMX in production... CFMX ODBC Connections started dropping... Stop and Re-start CFMX ODBC Services and everything starts working for an hour under load and then starts dropping connections again. > I think that the key here is running CFMX as a named user. I couldn't > get it to work when it ran as system. I am not sure, if this had any relevance. Joe Eugene > -----Original Message----- > From: Jeff Garza [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 04, 2003 10:47 PM > To: CF-Talk > Subject: RE: ODBC Problems? > > > I have the ODBC connector working with a SQL Server database in my > development environment. It's the only way we have right now to connect > to our SQL Servers as our DBA is loath to enable SQL Server > Authentication. We run our CFMX service as a named domain account that > has rights to the database. It works fine, albeit, there is very little > load on this server and due to the config of the server, we do not load > test on it. > > Specs are CFMX Updater 2, IIS 5.0, Win2k Server (Standard), SQL Server > 2000 with SP 2 applied. > > I think that the key here is running CFMX as a named user. I couldn't > get it to work when it ran as system. > > HTH, > > Jeff Garza > > -----Original Message----- > From: Matt Robertson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 04, 2003 8:23 PM > To: CF-Talk > Subject: Re: ODBC Problems? > > > To get back onto the original topic: Has anyone found the ODBC socket > connection to work? Using what db/version? We've heard from people who > didn't, both in this thread and previously. Who can share with us an > experience of a stable connection? Maybe if we approach this from a > different end we'll hear some good news. > > ------------------------------------------- > Matt Robertson, [EMAIL PROTECTED] > MSB Designs, Inc. http://mysecretbase.com > ------------------------------------------- > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
