Dave, I'm still confused on this. I upgraded to MX and most of my datasources were to a SQL Server using windows authentication. When I installed all those datasources failed to copy over. Then when I tried to access them through the CFMX Admin it hung the server for like 5 minutes. I ended up having to delete each ds, then restart CFMX, THEN I could recreate the ds but having to specify the username/pw of the windows admin account. In CF5 you used to be able to create an ODBC connection though windows ODBC and then validate it through the CF Admin correct? Now with MX you can't go that route? It seemed clumsy. Perhaps there's a better way to handle it.
Greg -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Saturday, June 14, 2003 10:30 AM To: CF-Talk Subject: RE: DBAs/SQL Server experts? > 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 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