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?
<br>
https://www.connectionstrings.com is a good site for showing different ways of connecting to a db.<br><br>
Also check for any errors. <br><br>
Not working isn't very useful there will be errors in the IIS logs, event log, SQL server logs, etc<br><br>
Make sure you see communication to the SQL server. Check firewalls, etc allow connections through to it.<br><br>
<br><br>
Oh do not use sa as your account to connect up your db setup a less privileged account.<br>
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.
Bes Regards,
Yuk Ding
Yuk Ding
MSDN Community Support
Please remember to "Mark as Answer" the responses that resolved your issue.
20 Posts
classic asp can't connect sql server
Oct 22, 2017 02:06 PM|jimschan|LINK
Hi,
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?
5385 Posts
MVP
Moderator
Re: classic asp can't connect sql server
Oct 22, 2017 11:06 PM|Rovastar|LINK
<br>
https://www.connectionstrings.com is a good site for showing different ways of connecting to a db.<br><br>
Also check for any errors. <br><br>
Not working isn't very useful there will be errors in the IIS logs, event log, SQL server logs, etc<br><br>
Make sure you see communication to the SQL server. Check firewalls, etc allow connections through to it.<br><br>
<br><br>
Oh do not use sa as your account to connect up your db setup a less privileged account.<br>
https://www.leansentry.com/
3743 Posts
Microsoft
Re: classic asp can't connect sql server
Oct 23, 2017 07:17 AM|Yuk Ding|LINK
Hi jimschan,
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.
Bes Regards,
Yuk Ding
MSDN Community Support
Please remember to "Mark as Answer" the responses that resolved your issue.