Re: Upgraded to MX7, SQL Server datasources no longer work
This seems to be the only thing that works. Thanks much! Brian > Brian, before you go doing that, reread my email on this. I > encountered this problem, and this solution, which I found months ago, > worked. > > > 1. Set up a System DSN on the machine to the database. > > 2. Set up the CF DSN using ODBC Socket as the driver. > > As long as the system DSN connects successfully to the database, this > will work. > > > thanks > -r > _ > Rob Barthle > Contractor - Sr. Software Developer > [EMAIL PROTECTED] > 202-245-6484 > > > > -Original Message- > From: Brian Yager [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 01, 2006 3:49 PM > To: CF-Talk > Subject: Re: Upgraded to MX7, SQL Server datasources no longer work > > > I've got both Named Pipes and TCP/IP enabled. > > The DB server is on the same machine as the CF Server. So Firewalls > wouldn't be the problem. But just to make sure, I disabled Windows > Firewall and it sitll didn't work. I think I am going to uninstall CF > 7 and reinstall it to see if that makes a differenc. I am just > clueless right now. > > >> Unfortunately, that did work. Here is the error I get back > >> > >> Connection verification failed for data source: calendar > >> 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 > > > >Are you sure you configured the server to listen on TCP/IP? Run the > Server > >Network Utility, and make sure that TCP/IP is enabled; I suspect that > you > >only have Named Pipes enabled. > > > >Dave Watts, CTO, Fig Leaf Software > >http://www.figleaf.com/ > > > >Fig Leaf Software provides the highest caliber vendor-authorized > >instruction at our training centers in Washington DC, Atlanta, > >Chicago, Baltimore, Northern Virginia, or on-site at your location. > >Visit http://training.figleaf.com/ for more information! > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234023 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Upgraded to MX7, SQL Server datasources no longer work
While I do not disagree with that statement, again I fail to see where using ODBC on a personal laptop is going to cause such terrible problems. Server load? Nope. Problems handling the SQL? Not unless you're a terrible SQL coder (I have seem some issues when people used non-standard syntax, but they didn't know what they were doing really when they wrote it). So again, if all else is failing, where's the problem in this? I don't see it, other than a bunch of nice-to-have's that really mean squat if JDBC can't connect. thanks -r _ Rob Barthle Contractor - Sr. Software Developer [EMAIL PROTECTED] 202-245-6484 -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Thursday, March 02, 2006 9:20 AM To: CF-Talk Subject: Re: Upgraded to MX7, SQL Server datasources no longer work The enviroment on the laptop should be exactly what the server enviroment is. If they use ODBC on thier server (which I highly recommend not to), then the laptop should do it. If not, then it shouldn't. Are you using full blow version of SQL or are you using MSDE? If you're using MSDE it defaults with 1433 turned off, you have to install it from a command prompt with a bunch of options in the string in order to enable it. Bob Everland ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233910 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Upgraded to MX7, SQL Server datasources no longer work
> Dave, we're talking about someone's personal laptop for > development purposes. I do not think performance is going to > be an issue here. Probably not. I didn't pick up on that part of the thread, I guess. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233908 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Upgraded to MX7, SQL Server datasources no longer work
The enviroment on the laptop should be exactly what the server enviroment is. If they use ODBC on thier server (which I highly recommend not to), then the laptop should do it. If not, then it shouldn't. Are you using full blow version of SQL or are you using MSDE? If you're using MSDE it defaults with 1433 turned off, you have to install it from a command prompt with a bunch of options in the string in order to enable it. Bob Everland ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233900 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Upgraded to MX7, SQL Server datasources no longer work
Dave, we're talking about someone's personal laptop for development purposes. I do not think performance is going to be an issue here. thanks -r _ Rob Barthle Contractor - Sr. Software Developer [EMAIL PROTECTED] 202-245-6484 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, March 02, 2006 10:08 AM To: CF-Talk Subject: RE: Upgraded to MX7, SQL Server datasources no longer work > But if all else fails, it has one major advantage: it actually > works. I would strongly recommend that you fix JDBC rather than use ODBC for your CF/SQL Server applications. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233896 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Upgraded to MX7, SQL Server datasources no longer work
> But if all else fails, it has one major advantage: it actually > works. I would strongly recommend that you fix JDBC rather than use ODBC for your CF/SQL Server applications. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233893 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Upgraded to MX7, SQL Server datasources no longer work
But if all else fails, it has one major advantage: it actually works. thanks -r _ Rob Barthle Contractor - Sr. Software Developer [EMAIL PROTECTED] 202-245-6484 -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Thursday, March 02, 2006 8:30 AM To: CF-Talk Subject: Re: Upgraded to MX7, SQL Server datasources no longer work Setting up the machine to use ODBC is not a good option. It is much slower than the direct method. I would take off Named pipes. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233878 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Upgraded to MX7, SQL Server datasources no longer work
Setting up the machine to use ODBC is not a good option. It is much slower than the direct method. I would take off Named pipes. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233877 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Upgraded to MX7, SQL Server datasources no longer work
Brian, before you go doing that, reread my email on this. I encountered this problem, and this solution, which I found months ago, worked. 1. Set up a System DSN on the machine to the database. 2. Set up the CF DSN using ODBC Socket as the driver. As long as the system DSN connects successfully to the database, this will work. thanks -r _ Rob Barthle Contractor - Sr. Software Developer [EMAIL PROTECTED] 202-245-6484 -Original Message- From: Brian Yager [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 01, 2006 3:49 PM To: CF-Talk Subject: Re: Upgraded to MX7, SQL Server datasources no longer work I've got both Named Pipes and TCP/IP enabled. The DB server is on the same machine as the CF Server. So Firewalls wouldn't be the problem. But just to make sure, I disabled Windows Firewall and it sitll didn't work. I think I am going to uninstall CF 7 and reinstall it to see if that makes a differenc. I am just clueless right now. >> Unfortunately, that did work. Here is the error I get back >> >> Connection verification failed for data source: calendar >> 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 > >Are you sure you configured the server to listen on TCP/IP? Run the Server >Network Utility, and make sure that TCP/IP is enabled; I suspect that you >only have Named Pipes enabled. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233874 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Upgraded to MX7, SQL Server datasources no longer work
I've got both Named Pipes and TCP/IP enabled. The DB server is on the same machine as the CF Server. So Firewalls wouldn't be the problem. But just to make sure, I disabled Windows Firewall and it sitll didn't work. I think I am going to uninstall CF 7 and reinstall it to see if that makes a differenc. I am just clueless right now. >> Unfortunately, that did work. Here is the error I get back >> >> Connection verification failed for data source: calendar >> 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 > >Are you sure you configured the server to listen on TCP/IP? Run the Server >Network Utility, and make sure that TCP/IP is enabled; I suspect that you >only have Named Pipes enabled. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233802 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Upgraded to MX7, SQL Server datasources no longer work
> Unfortunately, that did work. Here is the error I get back > > Connection verification failed for data source: calendar > 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 Are you sure you configured the server to listen on TCP/IP? Run the Server Network Utility, and make sure that TCP/IP is enabled; I suspect that you only have Named Pipes enabled. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233736 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Upgraded to MX7, SQL Server datasources no longer work
I encountered this on my home development server (MX7.01 Developers). The fix was a workaround. 1. Set up a System DSN on the machine to the database. 2. Set up the CF DSN using ODBC Socket as the driver. thanks -r _ Rob Barthle Contractor - Sr. Software Developer [EMAIL PROTECTED] 202-245-6484 -Original Message- From: Brian Yager [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 28, 2006 7:18 PM To: CF-Talk Subject: Re: Upgraded to MX7, SQL Server datasources no longer work Unfortunately, that did work. Here is the error I get back Connection verification failed for data source: calendar 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 Brian >Hey Brian, > >I've encountered this before, and got things working after installing >the latest SQL server update (should be available at >http://www.microsoft.com/technet/prodtechnol/sql/2000/downloads/default.mspx) >- if that doesn't help, could you post the entire error message (minus >any private info)? > >Thanks, > >Joe > >On 2/28/06, Brian Yager <[EMAIL PROTECTED]> wrote: >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233734 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Upgraded to MX7, SQL Server datasources no longer work
On Wednesday 01 March 2006 00:17, Brian Yager wrote: > java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error > establishing socket. Connection refused: connect Something is wrong at the basic TCP/IP level - firewall or ACL on the DB server maybe ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233725 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Upgraded to MX7, SQL Server datasources no longer work
Unfortunately, that did work. Here is the error I get back Connection verification failed for data source: calendar 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 Brian >Hey Brian, > >I've encountered this before, and got things working after installing >the latest SQL server update (should be available at >http://www.microsoft.com/technet/prodtechnol/sql/2000/downloads/default.mspx) >- if that doesn't help, could you post the entire error message (minus >any private info)? > >Thanks, > >Joe > >On 2/28/06, Brian Yager <[EMAIL PROTECTED]> wrote: >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233699 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Upgraded to MX7, SQL Server datasources no longer work
Hey Brian, I've encountered this before, and got things working after installing the latest SQL server update (should be available at http://www.microsoft.com/technet/prodtechnol/sql/2000/downloads/default.mspx) - if that doesn't help, could you post the entire error message (minus any private info)? Thanks, Joe On 2/28/06, Brian Yager <[EMAIL PROTECTED]> wrote: > I am using SQL Server 2000. Thanks for catching that. > > >Brian you've mentioned My SQL and Enterprise Manager (which is for MS SQL > >Server), so which DB are you having trouble with? ;-) > > > >Cheers > > > >Bryan Stevenson B.Comm. > >VP & Director of E-Commerce Development > >Electric Edge Systems Group Inc. > >phone: 250.480.0642 > >fax: 250.480.1264 > >cell: 250.920.8830 > >e-mail: [EMAIL PROTECTED] > >web: www.electricedgesystems.com > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233690 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Upgraded to MX7, SQL Server datasources no longer work
I am using SQL Server 2000. Thanks for catching that. >Brian you've mentioned My SQL and Enterprise Manager (which is for MS SQL >Server), so which DB are you having trouble with? ;-) > >Cheers > >Bryan Stevenson B.Comm. >VP & Director of E-Commerce Development >Electric Edge Systems Group Inc. >phone: 250.480.0642 >fax: 250.480.1264 >cell: 250.920.8830 >e-mail: [EMAIL PROTECTED] >web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233687 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Upgraded to MX7, SQL Server datasources no longer work
Brian you've mentioned My SQL and Enterprise Manager (which is for MS SQL Server), so which DB are you having trouble with? ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233685 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
