RE: Setting up MySql Data Source
No, just get the ConnectorJ download from MySQL and it will work just fine. I've got it running with this package on 12 different sites in MX, MX 6.1, and MX 7. --Ferg -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 3:47 PM To: CF-Talk Subject: Re: Setting up MySql Data Source Irvin Gomez <[EMAIL PROTECTED]> wrote: > http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253 Will this affect (i.e. kill) my ability to continue to run CF and mySQL 4.0? -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200291 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Setting up MySql Data Source
I don't honestly know, since I first installed MySQL about 2 months ago (v4.1). The process was very straightforward with the "Windows Essentials" package. I folloed the instructions on that page and everything is working without a hitch. Sorry I can't be of more help :-) >Irvin Gomez <[EMAIL PROTECTED]> wrote: >> http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253 > >Will this affect (i.e. kill) my ability to continue to run CF and mySQL 4.0? > >-- >--mattRobertson-- >Janitor, MSB Web Systems >mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Setting up MySql Data Source
Irvin Gomez <[EMAIL PROTECTED]> wrote: > http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253 Will this affect (i.e. kill) my ability to continue to run CF and mySQL 4.0? -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200276 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Setting up MySql Data Source
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253 > I just loaded MySql to my development machine. I have MySql up and > running and even created the database I will be using. I am trying to > set up a DSN in CFAdmin but it keeps failing. Since this is a > non-server machine do I have to change the port? > > my error > > Connection verification failed for data source: bvhdku > []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 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Setting up MySql Data Source
Go to mysql and download the ConnectorJ. I've found that to be the only really reliable connection method. -Original Message- From: Matt Osbun [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 12:42 PM To: CF-Talk Subject: RE: Setting up MySql Data Source I ran into this problem a few months ago, unfortunately at a previous job, so I don't have access to all my documents/notes/DL'd files for fixing this. Basically though, if you are using a version of MySQL later than (I think) 4.0, you may need to download a different connector than what CF6.1 provides pre-packaged. Try downloading the lastest from http://dev.mysql.com/downloads/connector/ and following the instructions at http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19170 Hope this helps Matt Osbun Web Developer Health Systems, International -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 1:12 PM To: CF-Talk Subject: Re: Setting up MySql Data Source Actually I checked the port at 3306 and that appears fine. I am using localhost for the server setting? Should I use something else? > I just loaded MySql to my development machine. I have MySql up and > running and even created the database I will be using. I am trying to set up a DSN in CFAdmin but it keeps failing. Since this is a non-server machine do I have to change the port? > > my error > > Connection verification failed for data source: bvhdku > []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 > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200251 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Setting up MySql Data Source
I ran into this problem a few months ago, unfortunately at a previous job, so I don't have access to all my documents/notes/DL'd files for fixing this. Basically though, if you are using a version of MySQL later than (I think) 4.0, you may need to download a different connector than what CF6.1 provides pre-packaged. Try downloading the lastest from http://dev.mysql.com/downloads/connector/ and following the instructions at http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19170 Hope this helps Matt Osbun Web Developer Health Systems, International -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 1:12 PM To: CF-Talk Subject: Re: Setting up MySql Data Source Actually I checked the port at 3306 and that appears fine. I am using localhost for the server setting? Should I use something else? > I just loaded MySql to my development machine. I have MySql up and > running and even created the database I will be using. I am trying to set up a DSN in CFAdmin but it keeps failing. Since this is a non-server machine do I have to change the port? > > my error > > Connection verification failed for data source: bvhdku > []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 > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200241 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Setting up MySql Data Source
Actually I checked the port at 3306 and that appears fine. I am using localhost for the server setting? Should I use something else? > I just loaded MySql to my development machine. I have MySql up and running and even created the database I will be using. I am trying to set up a DSN in CFAdmin but it keeps failing. Since this is a non-server machine do I have to change the port? > > my error > > Connection verification failed for data source: bvhdku > []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 > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200227 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Setting up MySql Data Source
I just loaded MySql to my development machine. I have MySql up and running and even created the database I will be using. I am trying to set up a DSN in CFAdmin but it keeps failing. Since this is a non-server machine do I have to change the port? my error Connection verification failed for data source: bvhdku []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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200226 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54