Oracle connection refused error with CFSCHEDULE task only

2004-09-24 Thread Samuel Neff
We're getting an Oracle error when we run a page through CFSCHEDULE but not when we browse to the page.  The page does a full-text index on the database by querying all the data, writing out text files for each record, and then indexing the text files.  (we found that writing text files and indexin

Re: Oracle connection refused error with CFSCHEDULE task only

2004-09-24 Thread Adrocknaphobia
Do you have any limitations on the number of sessions the Oracle account you are using is allowed? -Adam - Original Message - From: Samuel Neff <[EMAIL PROTECTED]> Date: Fri, 24 Sep 2004 09:39:54 -0400 Subject: Oracle connection refused error with CFSCHEDULE task only To: CF-Talk &

RE: Oracle connection refused error with CFSCHEDULE task only

2004-09-24 Thread Samuel Neff
nt: Friday, September 24, 2004 10:56 AM To: CF-Talk Subject: Re: Oracle connection refused error with CFSCHEDULE task only Do you have any limitations on the number of sessions the Oracle account you are using is allowed? -Adam - Original Message - From: Samuel Neff <[EMAIL PROTECTED]> D

Re: Oracle connection refused error with CFSCHEDULE task only

2004-09-24 Thread Ian Skinner
One of the first things I always check with CFSHEDULE problems is does the user account that the Cold Fusion service run as, usually system if not modified, have permission to all the resources necessary to do its task.  In your case I would check the file security on the directories to which you a

RE: Oracle connection refused error with CFSCHEDULE task only

2004-09-24 Thread Samuel Neff
scribe still be the problem? Thanks, Sam -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 11:13 AM To: CF-Talk Subject: Re: Oracle connection refused error with CFSCHEDULE task only One of the first things I always check with CFSHEDULE probl

RE: Oracle connection refused error with CFSCHEDULE task only

2004-09-24 Thread Dave Watts
> We're not using any type of HTTP-level authentication and > users browsing the site don't have any accounts or anythign > on the server.  It's all default setup for CF server users.   > > And besides that, the error is on the query, before we ever > get to the file write. > > Could what you

Re: Oracle connection refused error with CFSCHEDULE task only

2004-09-24 Thread Adrocknaphobia
drivers are you using? -Adam - Original Message - From: Samuel Neff <[EMAIL PROTECTED]> Date: Fri, 24 Sep 2004 11:12:22 -0400 Subject: RE: Oracle connection refused error with CFSCHEDULE task only To: CF-Talk <[EMAIL PROTECTED]> We're not using any type of HTTP-level authe

RE: Oracle connection refused error with CFSCHEDULE task only

2004-09-24 Thread Ian Skinner
We're not using any type of HTTP-level authentication and users browsing the site don't have any accounts or anything on the server.  It's all default setup for CF server users.   And besides that, the error is on the query, before we ever get to the file write. Could what you describe still be t

RE: Oracle connection refused error with CFSCHEDULE task only

2004-09-24 Thread Dave Watts
> It could be, even if the users do not log in, they have a > default user account, ISSR_USER or something like that on > Windows systems, and even this default basic user often has > more permissions then the default system user that the CF > service runs under. There are two problems with th