There is no need for login info in the Application.cfm, as ColdFusion handles that just fine.
I would think all one needs is the name of the datasource, and possibly the type "ODBC" ====================================== Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 ====================================== If you are not satisfied with my service, my job isn't done! ----- Original Message ----- From: "Dan Phillips" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 10:30 AM Subject: RE: DBAs/SQL Server experts? | Check your application.cfm. Do you have all the right log in info for | SQL? | | Dan Phillips | www.CFXHosting.com | 1-866-239-4678 | [EMAIL PROTECTED] | | -----Original Message----- | From: Dina Hess [mailto:[EMAIL PROTECTED] | Sent: Friday, June 13, 2003 11:23 AM | To: CF-Talk | 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 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
