Gyrus I had a very similar problem--hosting company had error, fine for me locally. I had the database name and datasource with a MX at end to distinguish between new and old versions: MyBaseMX.mdb and datasource of Bi.MyBaseMX. Strange as it may seem, I took off the X on each (MyBaseM.mdb and Bi.MyBaseM) and all set up fine! Maybe try a different name. Doesn't make any sense, but worked in my situation! (Maybe MX didn't like any competition!)
E. Keith Dodd Wings of Eagles Services www.wingserv.com ----- Original Message ----- From: "Gyrus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 28, 2003 10:30 AM Subject: SQLException occurred in JDBCPool" for Access DB with password > My host is setting me up on a test MX server prior to porting a site over to > their main MX box. They keep getting this message when trying to set up the > datasource (Access 2000 DB): > > Connection verification failed for data source: norlonto > []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. > > >From searching around, I gather other people have had this problem too. One > guy I found solved it by repairing his Win2K server installation and > rebooting. So I was ready to get high and mighty with my host, but they tell > me they have 15 sites with datasources up and running fine already, it's > only mine causing the problem. > > They're telling me to take the password of the DB, which I'm playing along > with for want of anything better to do. Maybe that'll get it working - but > surely something is wrong with their MX installation if it can't work with > Access DB's with passwords? Is this an issue that the updaters resolved? > > FWIW the DB has always run without problem on my local MX dev server. > > Gyrus > [EMAIL PROTECTED] > work: http://www.tengai.co.uk > play: http://norlonto.net > PGP key available > - [This E-mail scanned for viruses by declude AntiVirus Software] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 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
