RE: CFMX Updater 2 to blame?
Bryan, Did you try the usual: 1) Make sure you're using mixed mode authentication on SQL server. 2) Make sure your passwords are not more than 16 chars. 3) Make sure you aren't using (local) as the server etc. Thanks, André PS Good luck with the dating web app! -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 17:59 To: CF-Talk Subject: CFMX Updater 2 to blame? Hey All, I saw a few threads in Google Groups on this, but not enough to solve my problem (Jochem if you're out thereyou helped someone else with the same problem). I'm able to setup SQL2K datasources using Windows Datasource utility just fine, but they don't show in CF Admin. If I try and add them through CF Admin I get this: Connection verification failed for data source: RightStuffDatingDB []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. - The thread I saw referenced a file called jrpatch.jar, but doesn't say where to get it or what to do with it (although I know it's installed with CFMX). So any help would be great because not being able to add datasources is a tad limiting ;-) TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Updater 2 to blame?
I'm able to setup SQL2K datasources using Windows Datasource utility just fine, but they don't show in CF Admin. Are you using SQL Server logins, or Windows Authentication? You have to use SQL Server logins. Are you using default or named SQL Server instances? If you're using named instances, they'll be listening at non-default ports, and you'll have to have installed SQL Server SP2 or higher. Did you specify the IP address and port of the server in the CF Administrator? You can't use Windows machine names, unless they also resolve via DNS. If you post your datasource information, it might help. The jrpatch.jar file just gives you more verbose error information, but you can probably solve your problem without it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Updater 2 to blame?
The diagnostic jar file can be found here: http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602Method=Full chris -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 9:59 AM To: CF-Talk Subject: CFMX Updater 2 to blame? Hey All, I saw a few threads in Google Groups on this, but not enough to solve my problem (Jochem if you're out thereyou helped someone else with the same problem). I'm able to setup SQL2K datasources using Windows Datasource utility just fine, but they don't show in CF Admin. If I try and add them through CF Admin I get this: Connection verification failed for data source: RightStuffDatingDB []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. - The thread I saw referenced a file called jrpatch.jar, but doesn't say where to get it or what to do with it (although I know it's installed with CFMX). So any help would be great because not being able to add datasources is a tad limiting ;-) TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOLVED: Re: CFMX Updater 2 to blame?
Dave helped me offlist... I had to use SQL Server Authentication when setting up the datasource in Windows ODBC. Thanks Dave and all that replied Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Dave Watts [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, March 03, 2003 10:04 AM Subject: RE: CFMX Updater 2 to blame? I'm able to setup SQL2K datasources using Windows Datasource utility just fine, but they don't show in CF Admin. Are you using SQL Server logins, or Windows Authentication? You have to use SQL Server logins. Are you using default or named SQL Server instances? If you're using named instances, they'll be listening at non-default ports, and you'll have to have installed SQL Server SP2 or higher. Did you specify the IP address and port of the server in the CF Administrator? You can't use Windows machine names, unless they also resolve via DNS. If you post your datasource information, it might help. The jrpatch.jar file just gives you more verbose error information, but you can probably solve your problem without it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
