[ACFUG Discuss] dsn's in cf admin

2007-05-03 Thread Dusty Hale
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

Re: [ACFUG Discuss] dsn's in cf admin

2007-05-03 Thread Steven Ross
maybe this will help? http://www.forta.com/blog/index.cfm/2006/1/10/ColdFusion-And-SQL-Server-2005 On 5/3/07, Dusty Hale [EMAIL PROTECTED] wrote: 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

FW: [ACFUG Discuss] dsn's in cf admin

2007-05-03 Thread Dusty Hale
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

Re: FW: [ACFUG Discuss] dsn's in cf admin

2007-05-03 Thread Ajas Mohammed
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 (ah), 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

Re: FW: [ACFUG Discuss] dsn's in cf admin

2007-05-03 Thread Ajas Mohammed
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 /

RE: FW: [ACFUG Discuss] dsn's in cf admin

2007-05-03 Thread Dusty Hale
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

Re: FW: [ACFUG Discuss] dsn's in cf admin

2007-05-03 Thread Ajas Mohammed
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

RE: [ACFUG Discuss] dsn's in cf admin

2007-05-03 Thread Dan Kaufman
I'm not sure if this is relevant, but on my home dev box ( Windows XP, CFMX 7, SQL-2000) I use 127.0.0.1:8500 Dan Kaufman _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Thursday, May 03, 2007 1:54 PM To: discussion@acfug.org Subject: [ACFUG

RE: [ACFUG Discuss] dsn's in cf admin

2007-05-03 Thread Dusty Hale
I ran the critical updater (several times both with service running and stopped) but it produces a message at the end: Critical update unsuccessful. Contact MS Product support. I'll keep digging around but if you think of anything else please let me know and thanks to all who have tried to

Re: [ACFUG Discuss] dsn's in cf admin

2007-05-03 Thread Ajas Mohammed
Hi, I was reading online about this message you are getting and MS has some info about it http://support.microsoft.com/?kbid=814372 Critical Update Unsuccessful Messages•If you receive the following message, try to install the update again by using an account with administrator permissions: