This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes SQL Exception My SQL ODBC 3.51 Driver Access Denied Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL Exception My SQL ODBC 3.51 Driver Access Denied " Watch "SQL Exception My SQL ODBC 3.51 Driver Access Denied " New topic
Author

SQL Exception My SQL ODBC 3.51 Driver Access Denied

Rajesh Vijaya
Ranch Hand

Joined: Oct 18, 2005
Posts: 48
I'm getting the SQL Exception MySql ODBC 3.51 Driver access Denied.

I using windows xp2 and mysql database. I tried creating both user DSN and system DSN but could not succeed.Any help in this regard is greatly appreciated!

thanks

Rajesh


Rajesh <br /> <br />SCJP1.4 SCWCD1.4 SCBCD 1.3 ,SCDJWS(Preparing..)<br /> <br />There is no free will.It is the phenomenon bound by cause and effect.But there is something behind will which is free---Swami Vivekananda...
Rajesh Vijaya
Ranch Hand

Joined: Oct 18, 2005
Posts: 48
fixed this up,

Before

DriverManager.getConnection("jdbc dbc:mySQLDSN"," "," ");

the error is i left a blank space in the user and password arguments;

just this is working fien

DriverManager.getConnection("jdbc dbc:mySQLDSN","","");


rajesh
 
I agree. Here's the link: http://kickstarter.com/rocket-mass-heater
 
subject: SQL Exception My SQL ODBC 3.51 Driver Access Denied