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, 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, what is the message you get in your 
browser.

All but two of my website apps use Access with Unicode that I set up using
the datasources interface in CF Admin.

The websites that have maintain connections hang and timeout. Ones that
don't have the maintain connections selected come right up.

Sorry about repeating some information, I just want to make sure I am being
clear.

David Moore
UpstateWeb, LLC 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340246
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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 component that raises this event is not installed on your 
local computer or the installation is corrupted. You can install or repair the 
component on the local computer.

If the event originated on another computer, the display information had to be 
saved with the event.

The following information was included with the event: 

ColdFusion 8 ODBC ser...@localhost,ErrorCode=2310,ErrorMessage=TCP/IP, 
connection reset by peer

I am running CF 8.01 on Windows Server 2008 using IIS 7.

Merry Christmas 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340213
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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 component
 that raises this event is not installed on your local computer or the 
 installation is corrupted. You can install or
 repair the component on the local computer.

 If the event originated on another computer, the display information had to 
 be saved with the event.

 The following information was included with the event:

 ColdFusion 8 ODBC ser...@localhost,ErrorCode=2310,ErrorMessage=TCP/IP, 
 connection reset by peer

 I am running CF 8.01 on Windows Server 2008 using IIS 7.

What databases are you using? If you're not using ODBC datasources,
you can simply disable the ODBC services installed by CF. In any case,
it's not clear that this is actually the cause of (or even related to)
your problem.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340214
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340215
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340216
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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 situation would I use the ODBC Services?

Thanks for your help!




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340217
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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 support ODBC but don't also have JDBC drivers. CF uses
JDBC to connect to SQL Server, Oracle, etc.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340218
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CF 8.01 Services freezing up

2010-12-22 Thread Russ Michaels

The ODBC service is really only used by people with MSACCESS DSN's, it you
don't have any of these, and are not using the ODBC bridge, then your not
using the ODBC service.

Russ

-Original Message-
From: David Moore [mailto:dgmoor...@hotmail.com] 
Sent: 22 December 2010 21:31
To: 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 what is the ODBC Services for if not to manage database connections? In 
what situation would I use the ODBC Services?

Thanks for your help!






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340219
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340220
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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 all websites and turning off 
ODBC Server?

David Moore
UpstateWeb, LLC 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340221
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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 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 all websites and turning off

ODBC Server?

David Moore
UpstateWeb, LLC 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340222
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340223
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340224
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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 sources? Maybe it would be
a good idea to list explicitly what database drivers you're using for
each data source.

 So, do you recommend removing the selection for all websites and turning off
 ODBC Server?

I would generally not recommend unchecking that option in production,
as it'll make things slower and less efficient. But if shutting it off
keeps your server from crashing, go ahead and shut it off.

I'd recommend turning off the two ODBC services if you're not using
them. But make sure you're not using them.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340226
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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 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 sources? Maybe it would be
 a good idea to list explicitly what database drivers you're using for
 each data source.

 So, do you recommend removing the selection for all websites and turning off
 ODBC Server?
 I would generally not recommend unchecking that option in production,
 as it'll make things slower and less efficient. But if shutting it off
 keeps your server from crashing, go ahead and shut it off.

 I'd recommend turning off the two ODBC services if you're not using
 them. But make sure you're not using them.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 http://training.figleaf.com/

 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340228
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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
shows up in there.

Even when you're using ODBC, though, you're still using JDBC, as
that's all that CF knows (being a Java application). Java applications
only use JDBC. The ODBC Server and ODBC Agent services act as a
JDBC-to-ODBC bridge. So, my guess would be that you'll see all your
data sources as having JDBC URLs no matter what, but that the ones
that use the ODBC services will mention sequelink or something along
those lines.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340229
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CF 8.01 Services freezing up

2010-12-22 Thread Mark A. Kruger

No... when you are using odbc you are still using a JDBC Bridge driver. In
the case of CF it's from sequelink and you can see it running in the task
list as swsoc.exe it's what get's fired off with the Coldfusion ODBC
Service.

Whats really happening under the hood is that a JDBC driver is connecting to
a socket provided by sequelink's service and issue JDBC commands. Sequelink
translates these commands or calls into ODBC Calls and connects to the
datasource the Access file using ODBC. It get's the results and translates
them back into JDBC and sends them up the chain to the JDBC bridge
driver So even though you are ODBC'ing the datasource you are still
using JDBC and bridging to it. 

This is one of the reasons why Access became a much worse idea as soon as CF
moved to Java. Instead of using the ODBC subsystem directly it now requires
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
Subject: Re: CF 8.01 Services freezing up


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 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 sources? Maybe it would be
 a good idea to list explicitly what database drivers you're using for
 each data source.

 So, do you recommend removing the selection for all websites and turning
off
 ODBC Server?
 I would generally not recommend unchecking that option in production,
 as it'll make things slower and less efficient. But if shutting it off
 keeps your server from crashing, go ahead and shut it off.

 I'd recommend turning off the two ODBC services if you're not using
 them. But make sure you're not using them.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 http://training.figleaf.com/

 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340230
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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:Provider=Microsoft.Jet.OLEDB.4.0;Data 
Source=E:\\Inetpub\\wwwroot\\domain\\mydatabases\\database.mdb;Izm 
JdbcEsc=yes;IzmReleaseOnClose= no

I'm not in front of a machine running CF, so I'm not sure exactly what
shows up in there.

Even when you're using ODBC, though, you're still using JDBC, as
that's all that CF knows (being a Java application). Java applications
only use JDBC. The ODBC Server and ODBC Agent services act as a
JDBC-to-ODBC bridge. So, my guess would be that you'll see all your
data sources as having JDBC URLs no matter what, but that the ones
that use the ODBC services will mention sequelink or something along
those lines.

Does this help Dan? I am pretty sure I am using ODBC. I set up all my 
Datasources using the drop down list in CF Admin.

I am guessing I should do this another way? I have just never figured out 
how to do it.

David Moore
UpstateWeb, LLC 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340231
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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-to-JET driver. It doesn't rely on the ODBC
services.


 Does this help Dan? I am pretty sure I am using ODBC. I set up all my
 Datasources using the drop down list in CF Admin.

You're using ODBC if:
- you chose the Microsoft Access driver (not the MS Access with
Unicode driver), or
- you chose ODBC Socket.

 I am guessing I should do this another way? I have just never figured out
 how to do it.

No, that's how you're supposed to create data sources.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340232
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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 working.

Any suggestions from this, other than the obvious as Mark Kruger has told me 
many times stop using Access.

David Moore
UpstateWeb, LLC 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340233
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CF 8.01 Services freezing up

2010-12-22 Thread Russ Michaels

David,

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, 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. 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 working.

Any suggestions from this, other than the obvious as Mark Kruger has told me

many times stop using Access.

David Moore
UpstateWeb, LLC 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340234
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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, what is the message you get in your
browser.

All but two of my website apps use Access with Unicode that I set up using 
the datasources interface in CF Admin.

The websites that have maintain connections hang and timeout. Ones that 
don't have the maintain connections selected come right up.

Sorry about repeating some information, I just want to make sure I am being 
clear.

David Moore
UpstateWeb, LLC 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340235
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


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 the ODBC services, restart CF and see what happens.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340236
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm