RE: [CFTALKTor] Problems setting up Coldfusion MX database

[Lipp, Gord]

Try putting in Admin for username and see if that corrects it. I just dug up the documentation. It is buried in the Release Notes.   (Windows only) You must provide a username for Microsoft Access and ODBC Socket Data Source Names (DSNs), even if the data sources do not require any user authentication. Provide a username as follows: Access DSN - Select the Use Default Username option; OR show the Advanced Settings section and enter a username in the ColdFusion Username field. ODBC Socket DSN - Select the Use Trusted Connection option; OR show the Advanced Settings section and, in the Username field, accept the default username (system) or enter a username. Hope this works.   Gord -----Original Message----- From: Mike [mailto:[EMAIL PROTECTED]] Sent: July 15, 2002 11:06 AM To: [EMAIL PROTECTED] Subject: Re: [CFTALKTor] Problems setting up Coldfusion MX database Hi Gordon,   I actually tried that aswell.  Any other suggestions? ----- Original Message ----- From: Lipp, Gord To: '[EMAIL PROTECTED]' Sent: Monday, July 15, 2002 9:21 AM Subject: RE: [CFTALKTor] Problems setting up Coldfusion MX database Hi Mike   You may want to try checking off the box that says "Use Default Username" if you are using the MS Access driver. That had me scratching my head also.   Regards Gordon Lipp Systems Technician Guelph Public Library http://www.library.guelph.on.ca -----Original Message----- From: Mike [mailto:[EMAIL PROTECTED]] Sent: July 14, 2002 12:13 AM To: [EMAIL PROTECTED] Subject: [CFTALKTor] Problems setting up Coldfusion MX database Hi All,   I recently installed a version of coldfusion MX for testing on my machine.  I was running CF5 with access databases.  I am trying to connect my databases but I keep getting this error   Connection verification failed for data source: (datasource name) []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 databases don't have usernames or passwords?     The databases worked fine with CF5 has anyone else run across this error?   Thanks   Mike