Re: [ cf-dev ] Connect cf to mysql

[Dave Phipps]

I always use the username and password used to setup the db.  If you are 
using MX then setting up a MySQL dsn is a piece of cake.  On CF5 it 
requires the ODBC manager extra step.   The host should be set to 
'localhost' I think.

HTH

Dave

At 17:12 3/10/2003 -0800, you wrote:
When creating a data connection for mySQL in the CF administrator, which id
and password do I use? The one I created to admin the database, or a select
restricted user? Also - if the mySQL server is on the same box, the host
name is supposed to be:
---------

(local)

----------

Correct?

I am having issues connecting to a database...

I am getting the error:

-------

*    Connection verification failed for data source: addy
[]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.
-----

  .::d::.

--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]


--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]