<div>
<div class="content wysiwyg-content">
I'm developing an application that connects to a local SQL Server database via IP address. &nbsp;The application is working fine but I would like to add a function that checks to make sure the connection is available and if the connection is not available (&quot;SQL Server does not exist or access denied&quot;) then I'd like it to be able to redirect to a custom page to notify the visitor. &nbsp;Here is the connection string I'm using within an include page.<br />
<br />
Set ConnSQL_STRING = Server.CreateObject(&quot;ADODB<wbr />.Connectio<wbr />n&quot;)<br />
ConnSQL_STRING.open &quot;Provider=sqloledb;Data Source=XX.XX.XX.XXX,1433;N<wbr />etwork Library=DBMSSOCN;Initial Catalog=store2;User ID=xxxx;Password=xxxxxx;&quot;
</div>
</div>


I'm developing an application that connects to a local SQL Server database via IP address.  The application is working fine but I would like to add a function that checks to make sure the connection is available and if the connection is not available ("SQL Server does not exist or access denied") then I'd like it to be able to redirect to a custom page to notify the visitor.  Here is the connection string I'm using within an include page.

Set ConnSQL_STRING = Server.CreateObject("ADODB.Connection")
ConnSQL_STRING.open "Provider=sqloledb;Data Source=XX.XX.XX.XXX,1433;Network Library=DBMSSOCN;Initial Catalog=store2;User ID=xxxx;Password=xxxxxx;"

Detect Database Connection and redirect if broken

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.