Miriam,
Have you ensured that "maintain database connections" options is UNchecked
in your odbc settings for both datasources on the server?
Dave Wilson
Internet Technology Manager,
BizNet Solutions
<Allaire Premier Partner>
Co-Founder CFUG Ireland
http://www.cfug.ie
224, Lisburn Road
Belfast BT9 6GE
Tel: 02890 225 776
Fax: 02890 223 223
web: http://www.biznet-solutions.com
email: [EMAIL PROTECTED]
----- Original Message -----
From: "Miriam Hirschman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 05, 2000 5:12 PM
Subject: RE: It takes CF 1 minute to close DSN
> I thought that the application.cfm page is called before each page in that
> directory. So why doesn't the variable get updated before the page loads.
> Also, I've used this code before in other applications without a problem.
> I'm not sure I understand why this method is giving me an error now. In a
> CF article I read, it said that it is better not to hard code the DSN
name,
> because it makes your code hard to maintain. Please explain.
>
> Thanks so much for your time.
>
> -----Original Message-----
> From: Bud [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 05, 2000 12:01 PM
> To: [EMAIL PROTECTED]
> Subject: RE: It takes CF 1 minute to close DSN
>
>
> On 9/5/00, Miriam Hirschman penned:
> ><cfquery name="qryGetProgram" datasource="#Application.settings.dsn#"
> >dbtype="ODBC">
>
> Where are you setting application.settings.dsn? What are you using
> for the datasource name on the second page? If you are using
> application.settings.dsn as the datasource name for both queries, and
> if that is supposed to change dynamically, depending on which page
> you are accessing (which by the way, would probably be a bad use of
> application variables) and it's not changing until AFTER you access
> the second query, then that would explain why it doesn't access the
> correct datasource until you click the 2nd time, AFTER the
> application variable is updated.
>
> Try entering the datasource names manually in both queries and see
> what happens.
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
> --------------------------------------------------------------------------
--
> --
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
