Can someone shed some light on this JDBC issue for me?
I am using the default Northwind database in SQL Server 7.
I am using the dbo user with full access.
The problem is that when I run a query on the Employees table I get the
following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'Employees'
Code follows:
----------------------
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")
String url = "jdbc:odbc:Northwind";
String user = "sa";
String pw = "";
con = DriverManager.getConnection(url,user,pw);
stmt = con.createStatement();
String query = "SELECT * FROM Employees";
rs = stmt.executeQuery( query );
----------------------
The code is right as far as I can tell. I get no errors with the Connection
or Statement objects.
Is there some problem with using the jdbc:odbc bridge for SQL Server that I
dont know about?
Thanks,
Kyle Burke
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
