There is no problem having 2000 and 2005 on the same sever. You have to make sure that each SQL Server instance has a different port. So 1433 by default for 2000 and 2005 will typically choose a different dynamic port. You can statically set ports in 2005 as well.
On 5/4/07, Dusty Hale <[EMAIL PROTECTED]> wrote:
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] *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] *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] *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> > > ------------------------------------------------------------- > > > > ------------------------------------------------------------- > > 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 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> -------------------------------------------------------------
-- Teddy R. Payne Adobe Certified ColdFusion MX 7 Developer Google Talk - [EMAIL PROTECTED] Atlanta ColdFusion User Group - http://www.acfug.org Atlanta Flash & Flex User Group - http://www.affug.org N�����r��y����b�X��f�j���鮇���m���� q����
