I want to create a dynamic website with a database. Visual studio 2010, dreamweaver CS5, sql server management studio and all other requirements are installed (like IIS 7). I set the IIS server configuration in dreamweaver cs5. I check simple ASP codes like <%Response.Write ("The time on the server is: " & Time())%> in dreamweaver and its working fine. I created a database using sql sever management studio and then in dreamwever, I added the database through "custom connection string". Test connection was fine. Even i can see the data in database panel in dreamweaver.
Then I set the "recordset" using "Bindings" panel in dreamweaver, then i check in "live view" and it shows an error message like
Microsoft OLE DB Provider for SQL Server error '80004005'
Cannot open database "newdb2" requested by the login. The login failed.
/index.asp, line 9
my ASP page is like this...
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <!--#include file="Connections/con1.asp" --> <% Dim Recordset1 Dim Recordset1_cmd Dim Recordset1_numRows Set Recordset1_cmd = Server.CreateObject ("ADODB.Command") Recordset1_cmd.ActiveConnection = MM_con1_STRING Recordset1_cmd.CommandText = "SELECT * FROM dbo.vehicle" Recordset1_cmd.Prepared = true Set Recordset1 = Recordset1_cmd.Execute Recordset1_numRows = 0 %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <% Response.Write ("The time on the server is: " & Time()) %> </body> </html> <% Recordset1.Close() Set Recordset1 = Nothing %>
What is wrong with????
Can anyone help me??