MS SQL Connection Help

[anon47]

Ok first sql is new to me. I am trying to get an asp page to connect to the the server but am having problems. Any thought on this would be great.

<%
dim conn, rs, sql, intTelephone, intMobile
connectstr = "Provider=SQLOLEDB;DATABASE=AS_Data;SERVER=SQLEXPRESS; Integrated Security=SSPI;"

sql = "SELECT * FROM [Projects]"
rs.Open
%>

 

[anon47]

One more thing its giving this error:

HTTP Error 403.2 - Forbidden: Read access is denied.
Internet Information Services (IIS)

Thanks for all your help in advance

 

[AlexCuse]

try forum333

I don't do any programming whatsoever

Ignorance of certain subjects is a great part of wisdom

 

[anon47]

Thanks Alex I think it going to be a permission issue via SQL Express but not for certain