Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
MySQL/ColdFusion MX 7 (RESOLVED)
Author: Adkins, Randy
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44517#231592
John, in fact YES I did create an ODBC just not in ColdFusion.
So if we get technical I did the *ODBC* in the Windows Control
Panel to validate the connection information.
Now with that said, instead of me saying *ODBC* in the thread,
The proper term would have been "using the ColdFusion Datasources
To establish a datasource using JDBC". Since the datasource
For MySQL(3.x) as listed in the drop down of selections was not
Working.
By sincerely, I do apologize for the misleading of information
based on *proper terminology*. Again, I do appreciate the assistance
That you provided.
> My apologies John. I had tried both ways using the ODBC using the
> Selection of MySQL(3.x) as well as Other (JDBC).
Again, not to be a pain, but no you didn't set up an ODBC. You set up a
MySQL(3.x) JDBC datasource. Then you set up an Other JDBC datasource
using the mysql connector/j.
Mixing ODBC and JDBC really makes following the thread confusing.
Repeat it with me "I set up a *DSN*" or "a ColdFusion *datasource*".
You did *not* set up an ODBC connection unless you chose "ODBC Socket
when you configured the cf *datasource*.
However, I did use
----- Excess quoted text cut - see Original Post for more -----
Author: John Paul Ashenfelter
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44517#231590
> My apologies John. I had tried both ways using the ODBC using the
> Selection of MySQL(3.x) as well as Other (JDBC).
Again, not to be a pain, but no you didn't set up an ODBC. You set up
a MySQL(3.x) JDBC datasource. Then you set up an Other JDBC datasource
using the mysql connector/j.
Mixing ODBC and JDBC really makes following the thread confusing.
Repeat it with me "I set up a *DSN*" or "a ColdFusion *datasource*".
You did *not* set up an ODBC connection unless you chose "ODBC Socket
when you configured the cf *datasource*.
However, I did use
----- Excess quoted text cut - see Original Post for more -----
Author: ColdFusion
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44517#231568
My apologies John. I had tried both ways using the ODBC using the
Selection of MySQL(3.x) as well as Other (JDBC). However, I did use
the "ODBC" settings within the Control Panel to rule out the issues
Governing the Port, Username, and password for the MySQL Database
Server as well as to confirm that the server was in fact running.
Glad you solved your problem
> Set all access to datasources and with Ips set to connect, resolve.
>
> 10. Create ODBC using "Other" with the following parameters:
BUT YOU DIDN'T SET AN ODBC!!! You created a CF datasource. Every time you
call it an "ODBC" you make troubleshooting more confusing. CF uses, as well
all know, *J*DBC -- and you use the ODBC Socket *JDBC* connection if you
actually need ODBC connectivity.
--
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) ashenfelterj@transitionpoint.com
Author: John Paul Ashenfelter
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44517#231560
Glad you solved your problem
> Set all access to datasources and with Ips set to connect, resolve.
>
> 10. Create ODBC using "Other" with the following parameters:
BUT YOU DIDN'T SET AN ODBC!!! You created a CF datasource. Every time
you call it an "ODBC" you make troubleshooting more confusing. CF
uses, as well all know, *J*DBC -- and you use the ODBC Socket *JDBC*
connection if you actually need ODBC connectivity.
--
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) ashenfelterj@transitionpoint.com
Author: ColdFusion
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44517#231552
For all those who either had attempted to help or are/have
had the same problem, this is how I resolved my issue.
Somewhat drastic but it works just fine now:
1. Removed CFMX 7
2. Removed MySQL 5.0
3. Rebooted machine
4. Re-installed CFMX 7
5. Reinstalled MySQL 5.0
6. Downloaded mysql-connector-java-3.1.12-bin.jar from MySQL.com
7. Extracted the mysql-connector-java-3.1.12-bin.jar file into the following
directory:
D:\CFusionMX7\wwwroot\WEB-INF\lib
8. Rebooted machine.
9. in CFMX Admin, enabled SandBox Security,
Set all access to datasources and with Ips set to connect, resolve.
10. Create ODBC using "Other" with the following parameters:
JDBC URL: jdbc:mysql://localhost:3306/mindkeeper_support
DRIVER CLASS: com.mysql.jdbc.Driver
Database: {database to connect to}
Username: {self-explanatory}
Password: {self-explanatory}
And it authenicated just FINE :-)
Thanks for everyone's HELP!!
|
May 24, 2012
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
