Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Invalid Object Name

 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello
I am working on a web application which involves MS SQL Server 7.0 at the backend.
I am also using the jdbc-odbc bridge to connect to the database.
The database has a table called PersonalProfile.
The JSP goes like this : -
<HTML>
<TITLE>Data Base testing</TITLE>
<BODY>
This is the list of employees
<%@ page import="java.sql.*, java.util.*, java.net.*, java.io.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");<br /> String url = "jdbc dbc:dbEIS";<br /> String user=null;<br /> String password = null;<br /> Connection con = DriverManager.getConnection(url, user, password);<br /> Statement stmt = con.createStatement();<br /> String Query = "Select FirstName from Administrator.PersonalProfile";<br /> <br /> ResultSet rs = stmt.executeQuery(Query);<br /> while (rs.next()) {<br /> %>
<%= rs.getString(1); %>



<% } %>
</BODY>
</HTML>
This is giving me an error that "Invalid Object Name PersonalProfile". I have checked that there is a table called PersonalProfile in the database dbEIS.
Please help me. I am stuck.
Dmitri
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic