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

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
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 Operation failed on the data source named XYZ. Hi, Here

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
] *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 Operation failed on the data source named XYZ. Hi, Here is a weird thing I noticed and maybe that will help to solve this problem

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
...@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 what you mentioned

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 camer...@gmail.com

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

2009-05-06 Thread Charlie Arehart
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 data source named XYZ. Hi

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

2009-05-06 Thread Ajas Mohammed
, 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 transaction Log setting under database properties for the db under question and it has 75 mb space allocated

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 ajash...@gmail.com wrote: Hi, I have a

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

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 ajash...@gmail.com wrote: Hi,

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. Ajas Mohammed / 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

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. Ajas Mohammed / 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

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

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

2009-05-05 Thread axunderwood
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. Thanks for the reply. Ajas

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. :-) Ajas Mohammed / http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats

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

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 cfapplication name=test sessionmanagement=YES setclientcookies=yes clientmanagement=yes clientstorage=XYZ and then I changed it to cfapplication name=test sessionmanagement=NO setclientcookies=yes

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 cfapplication tag. Also, you may want to define the timeouts on your application as in

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. Ajas Mohammed / http://ajashadi.blogspot.com We cannot