<div>
Hi<br />
<br />
As already suggested to other users I request you to create Tracefiles. This can be used to sort out any issues that happens in the application. For creating tracefiles you can use the FSO (File System Object) method<br />

</div>


Hi

As already suggested to other users I request you to create Tracefiles. This can be used to sort out any issues that happens in the application. For creating tracefiles you can use the FSO (File System Object) method


<div>
asp-&gt;excel (connection errors)
</div>


<div>
sorry, please delete this and previous comments (I was trying to add this thread to my knowledge base) and got confused
</div>


sorry, please delete this and previous comments (I was trying to add this thread to my knowledge base) and got confused

<div>
<div class="content wysiwyg-content">
How to Catch DB connection error in ASP??<br />
This is the code I am using to connect to MS Excel DB.<br />
<br />
Set cnnGetRows = Server.CreateObject(&quot;ADODB<wbr />.Connectio<wbr />n&quot;)<br />
connExcel=&quot;Provider=Micros<wbr />oft.Jet.Ol<wbr />eDb.4.0;Da<wbr />ta Source=&quot;&amp;(url1)&amp;&quot;; Extended Properties=Excel 8.0;&quot;<br />
cnnGetRows.Open connExcel<br />
set rs=server.CreateObject(&quot;ad<wbr />odb.record<wbr />set&quot;)<br />
mysql=&quot;SELECT * FROM project_details&quot;<br />
rs.open mysql,cnnGetRows &nbsp; &nbsp; &nbsp; &lt;--- I am getting CONNECTION ERROR HERE WHEN THE EXCEL SHEET IS OPENED OR IF THE DATABASE IS NOT DEFINED... <br />
<br />
It is showing the usual asp error page and line number, I need to catch this error and display custom message
</div>
</div>


How to Catch DB connection error in ASP??
This is the code I am using to connect to MS Excel DB.

Set cnnGetRows = Server.CreateObject("ADODB.Connection")
connExcel="Provider=Microsoft.Jet.OleDb.4.0;Data Source="&(url1)&"; Extended Properties=Excel 8.0;"
cnnGetRows.Open connExcel
set rs=server.CreateObject("adodb.recordset")
mysql="SELECT * FROM project_details"
rs.open mysql,cnnGetRows       <--- I am getting CONNECTION ERROR HERE WHEN THE EXCEL SHEET IS OPENED OR IF THE DATABASE IS NOT DEFINED... 

It is showing the usual asp error page and line number, I need to catch this error and display custom message

How to Catch DB connection error in ASP??

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.

Web Development

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.

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.