I should have gone this route before but I think the best solution is to ax the use of a dsn and do DSNless connections. That seems to work fine to sql 2000 and express both running local on the same machine. Since I haven't really used this approach in the past for CF apps, my only thought is should connections be options be closed and destroyed (like in ASP)?
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ajas Mohammed Sent: Thursday, May 03, 2007 7:04 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] dsn's in cf admin 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: The user account does not have sufficient privileges to run the patch. Please see your system administrator for assistance. To do this, log on to the computer as an administrator, or contact your local administrator for more help. . If you receive one of the following messages, contact Microsoft Product Support Services: There was an error updating Microsoft SQL Server 2000 or Microsoft SQL Desktop Engine 2000. -or- There was an error updating Microsoft SQL Server 2000 or Microsoft SQL Desktop Engine 2000 in the following languages: languages list. To contact Microsoft Product Support Services, click More Information in the MSDE 2000/SQL Server 2000Critical Update dialog box. This opens the following Microsoft Web site, where you can find information about how to contact Microsoft Product Support Services: http://support.microsoft.com/default.aspx All the best Ajas. On 5/3/07, Dusty Hale <[EMAIL PROTECTED]> wrote: 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] <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 <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> ------------------------------------------------------------- -- <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 -------------------------------------------------------------
