RE: CF 8.01 Services freezing up

2010-12-23 Thread Russ Michaels
That certainly seems odd. Try restarting CF and IIS as well Russ -Original Message- From: David Moore [mailto:dgmoor...@hotmail.com] Sent: 23 December 2010 00:42 To: cf-talk Subject: Re: CF 8.01 Services freezing up Stopping these services should not stop your websites working

CF 8.01 Services freezing up

2010-12-22 Thread David Moore
I have seen where others have posted this question, but no resolution. CF keeps restarting and sometimes will lock up so badly that i have to restart the server? Here is the error message: The description for Event ID 0 from source ColdFusion 8 ODBC Server cannot be found. Either the

Re: CF 8.01 Services freezing up

2010-12-22 Thread Dave Watts
I have seen where others have posted this question, but no resolution. CF keeps restarting and sometimes will lock up so badly that i have to restart the server? Here is the error message: The description for Event ID 0 from source ColdFusion 8 ODBC Server cannot be found. Either the

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
I am using MS Access and assigning the Datasource using CF Administrator as MS Access with Unicode. Does that help? ~| Order the Adobe Coldfusion Anthology now!

Re: CF 8.01 Services freezing up

2010-12-22 Thread Dave Watts
I am using MS Access and assigning the Datasource using CF Administrator as MS Access with Unicode. Does that help? The MS Access with Unicode driver doesn't use ODBC. So, you can disable the ODBC services and see if that fixes your problem. Dave Watts, CTO, Fig Leaf Software

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
The MS Access with Unicode driver doesn't use ODBC. So, you can disable the ODBC services and see if that fixes your problem. I am using 2 websites with SQL Server Express. If I stop this, will it affect those. And what is the ODBC Services for if not to manage database connections? In what

Re: CF 8.01 Services freezing up

2010-12-22 Thread Dave Watts
I am using 2 websites with SQL Server Express. If I stop this, will it affect those. No. And what is the ODBC Services for if not to manage database connections? In what situation would I use the ODBC Services? The ODBC services act as a bridge from your JDBC client (CF) to databases that

RE: CF 8.01 Services freezing up

2010-12-22 Thread Russ Michaels
Subject: Re: CF 8.01 Services freezing up The MS Access with Unicode driver doesn't use ODBC. So, you can disable the ODBC services and see if that fixes your problem. I am using 2 websites with SQL Server Express. If I stop this, will it affect those. And what is the ODBC Services

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
Thank you Dan and Russ. You have been a tremendous help. I have turned the ODBC Service off and will report back if this resolves the issue so others may benefit from this post. ~| Order the Adobe Coldfusion Anthology now!

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
If you have checked Maintain connections across client requests, stopping ColdFusion 8 ODBC Server shuts down the websites? I had some sites stop working while others didn't. After investigating their datasource settings, this is what I found. So, do you recommend removing the selection for

RE: CF 8.01 Services freezing up

2010-12-22 Thread Russ Michaels
They must have been ODBC data sources then, a JDBC Data source uses JDBC and not ODBC. Russ -Original Message- From: David Moore [mailto:dgmoor...@hotmail.com] Sent: 22 December 2010 22:22 To: cf-talk Subject: Re: CF 8.01 Services freezing up If you have checked Maintain connections

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
They must have been ODBC data sources then, a JDBC Data source uses JDBC and not ODBC. I guess then, what you are telling me, is I should be using a JDBC Data source. Any place to get directions on how to do this? David ~|

RE: CF 8.01 Services freezing up

2010-12-22 Thread Russ Michaels
As has been mentioned already the MSACCESS with Unicode DSN does not use JDBC, so you can use that instead for your Access DSN's Russ From: David Moore [mailto:dgmoor...@hotmail.com] Sent: 22 December 2010 22:56 To: cf-talk Subject: Re: CF 8.01 Services freezing up They must have been ODBC

Re: CF 8.01 Services freezing up

2010-12-22 Thread Dave Watts
If you have checked Maintain connections across client requests, stopping ColdFusion 8 ODBC Server shuts down the websites? I had some sites stop working while others didn't. After investigating their datasource settings, this is what I found. Are you sure you're not using any ODBC data

Re: CF 8.01 Services freezing up

2010-12-22 Thread rex
In CFAdmin, if I go into SERVER SETTINGS Settings Summary, in the Database Data Sources section, it lists all my data sources. So, if I see everything using a JDBC URL, does that mean that I don't use ODBC data sources? On 12/22/2010 3:51 PM, Dave Watts wrote: If you have checked Maintain

Re: CF 8.01 Services freezing up

2010-12-22 Thread Dave Watts
In CFAdmin, if I go into SERVER SETTINGS Settings Summary, in the Database Data Sources section, it lists all my data sources.  So, if I see everything using a JDBC URL, does that mean that I don't use ODBC data sources? I'm not in front of a machine running CF, so I'm not sure exactly what

RE: CF 8.01 Services freezing up

2010-12-22 Thread Mark A. Kruger
Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: rex [mailto:li...@pgrworld.com] Sent: Wednesday, December 22, 2010 6:11 PM To: cf-talk Subject: Re: CF 8.01 Services freezing up

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
In CFAdmin, if I go into SERVER SETTINGS Settings Summary, in the Database Data Sources section, it lists all my data sources. So, if I see everything using a JDBC URL, does that mean that I don't use ODBC data sources? All of mine look like the following: JDBC URL

Re: CF 8.01 Services freezing up

2010-12-22 Thread Dave Watts
All of mine look like the following: JDBC URL  jdbc:izmado:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\Inetpub\\wwwroot\\domain\\mydatabases\\database.mdb;Izm JdbcEsc=yes;IzmReleaseOnClose= no Those are using the Access with Unicode driver, which isn't an ODBC driver. It's a

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
Those are using the Access with Unicode driver, which isn't an ODBC driver. It's a JDBC-to-JET driver. It doesn't rely on the ODBC services. Then that is what I am doing, but as I stated earlier, if I have the Maintain connections checked and stop Coldfusion 8 ODBC Server, the websites stop

RE: CF 8.01 Services freezing up

2010-12-22 Thread Russ Michaels
to the site, what is the message you get in your browser. Russ -Original Message- From: David Moore [mailto:dgmoor...@hotmail.com] Sent: 23 December 2010 00:34 To: cf-talk Subject: Re: CF 8.01 Services freezing up Those are using the Access with Unicode driver, which isn't an ODBC driver

Re: CF 8.01 Services freezing up

2010-12-22 Thread David Moore
Stopping these services should not stop your websites working, at worst it would result in database errors on those sites saying they were unable to connect to the database, but if the website completely stops working then there is some other issue at work here. What EXACTLY happens to the site,

Re: CF 8.01 Services freezing up

2010-12-22 Thread Dave Watts
Then that is what I am doing, but as I stated earlier, if I have the Maintain connections checked and stop Coldfusion 8 ODBC Server, the websites stop working. Any suggestions from this, other than the obvious as Mark Kruger has told me many times stop using Access. I suggest that you stop