With MSDE you have to configure an ODBC connector and then set up an ODBC datasource in CFMX. MSDE doesn't listen on port 1433 as its intended to be a desktop DB rather than a server application. Also I had to do everything locally through Query Analyser rather than Enterprise manager for the very same reason.
A pig of a problem but it is the only way to get a MS SQL instance running on Windows 2003 Webserver edition which our development server runs... I guess that MS's take on this is that if you are running webserver edition then you should have a separate DB server. Whilst in a production environment, this should be the case, in development I don't see a reason to warrant that much more expense on hardware and licences... well maybe load testing I guess :) Paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189919 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
