you're not running an instance of MSDE SQL Server are you in a funny instance name? I had an oddity with that and was unable to connect CF to it - SQL had come preinstalled on my Dell laptop as part of Business Contact manager that shipped with Office 2003 - it was a right pain to get rid of it and get a default SQL instance installed
jb. On 4/25/05, Mike Kear <[EMAIL PROTECTED]> wrote: > > 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 <http://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 <http://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. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:204235 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
