Have you had any betas installed on there? We're running CFMx on Windows and Solaris and so far it's been solid...although I did have a strange problem on a windows box once where I was trying to pass in the user/pass for the database on a query...threw a Null Pointer exception...I took off the user/pass (since it was configured in the admin anyway) and the problem went away...
-----Original Message----- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 1:08 PM To: CF-Talk Subject: RE: CFMX JDBC database issue We have two of our development servers switched over to MX, and so far we are not happy at all. The service crashes and re-starts about 5 times a day. This is with a very light load. We get an error in the Windows Application event log, and that is it. I have been pounding the CF message board at Macromedia, and no macromedia tech has an answer for me yet. The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: ColdFusion MX ODBC Server@LOCALHOST,ErrorCode=2310,ErrorMessage=TCP/IP, connection reset by peer. Access databases seem to be the ones that crash the service the easiest. Just clicking around on one of our sites is enough to crash it. With a MS SQL database we need to use a tool like XENU to spider through the site to crash it. Check your application event log (if your on a Win box) and see if you have the same error. -----Original Message----- From: Nelson Winters [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 11:45 AM To: CF-Talk Subject: CFMX JDBC database issue Has anyone experienced JDBC instability using CFMX? I have an app that runs fine and then, for no apparent reason (no changes to the CF code, stored procedure or to any settings on the server), I start getting database errors and no queries work until I stop and start ColdFusion. Here's the code where I call the login validation stored procedure: <cfstoredproc procedure="Util_ValidateLogin" returncode="No" datasource="#Application.Datasource#" debug="NO" username="sa" password="awa"> <cfprocparam type="In" dbvarname="@Agency" value="#Form.Agency#" cfsqltype="CF_SQL_CHAR" maxlength="4" null="no"> <cfprocparam type="In" dbvarname="@Login" value="#Form.Username#" cfsqltype="CF_SQL_CHAR" maxlength="20" null="no"> <cfprocparam type="In" dbvarname="@Password" value="#Form.Password#" cfsqltype="CF_SQL_CHAR" maxlength="20" null="no"> <cfprocresult name="AuthenticateUser" resultset="1"> </cfstoredproc> I also tried this way with no luck: <cfquery name="AuthenticateUser" datasource="#Application.Datasource#"> {call Util_ValidateLogin('#Form.Agency#', '#Form.Username#', '#Form.Password#')} </cfquery> Here's the error that shows up in my application.log file: "Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]Syntax error at token ,, line 0 offset 26. I'm running CFMX, IIS 5 and SQL 2000 on a Win2000 server. ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
