rs = stmt.executeQuery("SELECT * from Employee"); while ( rs.next() ) { String name = rs.getString("Name"); System.out.println(name); } conn.close();
Now when i run my code the following error comes
"No suitable Driver".i have downloaded oracle drivers(or which driver should i download?) and set them in the class path but still the same problem.Kindly help
So why did you choose that particular page? When I google for "msql" I find several pages for a company that claims to have distributed MSql since 1994, but not that one.
None of those pages mentions JDBC, either, but I only spent 30 seconds researching. I would say don't start writing your program to use MSql until you see what it can do.
Edit: But apparently you already have MSql running on a server somewhere. In that case I would go and talk to the administrator of that server. They should have contacts for MSql. They might already have a JDBC driver as part of their installation. [ July 24, 2008: Message edited by: Paul Clapham ]
Ajay Singh
Ranch Hand
Joined: Jan 04, 2008
Posts: 105
posted
0
thanks everybody for the replies.The database is changed to Ms Sql and now its working fine now:-)