You are right, i am using Access as my database and server activities are growing too busy. It is time for me to migrate to MS SQL. Thanks for your advice.
Rgrd Ang ----- Original Message ----- From: "Nathan Strutz" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Thursday, February 23, 2006 2:20 AM Subject: Re: Need help - OBDC Timeout > Well obviously the error on installing the patch really sucks. Do you have > the ODBC services installed for sure? You should see it in your control > panel services app. Did you make sure to stop the server before applying > the > patch? It might help to stop IIS as well. Do you need to use ODBC for your > database? If it's in the drop-down list when you create a new database, > those JDBC drivers are much better than ODBC. > > What kind of database are you using? If it's Access, it sounds like you're > just growing too busy for it and you should really consider upgrading to > something like SQL Server or MySql. If it's something else, perhaps you > can > download another JDBC driver for it and use that instead. > > (the first step to fixing most ODBC problems is to switch to JDBC :) > > -nathan strutz > http://www.dopefly.com/ > > > On 2/21/06, ekcien <[EMAIL PROTECTED]> wrote: >> >> Appreciate everyone help me to solve this problem. >> Recently our server (Window 2003, MX6.1) occur ODCB Timeouts and >> unresponsive requests. I have updated our server with lastest hotfix but >> still get this error. >> >> ----------------------------------------------------------- >> 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. >> You may be able to use the /AUXSOURCE= flag to retrieve this description; >> see Help and Support for details. The following information is part of >> the >> event: ColdFusion MX ODBC >> [EMAIL PROTECTED],ErrorCode=3059,ErrorMessage=The >> specified data source is not defined.,ClientHost=127.0.0.1,Session=21564. >> ---------------------------------------------------------------- >> >> Rgrd >> Ang >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233207 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
