Prev Next

ADO Connection

The Connection object in ADO is used to establish a link between your application and a data source. It allows executing queries, commands, and retrieving data.

Key Topics

Creating a Connection

Example

<%
    Dim conn
    Set conn = Server.CreateObject("ADODB.Connection")
    conn.Open "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=MyDatabase;User ID=myUser;Password=myPassword;"
    Response.Write("Database connected successfully.")
    conn.Close
    Set conn = Nothing
%>

Explanation: This example demonstrates establishing a connection to a SQL Server database using the Connection object.

Handling Connection Errors

Example

<%
    On Error Resume Next
    Dim conn
    Set conn = Server.CreateObject("ADODB.Connection")
    conn.Open "Provider=InvalidProvider;Data Source=InvalidSource;"

    If Err.Number <> 0 Then
        Response.Write("Error: " & Err.Description)
        Err.Clear
    Else
        Response.Write("Connected successfully.")
        conn.Close
    End If
    Set conn = Nothing
%>

Explanation: This example demonstrates handling connection errors using On Error Resume Next to display error messages instead of crashing the application.

Key Takeaways

  • ADO connections enable communication with data sources.
  • Always close connections after completing database operations to release resources.
  • Implement error handling to ensure robust database connectivity.
Prev Next