HI
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:

Error Type:
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


Browser Type:
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)

Page:
GET /asp/Homework/lesson9/books1.asp

(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...

can anyone help me?

THX

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.

Thanks for your reply.
I'm using windows authentication & don't have a user name & password configured.
How & where should I create it in the "books" database?

Thx again

CREATE USER (Transact-SQL)

try droping the dbo. from the SQL line

but first check you have the connection string right