Re: [ACFUG Discuss]

[Dusty Hale]

You can create an RSS feed using the  tag. I've successfully used
the tag to read and parse other RSS feeds so I can't offer any advice on
creating feeds but it can be done and I believe you can create a feed from a
query as the example from livedocs shows:

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_f_01.html

Dusty



On Tue, May 5, 2009 at 7:20 PM, techsupport  wrote:

> I'm looking for help getting pointed in the right direction for a good
> place that details how to create RSS files to transfer data from my website
> over to Twitter, Facebook, etc.
>
> Any ideas?
>
> Kristine Macauley
> 678-852-6175
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by http://www.fusionlink.com
> -
>
>
>
>


-- 
Dusty Hale
Email: du...@dustyhale.com
Phone (Atlanta): 404.474.3754
Phone (Toll Free USA): 877.841.3370
Website: www.DustyHale.com

Re: [ACFUG Discuss]

[John Mason]

That's a fairly large and growing topic but a good place ot start is the 
cffeed tag.


John
ma...@fusionlink.com




techsupport wrote:

I'm looking for help getting pointed in the right direction for a good place 
that details how to create RSS files to transfer data from my website over to 
Twitter, Facebook, etc.

Any ideas?

Kristine Macauley
678-852-6175 



-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform


For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-




  




-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform


For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

[ACFUG Discuss]

[techsupport]

I'm looking for help getting pointed in the right direction for a good place 
that details how to create RSS files to transfer data from my website over to 
Twitter, Facebook, etc.

Any ideas?

Kristine Macauley
678-852-6175 


-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

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

