wood burning stoves 2.0
The moose likes JDBC and Relational Databases and the fly likes Basic SQL Server JDBC problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Basic SQL Server JDBC problem" Watch "Basic SQL Server JDBC problem" New topic

Basic SQL Server JDBC problem

Mike London
Ranch Hand

Joined: Jul 12, 2002
Posts: 1129
I connect to a SQL Server database called "Calendar" with a string like this:
(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
I agree. Here's the link: http://aspose.com/file-tools
subject: Basic SQL Server JDBC problem
It's not a secret anymore!