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,

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

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 si

RE: CF 8.01 Services freezing up

2010-12-22 Thread Russ Michaels
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

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 s

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 JDBC

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 jdbc:izmado:Provid

RE: CF 8.01 Services freezing up

2010-12-22 Thread Mark A. Kruger
equires an intermediate layer to connect. -Mark 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 Subjec

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

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 "Mainta

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 da

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 b

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
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 connec

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 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! htt

RE: CF 8.01 Services freezing up

2010-12-22 Thread Russ Michaels
o: cf-talk 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 w

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 th

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 wha

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 http://www.fi

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! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?t

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