Many thanks Ajas I think I'll install the sp4 patch and try again. Thanks. _____
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ajas Mohammed Sent: Thursday, May 03, 2007 5:14 PM To: discussion@acfug.org Subject: Re: FW: [ACFUG Discuss] dsn's in cf admin I found this http://bartramsbits.blogspot.com/2006/10/coldfusion-ms-sql-dsn-verification. html whenI had the issue, I know for sure there was a better link I had found which explained the problem. Ahhh i still dont remember the name of that bug. Hope it helps. <Ajas Mohammed /> http://ajashadi.blogspot.com <http://ajashadi.blogspot.com/> On 5/3/07, Ajas Mohammed <[EMAIL PROTECTED]> wrote: Hi there, I had same issue when I installed SQL Server 2000 Dev edition and CF 7 Developer edition on my notebook. I didnt make notes (ahhhhh), but I remember there was some patch for sql server 2000 which fixed the issue for me. It was some memory timeout issue or something. Its a very famous issue of SQL Server 2000 and I dont remember the exact word right now. I will go home and search for my notes. I am sure you are facing the same issue. -- <Ajas Mohammed /> http://ajashadi.blogspot.com On 5/3/07, Dusty Hale < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: Of course it works fine when setting up through windows control panel. _____ From: [EMAIL PROTECTED] [mailto: [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 <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 FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- -- <Ajas Mohammed /> http://ajashadi.blogspot.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 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 -------------------------------------------------------------