[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 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; it is always the result of high intention,
sincere effort, intelligent direction and skillful execution; it represents
the wise choice of many alternatives.


On Tue, May 5, 2009 at 3:43 PM, Teddy R. Payne wrote:

> 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 sessiontimeout:
>
>
> http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=0217.htm
>
> As you are using CF7, are there any constraints to using Application.cfc?
> You might find the organization of the methods easier to deliniate your
> goals of various application environments.
>
> In development, I typically have a way to refresh my application framework
> through a URL variable that would either refresh my cached object factories
> or just to refresh a given set of instructions.  Please allow me to stress
> "development only".
>
> Also, the nature of Application.cfm and Application.cfc is that a CFM or
> CFC will search up their directory paths to find an application framework.
> So, your Application.cfm affects the files in the same directory and
> subdirectories of your Application.cfm.
>
> If you ever want to exclude a subfolder inside a given Application.cfm
> structure, place a new Application.cfm in a subdirectory with either a new
> name on a  tag or just leave the document blank.
>
>
> Teddy R. Payne, ACCFD
> Google Talk - teddyrpa...@gmail.com
>
>
>
> On Tue, May 5, 2009 at 2:46 PM, Ajas Mohammed  wrote:
>
>> Ok, here is another question for same issue. Lets say in Application.cfm,
>> I had
>>
>> > clientmanagement="yes" clientstorage="XYZ">
>>
>> and then I changed it to
>> > clientmanagement="yes" clientstorage="XYZ"> 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 the Application.cfm file ?
>>
>>
>> Thanks,
>>
>>
>> 
>> 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; it is always the result of high intention,
>> sincere effort, intelligent direction and skillful execution; it represents
>> the wise choice of many alternatives.
>>
>>
>> On Tue, May 5, 2009 at 2:10 PM, Ajas Mohammed  wrote:
>>
>>> 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? If not let me know.
>>>
>>> Thanks again,
>>>
>>> 
>>> 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; it is always the result of high intention,
>>> sincere effort, intelligent direction and skillful execution; it represents
>>> the wise choice of many alternatives.
>>>
>>>
>>> On Tue, May 5, 2009 at 2:05 PM, Teddy R. Payne wrote:
>>>
 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:

> 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; it is always the result of high
> intention, sincere effort, intelligent direction and skillful execution; 
> it
> represents the wise choice of many alternatives.
>
>
> On Tue, May 5, 2009 at 1:58 PM, Teddy R. Payne 
> wrote:
>
>> The user with the issue, do they have 

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

[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 sessiontimeout:

http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=0217.htm

As you are using CF7, are there any constraints to using Application.cfc?
You might find the organization of the methods easier to deliniate your
goals of various application environments.

In development, I typically have a way to refresh my application framework
through a URL variable that would either refresh my cached object factories
or just to refresh a given set of instructions.  Please allow me to stress
"development only".

Also, the nature of Application.cfm and Application.cfc is that a CFM or CFC
will search up their directory paths to find an application framework.  So,
your Application.cfm affects the files in the same directory and
subdirectories of your Application.cfm.

If you ever want to exclude a subfolder inside a given Application.cfm
structure, place a new Application.cfm in a subdirectory with either a new
name on a  tag or just leave the document blank.


Teddy R. Payne, ACCFD
Google Talk - teddyrpa...@gmail.com



On Tue, May 5, 2009 at 2:46 PM, Ajas Mohammed  wrote:

> Ok, here is another question for same issue. Lets say in Application.cfm, I
> had
>
>  clientmanagement="yes" clientstorage="XYZ">
>
> and then I changed it to
>  clientmanagement="yes" clientstorage="XYZ"> 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 the Application.cfm file ?
>
>
> Thanks,
>
>
> 
> 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; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives.
>
>
> On Tue, May 5, 2009 at 2:10 PM, Ajas Mohammed  wrote:
>
>> 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? If not let me know.
>>
>> Thanks again,
>>
>> 
>> 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; it is always the result of high intention,
>> sincere effort, intelligent direction and skillful execution; it represents
>> the wise choice of many alternatives.
>>
>>
>> On Tue, May 5, 2009 at 2:05 PM, Teddy R. Payne wrote:
>>
>>> 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:
>>>
 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; it is always the result of high intention,
 sincere effort, intelligent direction and skillful execution; it represents
 the wise choice of many alternatives.


 On Tue, May 5, 2009 at 1:58 PM, Teddy R. Payne 
 wrote:

> 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.
>>
>> 
>> 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; it is always the result of high
>> intention, sincere effort, intelligent direction and skillful execution; 
>> it
>> represents the wise choice of many alternatives.
>>
>>
>> On Tue, May 5, 2009 at 1:42 PM, Ted

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

[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 the Application.cfm file ?


Thanks,



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; it is always the result of high intention,
sincere effort, intelligent direction and skillful execution; it represents
the wise choice of many alternatives.


On Tue, May 5, 2009 at 2:10 PM, Ajas Mohammed  wrote:

> 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? If not let me know.
>
> Thanks again,
>
> 
> 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; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives.
>
>
> On Tue, May 5, 2009 at 2:05 PM, Teddy R. Payne wrote:
>
>> 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:
>>
>>> 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; it is always the result of high intention,
>>> sincere effort, intelligent direction and skillful execution; it represents
>>> the wise choice of many alternatives.
>>>
>>>
>>> On Tue, May 5, 2009 at 1:58 PM, Teddy R. Payne wrote:
>>>
 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.
>
> 
> 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; it is always the result of high
> intention, sincere effort, intelligent direction and skillful execution; 
> it
> represents the wise choice of many alternatives.
>
>
> On Tue, May 5, 2009 at 1:42 PM, Teddy R. Payne 
> wrote:
>
>> 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 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 there own 
>>> Appplication.cfm
>>> file and we have clientmanagement yes and clientstorage pointing to 
>>> same DSN
>>> lets say XYZ like this sessionmanagement="no" setclientcookies="yes"
>>> clientmanagement="yes" clientstorage="XYZ"
>>>
>>> One user was getting this error in MainApp and I was getting the
>>> same error in subApp. Some users were not getting *any* errors at
>>> all.
>>>
>>> I got rid of MainApp error using this code at very end of logout
>>> screen.  .Thats strange because I dont
>>> use StructClear(Client). Someone mentioned that if you used StructClear 
>>> then
>>> use hitcount.
>>>
>>> I am so confused now because client.hitcount thing worked and we
>>> havent used it for any of our sites which work fine.
>>>
>>> Any suggestions? By the way, I have not tried hitcount method on the
>>> SubApp

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

[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? If not let me know.

Thanks again,


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; it is always the result of high intention,
sincere effort, intelligent direction and skillful execution; it represents
the wise choice of many alternatives.


On Tue, May 5, 2009 at 2:05 PM, Teddy R. Payne wrote:

> 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:
>
>> 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; it is always the result of high intention,
>> sincere effort, intelligent direction and skillful execution; it represents
>> the wise choice of many alternatives.
>>
>>
>> On Tue, May 5, 2009 at 1:58 PM, Teddy R. Payne wrote:
>>
>>> 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.

 
 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; it is always the result of high intention,
 sincere effort, intelligent direction and skillful execution; it represents
 the wise choice of many alternatives.


 On Tue, May 5, 2009 at 1:42 PM, Teddy R. Payne 
 wrote:

> 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 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 there own 
>> Appplication.cfm
>> file and we have clientmanagement yes and clientstorage pointing to same 
>> DSN
>> lets say XYZ like this sessionmanagement="no" setclientcookies="yes"
>> clientmanagement="yes" clientstorage="XYZ"
>>
>> One user was getting this error in MainApp and I was getting the same
>> error in subApp. Some users were not getting *any* errors at all.
>>
>> I got rid of MainApp error using this code at very end of logout
>> screen.  .Thats strange because I dont use
>> StructClear(Client). Someone mentioned that if you used StructClear then 
>> use
>> hitcount.
>>
>> I am so confused now because client.hitcount thing worked and we
>> havent used it for any of our sites which work fine.
>>
>> Any suggestions? By the way, I have not tried hitcount method on the
>> SubApp application yet.
>>
>>
>> 
>> 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; it is always the result of high
>> intention, sincere effort, intelligent direction and skillful execution; 
>> it
>> represents the wise choice of many alternatives.
>>
>>
>> On Tue, May 5, 2009 at 12:51 PM, Teddy R. Payne <
>> teddyrpa...@gmail.com> wrote:
>>
>>> 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, Aj

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

[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.
You can't improve what you don't measure.
Quality is never an accident; it is always the result of high intention,
sincere effort, intelligent direction and skillful execution; it represents
the wise choice of many alternatives.


On Tue, May 5, 2009 at 2:02 PM, Ajas Mohammed  wrote:

> 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; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives.
>
>
> On Tue, May 5, 2009 at 1:58 PM, Teddy R. Payne wrote:
>
>> 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.
>>>
>>> 
>>> 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; it is always the result of high intention,
>>> sincere effort, intelligent direction and skillful execution; it represents
>>> the wise choice of many alternatives.
>>>
>>>
>>> On Tue, May 5, 2009 at 1:42 PM, Teddy R. Payne wrote:
>>>
 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 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 there own 
> Appplication.cfm
> file and we have clientmanagement yes and clientstorage pointing to same 
> DSN
> lets say XYZ like this sessionmanagement="no" setclientcookies="yes"
> clientmanagement="yes" clientstorage="XYZ"
>
> One user was getting this error in MainApp and I was getting the same
> error in subApp. Some users were not getting *any* errors at all.
>
> I got rid of MainApp error using this code at very end of logout
> screen.  .Thats strange because I dont use
> StructClear(Client). Someone mentioned that if you used StructClear then 
> use
> hitcount.
>
> I am so confused now because client.hitcount thing worked and we havent
> used it for any of our sites which work fine.
>
> Any suggestions? By the way, I have not tried hitcount method on the
> SubApp application yet.
>
>
> 
> 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; it is always the result of high
> intention, sincere effort, intelligent direction and skillful execution; 
> it
> represents the wise choice of many alternatives.
>
>
> On Tue, May 5, 2009 at 12:51 PM, Teddy R. Payne  > wrote:
>
>> 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 say XYZ and I use this XYZ dsn as
>>> clientstorage.
>>>
>>> I am getting this error message after page request. Everything works
>>> fine except that the page has this error at end of page.
>>>
>>> 500 Operation failed on the data source named "XYZ".
>>> Operation failed on the data source named "XYZ".
>>>
>>> My search on google gave me clues that it could be a client variable
>>> causing problem or space for table storing client variables or Oracle
>>> db(which doesnt apply to me). So far, not sure what is the 

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

[axunderwood]

As an FYI - we had a similar issue up here.  There was a problem where there 
were issues such as deadlocks occurring in the database if there was high 
volume of traffic with large amounts of client data being written to and read 
from.  I would (if you can) run a trace on that database with the client tables 
in it to see if you're getting any locks that are killing off your threads.  
For some reason, CF seems to ignore the sql errors that come from the client 
data read/write.  It was a very odd issue that took a long time to find.

Another thing to do is to check and see how much old data is in those 
CDATA/CGLOBAL tables.  Putting a db maintenance plan in place that cleans out 
those tables every couple of days did wonders for getting rid of the problem 
you describe.

Allen


From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of 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.

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't measure.
Quality is never an accident; it is always the result of high intention, 
sincere effort, intelligent direction and skillful execution; it represents the 
wise choice of many alternatives.


On Tue, May 5, 2009 at 1:42 PM, Teddy R. Payne 
mailto:teddyrpa...@gmail.com>> wrote:
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 
mailto:ajash...@gmail.com>> wrote:
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 there own Appplication.cfm file and we 
have clientmanagement yes and clientstorage pointing to same DSN lets say XYZ 
like this sessionmanagement="no" setclientcookies="yes" clientmanagement="yes" 
clientstorage="XYZ"

One user was getting this error in MainApp and I was getting the same error in 
subApp. Some users were not getting *any* errors at all.

I got rid of MainApp error using this code at very end of logout screen.  .Thats strange because I dont use StructClear(Client). 
Someone mentioned that if you used StructClear then use hitcount.

I am so confused now because client.hitcount thing worked and we havent used it 
for any of our sites which work fine.

Any suggestions? By the way, I have not tried hitcount method on the SubApp 
application yet.



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; it is always the result of high intention, 
sincere effort, intelligent direction and skillful execution; it represents the 
wise choice of many alternatives.


On Tue, May 5, 2009 at 12:51 PM, Teddy R. Payne 
mailto:teddyrpa...@gmail.com>> wrote:
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 
mailto:ajash...@gmail.com>> wrote:
Hi,

I have a datasource defined lets say XYZ and I use this XYZ dsn as 
clientstorage.

I am getting this error message after page request. Everything works fine 
except that the page has this error at end of page.

500 Operation failed on the data source named "XYZ".
Operation failed on the data source named "XYZ".

My search on google gave me clues that it could be a client variable causing 
problem or space for table storing client variables or Oracle db(which doesnt 
apply to me). So far, not sure what is the root of this problem. Which log file 
I need to check to track more info about this error?

Any ideas as to what could be causing this error.

Thanks,


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; it is always the result of high intention, 
sincere effort, intelligent direction and skillful execution; it represents the 
wise choice of many alternatives.







-

To unsubscribe from this l

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

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

> 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; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives.
>
>
> On Tue, May 5, 2009 at 1:58 PM, Teddy R. Payne wrote:
>
>> 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.
>>>
>>> 
>>> 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; it is always the result of high intention,
>>> sincere effort, intelligent direction and skillful execution; it represents
>>> the wise choice of many alternatives.
>>>
>>>
>>> On Tue, May 5, 2009 at 1:42 PM, Teddy R. Payne wrote:
>>>
 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 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 there own 
> Appplication.cfm
> file and we have clientmanagement yes and clientstorage pointing to same 
> DSN
> lets say XYZ like this sessionmanagement="no" setclientcookies="yes"
> clientmanagement="yes" clientstorage="XYZ"
>
> One user was getting this error in MainApp and I was getting the same
> error in subApp. Some users were not getting *any* errors at all.
>
> I got rid of MainApp error using this code at very end of logout
> screen.  .Thats strange because I dont use
> StructClear(Client). Someone mentioned that if you used StructClear then 
> use
> hitcount.
>
> I am so confused now because client.hitcount thing worked and we havent
> used it for any of our sites which work fine.
>
> Any suggestions? By the way, I have not tried hitcount method on the
> SubApp application yet.
>
>
> 
> 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; it is always the result of high
> intention, sincere effort, intelligent direction and skillful execution; 
> it
> represents the wise choice of many alternatives.
>
>
> On Tue, May 5, 2009 at 12:51 PM, Teddy R. Payne  > wrote:
>
>> 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 say XYZ and I use this XYZ dsn as
>>> clientstorage.
>>>
>>> I am getting this error message after page request. Everything works
>>> fine except that the page has this error at end of page.
>>>
>>> 500 Operation failed on the data source named "XYZ".
>>> Operation failed on the data source named "XYZ".
>>>
>>> My search on google gave me clues that it could be a client variable
>>> causing problem or space for table storing client variables or Oracle
>>> db(which doesnt apply to me). So far, not sure what is the root of this
>>> problem. Which log file I need to check to track more info about this 
>>> error?
>>>
>>> Any ideas as to what could be causing this error.
>>>
>>> Thanks,
>>>
>>> 
>>> 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".

[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; it is always the result of high intention,
sincere effort, intelligent direction and skillful execution; it represents
the wise choice of many alternatives.


On Tue, May 5, 2009 at 1:58 PM, Teddy R. Payne wrote:

> 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.
>>
>> 
>> 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; it is always the result of high intention,
>> sincere effort, intelligent direction and skillful execution; it represents
>> the wise choice of many alternatives.
>>
>>
>> On Tue, May 5, 2009 at 1:42 PM, Teddy R. Payne wrote:
>>
>>> 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 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 there own Appplication.cfm file 
 and
 we have clientmanagement yes and clientstorage pointing to same DSN lets 
 say
 XYZ like this sessionmanagement="no" setclientcookies="yes"
 clientmanagement="yes" clientstorage="XYZ"

 One user was getting this error in MainApp and I was getting the same
 error in subApp. Some users were not getting *any* errors at all.

 I got rid of MainApp error using this code at very end of logout screen.
  .Thats strange because I dont use
 StructClear(Client). Someone mentioned that if you used StructClear then 
 use
 hitcount.

 I am so confused now because client.hitcount thing worked and we havent
 used it for any of our sites which work fine.

 Any suggestions? By the way, I have not tried hitcount method on the
 SubApp application yet.


 
 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; it is always the result of high intention,
 sincere effort, intelligent direction and skillful execution; it represents
 the wise choice of many alternatives.


 On Tue, May 5, 2009 at 12:51 PM, Teddy R. Payne 
 wrote:

> 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 say XYZ and I use this XYZ dsn as
>> clientstorage.
>>
>> I am getting this error message after page request. Everything works
>> fine except that the page has this error at end of page.
>>
>> 500 Operation failed on the data source named "XYZ".
>> Operation failed on the data source named "XYZ".
>>
>> My search on google gave me clues that it could be a client variable
>> causing problem or space for table storing client variables or Oracle
>> db(which doesnt apply to me). So far, not sure what is the root of this
>> problem. Which log file I need to check to track more info about this 
>> error?
>>
>> Any ideas as to what could be causing this error.
>>
>> Thanks,
>>
>> 
>> 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; it is always the result of high
>> intention, sincere effort, intelligent direction and skillful execution; 
>> it
>> represents the wise choice of many alternatives.
>>
>
>

>>>
>>
>

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

[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.
>
> 
> 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; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives.
>
>
> On Tue, May 5, 2009 at 1:42 PM, Teddy R. Payne wrote:
>
>> 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 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 there own Appplication.cfm file and
>>> we have clientmanagement yes and clientstorage pointing to same DSN lets say
>>> XYZ like this sessionmanagement="no" setclientcookies="yes"
>>> clientmanagement="yes" clientstorage="XYZ"
>>>
>>> One user was getting this error in MainApp and I was getting the same
>>> error in subApp. Some users were not getting *any* errors at all.
>>>
>>> I got rid of MainApp error using this code at very end of logout screen. 
>>> >> client.hitcount = 1> .Thats strange because I dont use
>>> StructClear(Client). Someone mentioned that if you used StructClear then use
>>> hitcount.
>>>
>>> I am so confused now because client.hitcount thing worked and we havent
>>> used it for any of our sites which work fine.
>>>
>>> Any suggestions? By the way, I have not tried hitcount method on the
>>> SubApp application yet.
>>>
>>>
>>> 
>>> 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; it is always the result of high intention,
>>> sincere effort, intelligent direction and skillful execution; it represents
>>> the wise choice of many alternatives.
>>>
>>>
>>> On Tue, May 5, 2009 at 12:51 PM, Teddy R. Payne 
>>> wrote:
>>>
 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 say XYZ and I use this XYZ dsn as
> clientstorage.
>
> I am getting this error message after page request. Everything works
> fine except that the page has this error at end of page.
>
> 500 Operation failed on the data source named "XYZ".
> Operation failed on the data source named "XYZ".
>
> My search on google gave me clues that it could be a client variable
> causing problem or space for table storing client variables or Oracle
> db(which doesnt apply to me). So far, not sure what is the root of this
> problem. Which log file I need to check to track more info about this 
> error?
>
> Any ideas as to what could be causing this error.
>
> Thanks,
>
> 
> 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; it is always the result of high
> intention, sincere effort, intelligent direction and skillful execution; 
> it
> represents the wise choice of many alternatives.
>


>>>
>>
>

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

[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't measure.
Quality is never an accident; it is always the result of high intention,
sincere effort, intelligent direction and skillful execution; it represents
the wise choice of many alternatives.


On Tue, May 5, 2009 at 1:42 PM, Teddy R. Payne wrote:

> 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 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 there own Appplication.cfm file and
>> we have clientmanagement yes and clientstorage pointing to same DSN lets say
>> XYZ like this sessionmanagement="no" setclientcookies="yes"
>> clientmanagement="yes" clientstorage="XYZ"
>>
>> One user was getting this error in MainApp and I was getting the same
>> error in subApp. Some users were not getting *any* errors at all.
>>
>> I got rid of MainApp error using this code at very end of logout screen. 
>> > client.hitcount = 1> .Thats strange because I dont use
>> StructClear(Client). Someone mentioned that if you used StructClear then use
>> hitcount.
>>
>> I am so confused now because client.hitcount thing worked and we havent
>> used it for any of our sites which work fine.
>>
>> Any suggestions? By the way, I have not tried hitcount method on the
>> SubApp application yet.
>>
>>
>> 
>> 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; it is always the result of high intention,
>> sincere effort, intelligent direction and skillful execution; it represents
>> the wise choice of many alternatives.
>>
>>
>> On Tue, May 5, 2009 at 12:51 PM, Teddy R. Payne wrote:
>>
>>> 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 say XYZ and I use this XYZ dsn as
 clientstorage.

 I am getting this error message after page request. Everything works
 fine except that the page has this error at end of page.

 500 Operation failed on the data source named "XYZ".
 Operation failed on the data source named "XYZ".

 My search on google gave me clues that it could be a client variable
 causing problem or space for table storing client variables or Oracle
 db(which doesnt apply to me). So far, not sure what is the root of this
 problem. Which log file I need to check to track more info about this 
 error?

 Any ideas as to what could be causing this error.

 Thanks,

 
 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; it is always the result of high intention,
 sincere effort, intelligent direction and skillful execution; it represents
 the wise choice of many alternatives.

>>>
>>>
>>
>

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

[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 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 there own Appplication.cfm file and
> we have clientmanagement yes and clientstorage pointing to same DSN lets say
> XYZ like this sessionmanagement="no" setclientcookies="yes"
> clientmanagement="yes" clientstorage="XYZ"
>
> One user was getting this error in MainApp and I was getting the same
> error in subApp. Some users were not getting *any* errors at all.
>
> I got rid of MainApp error using this code at very end of logout screen. 
>  client.hitcount = 1> .Thats strange because I dont use
> StructClear(Client). Someone mentioned that if you used StructClear then use
> hitcount.
>
> I am so confused now because client.hitcount thing worked and we havent
> used it for any of our sites which work fine.
>
> Any suggestions? By the way, I have not tried hitcount method on the SubApp
> application yet.
>
>
> 
> 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; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives.
>
>
> On Tue, May 5, 2009 at 12:51 PM, Teddy R. Payne wrote:
>
>> 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 say XYZ and I use this XYZ dsn as
>>> clientstorage.
>>>
>>> I am getting this error message after page request. Everything works fine
>>> except that the page has this error at end of page.
>>>
>>> 500 Operation failed on the data source named "XYZ".
>>> Operation failed on the data source named "XYZ".
>>>
>>> My search on google gave me clues that it could be a client variable
>>> causing problem or space for table storing client variables or Oracle
>>> db(which doesnt apply to me). So far, not sure what is the root of this
>>> problem. Which log file I need to check to track more info about this error?
>>>
>>> Any ideas as to what could be causing this error.
>>>
>>> Thanks,
>>>
>>> 
>>> 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; it is always the result of high intention,
>>> sincere effort, intelligent direction and skillful execution; it represents
>>> the wise choice of many alternatives.
>>>
>>
>>
>

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

[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 there own Appplication.cfm file and we
have clientmanagement yes and clientstorage pointing to same DSN lets say
XYZ like this sessionmanagement="no" setclientcookies="yes"
clientmanagement="yes" clientstorage="XYZ"

One user was getting this error in MainApp and I was getting the same error
in subApp. Some users were not getting *any* errors at all.

I got rid of MainApp error using this code at very end of logout screen.  .Thats strange because I dont use StructClear(Client).
Someone mentioned that if you used StructClear then use hitcount.

I am so confused now because client.hitcount thing worked and we havent used
it for any of our sites which work fine.

Any suggestions? By the way, I have not tried hitcount method on the SubApp
application yet.



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; it is always the result of high intention,
sincere effort, intelligent direction and skillful execution; it represents
the wise choice of many alternatives.


On Tue, May 5, 2009 at 12:51 PM, Teddy R. Payne wrote:

> 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 say XYZ and I use this XYZ dsn as
>> clientstorage.
>>
>> I am getting this error message after page request. Everything works fine
>> except that the page has this error at end of page.
>>
>> 500 Operation failed on the data source named "XYZ".
>> Operation failed on the data source named "XYZ".
>>
>> My search on google gave me clues that it could be a client variable
>> causing problem or space for table storing client variables or Oracle
>> db(which doesnt apply to me). So far, not sure what is the root of this
>> problem. Which log file I need to check to track more info about this error?
>>
>> Any ideas as to what could be causing this error.
>>
>> Thanks,
>>
>> 
>> 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; it is always the result of high intention,
>> sincere effort, intelligent direction and skillful execution; it represents
>> the wise choice of many alternatives.
>>
>
>

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

[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 say XYZ and I use this XYZ dsn as
> clientstorage.
>
> I am getting this error message after page request. Everything works fine
> except that the page has this error at end of page.
>
> 500 Operation failed on the data source named "XYZ".
> Operation failed on the data source named "XYZ".
>
> My search on google gave me clues that it could be a client variable
> causing problem or space for table storing client variables or Oracle
> db(which doesnt apply to me). So far, not sure what is the root of this
> problem. Which log file I need to check to track more info about this error?
>
> Any ideas as to what could be causing this error.
>
> Thanks,
>
> 
> 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; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives.
>

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

[Ajas Mohammed]

Hi,

I have a datasource defined lets say XYZ and I use this XYZ dsn as
clientstorage.

I am getting this error message after page request. Everything works fine
except that the page has this error at end of page.

500 Operation failed on the data source named "XYZ".
Operation failed on the data source named "XYZ".

My search on google gave me clues that it could be a client variable causing
problem or space for table storing client variables or Oracle db(which
doesnt apply to me). So far, not sure what is the root of this problem.
Which log file I need to check to track more info about this error?

Any ideas as to what could be causing this error.

Thanks,


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; it is always the result of high intention,
sincere effort, intelligent direction and skillful execution; it represents
the wise choice of many alternatives.

RE: [ACFUG Discuss] OpenCMS Installation

[Charlie Arehart]

Sure, happy to help. 

/charlie


-Original Message-
From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Forrest C.
Gilmore
Sent: Tuesday, May 05, 2009 1:19 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] OpenCMS Installation

Charlie:

I realized I was straying from CF topics, but hoping for a little 
reassurance
regarding Java details, which you graciously gave me.

Thanks again for your help.

Forrest C. Gilmore




-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-