> 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!!
CFMX is certainly different than CF 5, with regard to database connectivity. However, you needn't set up an ODBC DSN to connect to MS SQL Server from CFMX. And, if you do set one up, CFMX will only use it if you select the "ODBC Socket" datasource option in the CF Administrator. And, finally, if you use Windows Authentication, you won't need a username and password in your datasource settings - Windows Authentication will use the account that makes the connection (that is, whatever account the CF service is running within) for authentication. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
