RE: CF Holding On To DSN
That did not help, any other ideas? -Original Message- From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 02, 2000 11:56 PM To: [EMAIL PROTECTED] Subject: Re: CF Holding On To DSN put cflock tags around the query. you might even try cftransaction. Fred - Original Message - From: "Miriam Hirschman" [EMAIL PROTECTED] To: "CF Forum" [EMAIL PROTECTED] Sent: Saturday, September 02, 2000 11:55 PM Subject: CF Holding On To DSN I have a page that links to one DSN, but as soon as a user requests a page which connects to another DSN I get an error. CF is looking for the table in the old DSN . It seems as if CF is holding on to the old DSN connection. What can I do to make sure that when a new page is called up, that CF should reconnect to the right DSN?? Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF Holding On To DSN
On 9/2/00, Miriam Hirschman penned: I have a page that links to one DSN, but as soon as a user requests a page which connects to another DSN I get an error. CF is looking for the table in the old DSN . It seems as if CF is holding on to the old DSN connection. What can I do to make sure that when a new page is called up, that CF should reconnect to the right DSN?? Never heard of such a problem. Have you double checked your query to be sure you're not referring to the table in the query returning the error? Is this server your own? Have you double checked to make sure that the Datasource name didn't get pointed to the wrong database? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF Holding On To DSN
What host are you using? Ken - Original Message - From: Miriam Hirschman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, September 03, 2000 2:10 PM Subject: RE: CF Holding On To DSN Hi. Thanks for responding. The tables that are referred to as well as the DSn have to be right because no matter which one I try the first one always works. It's just that when I link from one to the other or put the address in manually-that's when I get the error. Also, it is not my own servwer. Would that make a difference? -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 12:54 PM To: [EMAIL PROTECTED] Subject: Re: CF Holding On To DSN On 9/2/00, Miriam Hirschman penned: I have a page that links to one DSN, but as soon as a user requests a page which connects to another DSN I get an error. CF is looking for the table in the old DSN . It seems as if CF is holding on to the old DSN connection. What can I do to make sure that when a new page is called up, that CF should reconnect to the right DSN?? Never heard of such a problem. Have you double checked your query to be sure you're not referring to the table in the query returning the error? Is this server your own? Have you double checked to make sure that the Datasource name didn't get pointed to the wrong database? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Holding On To DSN
It's a gov. server. -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 2:46 PM To: [EMAIL PROTECTED] Subject: Re: CF Holding On To DSN What host are you using? Ken - Original Message - From: Miriam Hirschman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, September 03, 2000 2:10 PM Subject: RE: CF Holding On To DSN Hi. Thanks for responding. The tables that are referred to as well as the DSn have to be right because no matter which one I try the first one always works. It's just that when I link from one to the other or put the address in manually-that's when I get the error. Also, it is not my own servwer. Would that make a difference? -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 12:54 PM To: [EMAIL PROTECTED] Subject: Re: CF Holding On To DSN On 9/2/00, Miriam Hirschman penned: I have a page that links to one DSN, but as soon as a user requests a page which connects to another DSN I get an error. CF is looking for the table in the old DSN . It seems as if CF is holding on to the old DSN connection. What can I do to make sure that when a new page is called up, that CF should reconnect to the right DSN?? Never heard of such a problem. Have you double checked your query to be sure you're not referring to the table in the query returning the error? Is this server your own? Have you double checked to make sure that the Datasource name didn't get pointed to the wrong database? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF Holding On To DSN
I have a page that links to one DSN, but as soon as a user requests a page which connects to another DSN I get an error. CF is looking for the table in the old DSN . It seems as if CF is holding on to the old DSN connection. What can I do to make sure that when a new page is called up, that CF should reconnect to the right DSN?? Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF Holding On To DSN
put cflock tags around the query. you might even try cftransaction. Fred - Original Message - From: "Miriam Hirschman" [EMAIL PROTECTED] To: "CF Forum" [EMAIL PROTECTED] Sent: Saturday, September 02, 2000 11:55 PM Subject: CF Holding On To DSN I have a page that links to one DSN, but as soon as a user requests a page which connects to another DSN I get an error. CF is looking for the table in the old DSN . It seems as if CF is holding on to the old DSN connection. What can I do to make sure that when a new page is called up, that CF should reconnect to the right DSN?? Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.