> 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.
When you choose the "Microsoft SQL Server" option in the CF Administrator, it doesn't use ODBC at all. So, no, it won't validate your ODBC connection. You needn't even have an ODBC connection to use this datasource - you just need to have your database server configured correctly, and you need to have the correct connection information. In the first case, this means having your database server listening on TCP/IP, allowing native SQL logons, and in the case of a SQL Server 2000 machine running multiple instances, SQL Server 2000 SP 2 or higher must be applied. In the second case, this means knowing the database name, the IP address or DNS name of the database server, the port on which it's listening, and the native SQL logon and password to access that database. 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
