Women in Technology

Hear us Roar



Article:
  ColdFusion MX on Mac OS X, Part 3
Subject:   Data Source Verification
Date:   2002-12-20 11:20:49
From:   anonymous2
I had very little trouble a setting up the cold fusion server. It works beautifuly... except I can not get the database to connect. I was originally(when I ran CF in virtual pc ) using MS access, but since there was no support in MX I have been trying to make a MySQL database connect with little success.


Where I used a MySQL database named Guestbook I was given an error message:
--------------------------------------
Connection verification failed for data source: Guestbook
[]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.


-----------------------


I would appreciate any suggestions / solutions


Jim

Full Threads Oldest First

Showing messages 1 through 2 of 2.

  • Data Source Verification
    2003-03-04 16:28:13  anonymous2 [View]

    Hey Jim,

    Try guestbook in lower case. For whatever reason, I haven't quite figured out why, but this fixed it for me. I know for a fact that in my db it has capitalized letters (I camelCased it), but I had to enter the datasource in all lower case.

    Hope this helps,
    Daniel
  • Data Source Verification
    2002-12-24 03:05:39  dicklacara [View]

    Jim

    As with the requests for other dbs, I need more specifics.

    What version of MySQL?

    What are the CFM admin settings for the DSN -- URL, Driver, etc.

    Is the MySQL db up and available?

    Did you recycle CFMX after starting the MySQL DB?

    What JDBC driver are you using?

    Can you access the MySQL DB by means other than CF?

    Dick