connecting to an access database
i have a servlet that is trying to connect to an access database and read the data within it. when i run the server i get this error:-
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
i have set up the data source name in the ODBC Data Sources settings in windows NT control panel, and when i run the program as a stand alone java program (not as a servlet) it gets the data from the database without any errors.
I am using Netscape iplanet web server to run the servlets and this is the java code i am using:-
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:first_test");
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT * FROM Names");
