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 there....you 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=subscribe&forumid=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
