Re: CF 7 and mySql connection proble
That sounds like you've got a connection / driver in place properly, but the database/schema you're referencing ("MyDataSource") doesn't exist, or the user you're connecting as doesn't have rights to it. Given that you're connecting as root, I'd doubt it's the latter. If you start up MySQL from a command prompt, can you do 'use MyDataSource' to verify the database "MyDataSource" exists? -Joe On Jul 6, 2008, at 4:23 PM, Doug Brown wrote: > I have not used mySql in a long time and have also never installed > it on Windows Vista. What am I missing? > > Connection verification failed for data source: MyDataSource > java.sql.SQLException: Syntax error or access violation message from > server: "Unknown database MyDataSource" > The root cause was that: java.sql.SQLException: Syntax error or > access violation message from server: "Unknown database MyDataSource" > > Configuration > > Windows Vista Home premium > CF 7 > MySql version 5.0.26 > Connect J version 3.0.17 > > My datasource is setup as follows > > Datasource Name: MyDataSource > JDBC URL jdbc:mysql://localhost:3306/MyDataSource > Driver Class com.mysql.jdbc.Driver > Driver Name MySQL Connector > USER root > PASSWORD *** > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 7 and mySql connection proble
On Sun, Jul 6, 2008 at 4:23 PM, Doug Brown <[EMAIL PROTECTED]> wrote: > > The root cause was that: java.sql.SQLException: Syntax error or access > violation message from server: "Unknown database MyDataSource" > > My datasource is setup as follows > > Datasource Name: MyDataSource > JDBC URL jdbc:mysql://localhost:3306/MyDataSource My first question would be... is your DATABASE NAME really "MyDataSource"? That's an odd name for a database. Like if you go to the mysql command prompt and type "show databases"... is "MyDataSource" one of them? The error implies that you are connecting without a problem, but that the connection is asking for the database named "MyDataSource" and MySQL says there is no database with that name. Rick -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308655 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF 7 and mySql connection proble
> I have not used mySql in a long time and have also never installed it > on Windows Vista. What am I missing? > I think you may need this. http://kb.adobe.com/selfservice/viewContent.do?externalId=6ef0253 CF7 was a bugger with MySQL. Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308654 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF 7 and mySql connection proble
I have not used mySql in a long time and have also never installed it on Windows Vista. What am I missing? Connection verification failed for data source: MyDataSource java.sql.SQLException: Syntax error or access violation message from server: "Unknown database MyDataSource" The root cause was that: java.sql.SQLException: Syntax error or access violation message from server: "Unknown database MyDataSource" Configuration Windows Vista Home premium CF 7 MySql version 5.0.26 Connect J version 3.0.17 My datasource is setup as follows Datasource Name: MyDataSource JDBC URL jdbc:mysql://localhost:3306/MyDataSource Driver Class com.mysql.jdbc.Driver Driver Name MySQL Connector USER root PASSWORD *** ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308653 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4