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 help. Dusty
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ajas Mohammed Sent: Thursday, May 03, 2007 6:23 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] dsn's in cf admin That will do it. I am pretty sure. :-) -- <Ajas Mohammed /> http://ajashadi.blogspot.com On 5/3/07, Dusty Hale <[EMAIL PROTECTED]> wrote: I've now installed sql sp4 but this alone did not solve the problem. I'm downloading the sql critical update tool to see if that helps. _____ From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] On Behalf Of William Renfro Sent: Thursday, May 03, 2007 5:37 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] dsn's in cf admin If it's SQL 2000 and Windows XP ( with service packs) . You must have at least service pack 3 on SQL Server for it to work. There should be a reference to this in the windows event log as well. _____ 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 <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> ------------------------------------------------------------- ------------------------------------------------------------- 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 -------------------------------------------------------------