I am learning JDBC. When I run a tutorial program I get an error of type: SQLException: No suitable driver. What do I need to do to make the code work?
the error should be with the class.forname line of the code. it happens when the JDBC driver needed to connected to the database is missing hth
Srinivas
sid alam
Greenhorn
Joined: Dec 01, 2001
Posts: 27
posted
0
I have managed to solve my initial problem on the tutrial I was working on. This was with a db connection to MS Access. I have decided to try the tutorial written by Marilyn deQueiroz. I have downloaded mysql but when I run mysql I get an error of type: D:\mysql\bin>mysql.exe ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
Marilyn de Queiroz
Sheriff
Joined: Jul 22, 2000
Posts: 9033
10
posted
0
To activate it, run the program "\mysql\bin\mysqld-nt --standalone"
if you are running Windows NT or Windows 2000. If you are running Win9x use "D:\mysql\bin>mysqld --standalone"
When I use "\mysql\bin\mysql.exe", I get the same error you describe.
Actually the page you are looking at was originally written by Paul Wheaton. [ February 05, 2002: Message edited by: Marilyn deQueiroz ]
Dave Vick
Ranch Hand
Joined: May 10, 2001
Posts: 3244
posted
0
MySQL is much beter than Access... That being said if you really dont like the command line then ther are a few GUIs available for it on the MySQL site. IF you still dont like it and want to go back to Access then what you might have forgotten is to set up a DSN on your computer for the ODBC. And then make sure you're using the JDBC-ODBC bridge. Any more questions let us know...
A forum for JDBC?!? Hey, I think here is one, so I'll move this there - actually I was going to do that at first but then for some reason I started thinking it was a beginner question, but JDBC isn't a beginner topic so here it goes...
0
)
