You may have to specify your username/pwd for the datasource. I have seen connection issues when this is the case.
HTH Clint ----- Original Message ----- From: "Dina Hess" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 10:22 AM Subject: DBAs/SQL Server experts? > Hi all, > > If a datasource verifies OK in CF Admin on a shared host, what would cause > the connection to fail? > > I detached a SQL Server database and FTP'd a copy to the host (couldn't get > DTS to work...but that's another problem). He created an ODBC system data > source on his Windows box then set up the data source in CF Admin. The data > source verifies fine on his system, but my application, which references the > same data source in CFQUERY, is not getting a connection. > > I'd been using MSDE and Query Analyzer so I could practice running queries > against SQL Server data sources, but I'm completely new to the full blown > SQL Server Enterprise Manager. I've probably done something brainless. But I > don't know what it could be. :/ > > Any ideas? > > ~Dina > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
