I am a newbie to jdbc.The problem i am facing is i do not know what to use ie "string value" to load a driver in the Class.forname() method and the String to put in the DriverManager.getConnection() methods.
I have installed mysql server 5.1 and its working fine.I have also set the dsn as "MyDSN" and its driver is mentioned as "MySql ODBC 5.1 Driver".
presently there are 3 databases in db server:mydb,mysql,first.
If i have to use any one of these databases then what should my previously asked values be.
In host,for localmachine use localhost and for other machine use that machine ipaddress
database_name--the database which you want to establish connection.
userName-->userName for the database
password-->password for the same.