Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-05 Thread Teddy R. Payne
Does the user that you bind for the datasource have access to create table? Client storage creates two database tables: CDATA, CGLOBAL Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Tue, May 5, 2009 at 11:15 AM, Ajas Mohammed wrote: > Hi, > > I have a datasource defined lets s

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-05 Thread Ajas Mohammed
Hi, I believe so because same sql server account/user is used to for all DSN we have i.e. about 10-15 dsn's and we never had this problem with any of the dsn's. So its really weird. We have two appl's lets say MainApp and SubApp where MainApp is /MainApp and subApp is /MainApp/SubApp. Both have t

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-05 Thread Teddy R. Payne
Can you confirm that the client store tables exist in the CF DSN that you are referencing in your application file? Does XYZ have CDATA and CGLOBAL in it? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Tue, May 5, 2009 at 1:11 PM, Ajas Mohammed wrote: > Hi, > > I believe so be

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-05 Thread Ajas Mohammed
Yes, XYZ has CDATA and CGLOBAL in it. Let me know if you need more information. I am stumped. Thanks for the reply. http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don'

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-05 Thread Teddy R. Payne
The user with the issue, do they have cookies enabled? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Tue, May 5, 2009 at 1:47 PM, Ajas Mohammed wrote: > Yes, XYZ has CDATA and CGLOBAL in it. > > Let me know if you need more information. I am stumped. > > Thanks for the reply. >

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-05 Thread Ajas Mohammed
Hmm... Good question. Yes. I tried on my system and I have cookies enabled. http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; i

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-05 Thread Teddy R. Payne
What does "Yes" mean in this context? Does "Yes" mean that you are getting the same error as the the user who is complaining or are just saying "yes" that you have cookies turned on? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Tue, May 5, 2009 at 2:02 PM, Ajas Mohammed wrote

RE: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-05 Thread axunderwood
Ajas Mohammed Sent: Tuesday, May 05, 2009 1:47 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ". Yes, XYZ has CDATA and CGLOBAL in it. Let me know if you need more information. I am stumped. Thank

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-05 Thread Ajas Mohammed
My CFID and CFToken are CFID=33070 CFTOKEN=78703161 Is the size i.e. db size an issue? Perhaps value is getting too large? Just throwing ideas. :-) http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do.

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-05 Thread Ajas Mohammed
Sorry. I meant that YES cookies are enabled on my system. And Yes, I am able to see the error message also. Its just happening for 1 or 2 users. Some users or shall I say user, sees it and some dont. It just happens that I can see the error on my PC and I have cookies enabled. Does that make sense

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-05 Thread Ajas Mohammed
Ok, here is another question for same issue. Lets say in Application.cfm, I had and then I changed it to i.e sessionmanagement to NO. Does this need a ColdFusion restart or changes take place automatically whenever a page is accessed inside that application i.e. pages inside the Same folder as

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-05 Thread Teddy R. Payne
Ajas, You do not need to restart the ColdFusion server if you change the application framework for your application. Try making changes to your application framework by changing the name of the tag. Also, you may want to define the timeouts on your application as in applicationtimeout and session

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-05 Thread Ajas Mohammed
Thanks, Yes, we are on CF 7 and I would prefer Application.cfc but its not in my hands. ;-) About excluding subfolder, yeah i do that depending on the needs. So back to my old problem of 500 Operation failed on the data source named "XYZ". http://ajashadi.blogspot.com We cannot become what we

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-06 Thread Cameron Childress
This is at the bottom of every single page? Client vars are written to the db at that end of each requrest so it sounds like a problem with that. I would look at the DB server more closely. Are you out of disk space? Transaction logs for that DB full? Write permissions changed for DSN user acc

RE: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-06 Thread axunderwood
: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Ajas Mohammed Sent: Wednesday, May 06, 2009 9:31 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ". Good morning all, Allen we ran

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-06 Thread Ajas Mohammed
Hi, Here is a weird thing I noticed and maybe that will help to solve this problem. If you look at snapshot, there is cfid, cftoken and JSessionID. We dont use JSessionID ever. So, I checked the session management in cfapplication tag and it was initially set to yes. I have set it to NO now. But Y

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-06 Thread Cameron Childress
I would be curious to see if you'd looked at the DB. I've actually seen this exact error caused by a full transaction log on the clientvar datastore. Granted it was SQL Server and not Oracle, but worth looking at. -Cameron On Wed, May 6, 2009 at 10:02 AM, Cameron Childress wrote: > This is at

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-06 Thread Ajas Mohammed
Hi Cameron, I checked the transaction Log setting under database properties for the db under question and it has 75 mb space allocated for *.ldf file and its allowed to grow automatically by 10%. The empty disk space is about 51 gb on this drive. Our DB team is gonna look at indexes for CData and

RE: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-06 Thread Charlie Arehart
the CF folks have a hard time getting at that. /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Ajas Mohammed Sent: Wednesday, May 06, 2009 2:28 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the da

Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".

2009-05-06 Thread Ajas Mohammed
Behalf Of *Ajas > Mohammed > *Sent:* Wednesday, May 06, 2009 2:28 PM > *To:* discussion@acfug.org > *Subject:* Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 > Operation failed on the data source named "XYZ". > > > > Hi Cameron, > > I checked the tra

getting remote assistance (was RE: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".)

2009-05-06 Thread Charlie Arehart
e spent is more valuable than a little money in getting some paid assistance. /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Ajas Mohammed Sent: Wednesday, May 06, 2009 10:48 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Opera

Re: getting remote assistance (was RE: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".)

2009-05-06 Thread Ajas Mohammed
you can decide when that time spent is more valuable than a little > money in getting some paid assistance. > > > > /charlie > > > > *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Ajas > Mohammed > *Sent:* Wednesday, May 06, 2009 10:48 AM > *To:* discu

RE: getting remote assistance (was RE: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".)

2009-05-06 Thread Charlie Arehart
to:ad...@acfug.org] On Behalf Of Ajas Mohammed Sent: Wednesday, May 06, 2009 12:38 PM To: discussion@acfug.org Subject: Re: getting remote assistance (was RE: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ".) Charlie, I agree with wha