My project queries and displays data from SQL Server 2005 from some simple views.
I added one column to the view, then tried to update my website.
After entering a known good User ID (from a db table) , Now my login page says ...
ASP Error - SQL Native Client - Invalid Object name 'AnyTable'.
URL=/emplookup/login.asp .... SQL Query Select * from [dbo].[Users] where [User]='myid' and [Password]='mypw'
Note:
-In my project, I can display resuts without a problem
-the website was workign right before this
-the website is set to ASP.NET 2.x and all SPs are loaded
-to top it off, I had to 'reset' 2 pages that had this new column (ugggg!)
-I 'reset' the login page for good measure
-the project was done in 5.2 build 404, and I did upgrade to 5.2 build 423
-i uploaded change, and all file.. but did not erase the directory entirely
I both love and hate this app... can you tell me what i'm doing wrong ?
Paul.
