The username you need is "Admin" (without quotes) - and no password. This is the default for any Access database.
The system database is used for data specific authentication - I don't see many people using this option though. Typically they'll go to Oracle/SQL Server or something similar if they need that level of authentication and multi user capabilities. HTH Shawn Grover -----Original Message----- From: Ryan Kime [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 10:17 AM To: CF-Talk Subject: RE: [SOT] Is MM painting itself into a corner? >It's an access database with no username or password. Even so.....try putting "system" (without the quotes of course) in as the username. -----Original Message----- From: Brockman, Chuck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 8:28 AM To: CF-Talk Subject: RE: [SOT] Is MM painting itself into a corner? Has anyone experienced this error with CFMX running on NT4 service pack 6a. I upgraded the mdac and jet to the latest version. It's an access database with no username or password. I get this error every time I try and create a DSN. Connection verification failed for data source: datasourcename []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. Thank you. Chuck ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
