This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I am trying to connect to MS Access DB through a jsp, but i get following error "java.sql.SQLException: No suitable driver " JSP Code -------- <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String dataSourceName = "mdbTEST"; String dbURL = "jdbcdbc:" + dataSourceName; java.sql.Connection connection = java.sql.DriverManager.getConnection(dbURL); %>
but when i write a stand alone java application with the same code and run it, it works fine Stand Alone Java application code ---------------------------------- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String dataSourceName = "mdbTEST"; String dbURL = "jdbcdbc:" + dataSourceName; Connection con = DriverManager.getConnection(dbURL);
I've used MS Access with JSP's/Servlets. I had a similar problem with the jar's.
Two points to note: 1/Use a proper database i.e. MySQL or something rather than MS Access 2/I connected to MS Accees by going to Control Panel --> Administartive tools --> Datasources (ODBC) - click on this then add on the system tab and add your datasource, this should work.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: JSP connection to MS Access DB - No suitable driver exception