Has anyone on the list been able to assign a dsn in the CFMX administrator to a database on a named instance of MS SQL 2000?
I have a server here with MS SQL 7 on 127.0.0.1 or "TURING" ( the server's machine name ) and a SQL Server 2000 named instance at "TURING\SOCRATES" ... In CF 5 I could simply designate TURING\SOCRATES in the server field in the cf administrator and everything is copasetic at that point, but MX doesn't produce the same behavior. I'm able to connect to the databases on the SQL Server 7 install usuing either TURING or 127.0.0.1 in the server field. I have installed the updater ( which said it had one non-fatal error while trying to process an ANT file ). I tried 127.0.0.1\SOCRATES and 127.0.0.1 by itself after stopping the SQL 7 service. I tried TURING/SOCRATES thinking that maybe that was changed somehow because \ is an escape character in Java literal strings. I tried using TURING\\SOCRATES since \\ is the esape sequence for \ in Java. I tried TURING:SOCRATES just as a stab in the dark ( incidentally this hung the page and prevented me from accessing the CF Administrator until I restarted the service ). So at this point I'm stuck... I'd be really appreciative if anyone else has got this to work if they could give me a pointer. :) Thanks, s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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.