• Post Reply Bookmark Topic Watch Topic
  • New Topic

Invalid Object Name

Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 : -
<TITLE>Data Base testing</TITLE>
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); %>

<% } %>
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.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!