Unanswered: Can't see database based asp pages on localhost
I'm a designer, new to asp and database world, i'm taking a course for designers that teaches how to work with asp through dreamweaver (dw) tools (i'm not a programmer).
I'm using sql server express 2008 and defined everything as i should in IIS & ODBC, & i know for sure i did everything right, cause i did the same at class & everything worked, and yet at home i keep on getting this annoying message when i'm trying to see an asp page with dynamic table on the localhost:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "books" requested by the login. The login failed.
/asp/Homework/lesson9/books1.asp, line 9
Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
(line 9 = rs_books_cmd.CommandText = "SELECT * FROM dbo.books")
I have no problem seeing other asp pages that don't have database in them, & have no clue why & how to solve it...
It's telling you that you're using the wrong username/password in your connection string to the database, or, alternately, you have not created a user account in the "books" database for the login you're using in your connection string.
but first check you have the connection string right
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.