RE: [ACFUG Discuss] dsn's in cf admin
Well yes :-) that was it. I think because I was running several versions maybe (2000 and also 2005 express)? Anyway I switched version 2000 over to port 5000 and dsn's work fine now in cf admin as long as I change the port number there too. Also in the process as a work around I started experimenting with using connection strings in my cfscript code rather than rely on dsn. I'd be curious to know if others prefer not to use a dsn? Many thanks to everyone that gave advice. Dusty _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: Tuesday, May 08, 2007 10:51 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] dsn's in cf admin Is this still an issue for you, Dusty? Is it possible that the problem is that the version of SQL Server you're trying to reach is not using the default port 1433? /Charlie http://www.carehart.org/<http://www.carehart.org/images/ace.gif> _ 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 http://www.fusionlink.com - <>
RE: [ACFUG Discuss] dsn's in cf admin
Is this still an issue for you, Dusty? Is it possible that the problem is that the version of SQL Server you're trying to reach is not using the default port 1433? /Charlie http://www.carehart.org/<http://www.carehart.org/images/ace.gif> _ 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 http://www.fusionlink.com - <>
RE: FW: [ACFUG Discuss] dsn's in cf admin
Greetings: Are both SQL servers named "(local)"? If so, I would try to specify a different name for one or the other. I suspect that ColdFusion server is trying to connect to the wrong server and cannot find the database. Sincerely, Brooks Wilson Try not to become a man of success but rather to become a man of value. - Albert Einstein (1879-1955) Federal Reserve Bank of Atlanta · 1000 Peachtree Street, N.E. · Atlanta Georgia 30309-4470 404.498.8178 · fax 404.498.8239 · [EMAIL PROTECTED] "Dusty Hale" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/04/2007 08:37 AM Please respond to discussion@acfug.org To cc Subject RE: FW: [ACFUG Discuss] dsn's in cf admin Can't seem to find a solution that works so I'm going to develop with sql server express and dts the data back and forth with SQL Enterprise manager. I can set up dsn's with cf admin fine to sql express databases just not the sql 2000. Maybe there is a problem running multiple versions of sql on the same server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross Sent: Thursday, May 03, 2007 7:30 PM To: discussion@acfug.org Subject: Re: FW: [ACFUG Discuss] dsn's in cf admin sorry i read sql server 2005 for some reason... and im not using windows anymore so I should lay off "helping" on any windows related questions. 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 > - > - > > 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 > - -- Steven Ross web application & interface developer http://www.zerium.com [mobile] 404-488-4364 [fax] 267-482-4364 - 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 - 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 - <>
Re: [ACFUG Discuss] dsn's in cf admin
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. :-) > > -- > > 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 > > JDB
RE: [ACFUG Discuss] dsn's in cf admin
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. :-) -- 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/mai
RE: FW: [ACFUG Discuss] dsn's in cf admin
Can't seem to find a solution that works so I'm going to develop with sql server express and dts the data back and forth with SQL Enterprise manager. I can set up dsn's with cf admin fine to sql express databases just not the sql 2000. Maybe there is a problem running multiple versions of sql on the same server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross Sent: Thursday, May 03, 2007 7:30 PM To: discussion@acfug.org Subject: Re: FW: [ACFUG Discuss] dsn's in cf admin sorry i read sql server 2005 for some reason... and im not using windows anymore so I should lay off "helping" on any windows related questions. 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 > - > - > > 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 > - -- Steven Ross web application & interface developer http://www.zerium.com [mobile] 404-488-4364 [fax] 267-482-4364 - 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 - - 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 -
Re: FW: [ACFUG Discuss] dsn's in cf admin
sorry i read sql server 2005 for some reason... and im not using windows anymore so I should lay off "helping" on any windows related questions. 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 - - 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 - -- Steven Ross web application & interface developer http://www.zerium.com [mobile] 404-488-4364 [fax] 267-482-4364 - 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 -
RE: [ACFUG Discuss] dsn's in cf admin
thx Ajas I figured this out too but I was running it with admin permissions. I'm going to work on it more tomorrow. _ 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. :-) -- 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> -
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. :-) -- 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 you
RE: [ACFUG Discuss] dsn's in cf admin
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. :-) -- 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 -
Re: [ACFUG Discuss] dsn's in cf admin
That will do it. I am pretty sure. :-) -- 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 http://www.fusionlink.com -
RE: [ACFUG Discuss] dsn's in cf admin
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 http://www.fusionlink.com -
RE: [ACFUG Discuss] dsn's in cf admin
Thx Dan I tried this but no luck. Strange problem ... _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Kaufman Sent: Thursday, May 03, 2007 5:43 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] dsn's in cf admin 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 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 http://www.fusionlink.com -
RE: [ACFUG Discuss] dsn's in cf admin
I'm downloading sql server sp4 to see if that does the trick. _ 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 http://www.fusionlink.com -
RE: [ACFUG Discuss] dsn's in cf admin
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 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 http://www.fusionlink.com -
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 http://www.fusionlink.com -
Re: FW: [ACFUG Discuss] dsn's in cf admin
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. 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. 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 > (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 > 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. > -- > > 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> > > - > > > > &
RE: FW: [ACFUG Discuss] dsn's in cf admin
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. http://ajashadi.blogspot.com <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 (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 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. -- http://ajashadi.blogspot.com On 5/3/07, Dusty Hale < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: Of course it works fine when setting up through windows control panel. _ 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 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> - -- 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 -
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. 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 (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 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. -- 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> > - > -- 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 -
Re: FW: [ACFUG Discuss] dsn's in cf admin
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 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. -- 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> - - 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 -
FW: [ACFUG Discuss] dsn's in cf admin
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 http://www.fusionlink.com -
Re: [ACFUG Discuss] dsn's in cf admin
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 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 - -- Steven Ross web application & interface developer http://www.zerium.com [mobile] 404-488-4364 [fax] 267-482-4364 - 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 -
[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 http://www.fusionlink.com -