My bad too .. I am using the MS SQLServer driver. According to the docs, you should put (local) for server name if the server is on the same machine. I've tried that. And I've also tried using 127.0.0.1 and the computer name (notebook) and always the same result:
[quote] java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Unknown host: (local) [/quote] I've set up dozens of DSNs before using this same procedure, and the only difference that I can see is that this time I have CFMX7 installed under JRUN. It worked flawlessly in all my setups before from CF4.2 onwards. now it doesnt. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 4/25/05, Jared Rypka-Hauer - CMG, LLC <[EMAIL PROTECTED]> wrote: > OOPS! > > My bad... > > Why are you using ODBC?? > > Go into the Administrator, go to Datasources, and in the dropdown > click SQLOLEDB. > > Then configure your datasource with the same settings you would in the > OS Control Panel... IP (generally most reliable), username, > password... those are all you should *need*... but if you click "Show > Advanced Settings" it'll give you more options. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204231 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
