IIS 5 & IIS 6
classic asp can't connect sql server
Last post Oct 23, 2017 07:17 AM by Yuk Ding
Oct 22, 2017 02:06 PM|jimschan|LINK
I'm testing this code to connect sql server, but the page didn't savethe data to sql server. Is there any configuration that I need to set to enable the connection?
<form name="Form" action="*.asp" method="post">
<input name="Name" type="text"><br>
<input name="Password" type="password"><br>
sql ="select * from table-name "
Oct 22, 2017 11:06 PM|Rovastar|LINK
Oct 23, 2017 07:17 AM|Yuk Ding|LINK
I didn't find any error which is related to the display of database data in form. So maybe you need to check the connections between IIS and sql server. Just ensure your connection string could be accessed. Please check sql server authentication log could
help you fix this issue. In IIS, you should not require to configure anything unless you need to use IIS connection string.