• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Basic SQL Server JDBC problem

 
Mike London
Ranch Hand
Posts: 1208
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I connect to a SQL Server database called "Calendar" with a string like this:
"jdbc:microsoft:sqlserver://DellPC:1433;"+
"Database=Calendar;User=test;Password=test";
(Note I specify the database here -- Calendar)
Then, after making sure the permissions are correct (can log into the calendar database from Query Analyzer and do a select on the same table the code below tries to do), I try to do a select on the users table in this database like this:
SQL = "SELECT COUNT(*) as Count FROM " +
"users where use_loginID = " + login + " AND " + "use_password = " + password +";";
(login and password values came from an HTML form)
However, when I executeQuery() I get the error:
"Invlid Object name users".
Any ideas what's wrong here?
Thanks in advance.
-- Mike
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic