Hi Dusty,
I found the link. I think this was it
http://www.robisen.com/index.cfm/2006/6/2/ColdFusion-MX--MS-SQL--Resolving-the-dreaded-SQLException-while-attempting-to-connect-error
and name of bug is slammer worm. Here is MS link which Robisen has on his
blog
http://www.microsoft.com/downloads/details.aspx?familyid=9552d43b-04eb-4af9-9e24-6cde4d933600&displaylang=en
Let me know if it worked or not.
<Ajas Mohammed />
http://ajashadi.blogspot.com
On 5/3/07, Dusty Hale <[EMAIL PROTECTED]> wrote:
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
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]> wrote:
> >
> > Of course it works fine when setting up through windows control
> > panel.
> >
> > ------------------------------
> > *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 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 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 http://www.fusionlink.com
-------------------------------------------------------------
