I'm trying to connect to mySQL using a servlet and the sun.jdbc.odbc.JdbcOdbcDriver. I think the driver is found but i get the message 'no suitable driver' when i try: DriverManager.getConnection("jdbc:mySQL://localhost:3306/test"
There are two ways to work it around.
1. Use mm.mysql driver and set CLASSPATH properly. But it may cause some problem with the javac.
2. Use MyODBC as driver. set up DNS and database source and leave other fields blank. Then use DriveManager.getConnection("jdbcdbc:test" where "test" is the DNS name.
That is all I can help now. I am trying to figure out some other ways by myself.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.