How do i check for the connectivity

Results 1 to 2 of 2

Thread: How do i check for the connectivity

  1. #1
    Join Date
    Dec 1969
    Posts
    309

    Default How do i check for the connectivity

    I have an asp file that connects to the database. How do i check if the server connectivity is working or not

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: How do i check for the connectivity

    Well, if you connect to a database like this:<BR><BR>On Error Resume Next<BR>Dim objConn<BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR><BR>obj Conn.ConnectionString = "DSN=pubs"<BR>objConn.Open<BR><BR>If Err.Number &#060;&#062; 0 then<BR>Response.Write Err.Description<BR>Else<BR>&#039Connection OK, good to go...<BR>End If<BR><BR>Does this answer your question, or are you asking about Connection Pooling? Perhaps this question belongs in the Database forum? :) Happy Programming!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •