MX can act quite strange with DSNs
How I get around it screwing things up: -setup System DSN through Windows ODBC (tell it to use Windows Authentication) -setup DSN in CF Admin (this is where you put the username and pass) If I don't do it in that order....KABOOM!! HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Dina Hess" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 8:59 AM Subject: Re: DBAs/SQL Server experts? > > Check your application.cfm. Do you have all the right log in info for > > SQL? > > > Dan, I have the data source set up in Application.cfm in the request scope. > That's all I need, isn't it? (When we started having problems with this, I > did specify the exact username/password my host used in his CF Admin data > source configuration, even changed all my CFQUERY tags to include those > attributes. But it still didn't work, so I backed off on that.) > > On my MX development box, I have this SQL Server data source set up as a > trusted connection using the ODBC Socket. But that wouldn't affect the > connection on the shared host, would it? > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
