This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com