Website recently moved from IIS 6 to II7 environment. I have intermittent connection issues pulling data from my sql server and was informed by my web provider that my DSNless connection string was the issue? Here is a copy of my current connection string:
set cn=server.createobject("ADODB.CONNECTION")
cst="Provider=SQLOLEDB.1;Password=password;Persist Security Info=True;User ID=user;Data Source=255.255.255.255;Initial Catalog=agenda"
set rs=server.createobject("ADODB.RECORDSET")
cn.open cst
dvar=(date - 30)
rs.open "Select * from agenda where agenda='new' order by eventspandate desc",cn,adOpenStatic
while not rs.eof
if rs("EventSpanDate") > (date - 30) then
response.write "<a href=new.asp?id=" & rs("id") &">" & rs("title2") & "</a><br><img src=images/spacer.jpg width=5 height=8></img><br>"
else
end if
rs.movenext
wend
rs.close
rs.open "Select * from agenda where agenda='new'",cn,adOpenStatic
if rs("EventSpanDate") > (date - 30) <> "" then
response.write "<font size=-7> </font>"
else
end if
rs.close
Can anyone tell me how to change this to a DSN connection and if this most likely is the issue..
Thanks in Advance