Is this still an issue for you, Dusty? Is it possible that the problem is that the version of SQL Server you're trying to reach is not using the default port 1433?
/Charlie http://www.carehart.org/ <http://www.carehart.org/images/ace.gif> _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Thursday, May 03, 2007 4:54 PM To: discussion@acfug.org Subject: [ACFUG Discuss] dsn's in cf admin I'm used to setting up dsn's for SQL Server with the server name "(local)" when in fact the server instance is local. However, I just installed SQL Server 2000 Eval on my laptop and am trying to set up a dsn to a database I just created. I've verified the server name is (local) and I tried that and also the IP 127.0.0.1 (CF 7 and SQL 2000) I get this error (in cf admin dsn section) when using the ip: Connection verification failed for data source: tester java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect I get this error when using (local): Connection verification failed for data source: tester java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Unknown host: (local) The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Unknown host: (local) If anyone could tell me what I'm doing wrong, I would greatly appreciate it. I also have SQL Server 2005 Express running on the same machine with a different instance name and setting dsn's to that one works fine. thx Dusty ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
<<ace.gif>>