Trouble connection to local database
I'm trying to set up a local dev/testing environment on my PC, using CFMX 6.1 and SQL Server 2000 (both installed on my local box). I've got the correct un and pw for CF to get into the database, but each time I try to set the DSN in CF administrator, it gives me an error saying: Connection verification failed for data source: Localdb []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 Which sounds like it isn't a un/pw problem, but an outright refusal of SQL server to allow the CF app server any connection at all. Am I overlooking something? In CF admin, the info for the DSN is simple - data source name is localdb, name of the database in SQL is localdb, server is localhost, un is sa, and pw has been entered correctly. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222111 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: Trouble connection to local database
I had this same problem. Make sure you are using MS-SQL Service Pack 3 or better -Original Message- From: Christophe Maso [mailto:[EMAIL PROTECTED] Sent: Monday, October 24, 2005 3:05 PM To: CF-Talk Subject: Trouble connection to local database I'm trying to set up a local dev/testing environment on my PC, using CFMX 6.1 and SQL Server 2000 (both installed on my local box). I've got the correct un and pw for CF to get into the database, but each time I try to set the DSN in CF administrator, it gives me an error saying: Connection verification failed for data source: Localdb []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 Which sounds like it isn't a un/pw problem, but an outright refusal of SQL server to allow the CF app server any connection at all. Am I overlooking something? In CF admin, the info for the DSN is simple - data source name is localdb, name of the database in SQL is localdb, server is localhost, un is sa, and pw has been entered correctly. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222112 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: Trouble connection to local database
Forgot to add, after you do the Service Pack, get the latest updates from Macromedia especially the macromedia_drivers.zip. Sorry do not remember which HotFix it was. -Original Message- From: Christophe Maso [mailto:[EMAIL PROTECTED] Sent: Monday, October 24, 2005 3:05 PM To: CF-Talk Subject: Trouble connection to local database I'm trying to set up a local dev/testing environment on my PC, using CFMX 6.1 and SQL Server 2000 (both installed on my local box). I've got the correct un and pw for CF to get into the database, but each time I try to set the DSN in CF administrator, it gives me an error saying: Connection verification failed for data source: Localdb []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 Which sounds like it isn't a un/pw problem, but an outright refusal of SQL server to allow the CF app server any connection at all. Am I overlooking something? In CF admin, the info for the DSN is simple - data source name is localdb, name of the database in SQL is localdb, server is localhost, un is sa, and pw has been entered correctly. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222113 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: Trouble connection to local database
Did you check to make sure TCP/IP is enabled for your SQL server? On 10/24/05, Christophe Maso [EMAIL PROTECTED] wrote: I'm trying to set up a local dev/testing environment on my PC, using CFMX 6.1 and SQL Server 2000 (both installed on my local box). I've got the correct un and pw for CF to get into the database, but each time I try to set the DSN in CF administrator, it gives me an error saying: Connection verification failed for data source: Localdb []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 Which sounds like it isn't a un/pw problem, but an outright refusal of SQL server to allow the CF app server any connection at all. Am I overlooking something? In CF admin, the info for the DSN is simple - data source name is localdb, name of the database in SQL is localdb, server is localhost, un is sa, and pw has been entered correctly. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222114 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: Trouble connection to local database
Forgot to add, after you do the Service Pack, get the latest updates from Macromedia especially the macromedia_drivers.zip. Sorry do not remember which HotFix it was. Thanks! Looks like DLing and installing Servce Pack 4 was all I had to do - SQL Server DSNs in CF are connecting and validating fine now. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222138 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