Hi, I have this simple program to access a database in Microsoft SQL Server 2000, the database that i am trying to access is Northwind. But, when i execute the .jsp i get this error:
java.sql.SQLException: [Microsoft] database not found and no driver was specified. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at desisoft_jsp_ch16_01_jsp1179415463593._jspService(desisoft_jsp_ch16_01_jsp1179415463593.java:52) at desisoft.server.JspBaseClass.service(JspBaseClass.java:48) at desisoft.server.servlets.Servlet.service(Servlet.java:86)
I'm not sure what you would put for SQL Server, but I'm sure you could google that answer quite easily.
In addition to that, you will have to create a path to your database. In windows, you'll have to go to your control panel, then ODBC Settings and then create a new data source. [ May 18, 2007: Message edited by: Jason Kwok ]
Joined: Jul 17, 2006
I think Jack did what you call "declarare a driver", right? <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>
Joined: Mar 31, 2005
You're right, I must've missed that. Nice catch!
Joined: May 08, 2006
I had to add the Northwind database in the ODBC Settings, that's the one that was missing.