Oracle Connection Strings for Classic ASP

Last updated: August 26, 2026.

Classic ASP can connect to Oracle through ADO using an Oracle OLE DB provider or an ODBC system DSN. Install and configure the client provider that matches the IIS application-pool architecture.

Oracle OLE DB provider

<%
Dim connection
Set connection = Server.CreateObject("ADODB.Connection")
connection.Open "Provider=OraOLEDB.Oracle;Data Source=APPDB;" & _
                "User ID=app_user;Password=use-a-secret-store;"
%>

ODBC system DSN

<%
Dim connection
Set connection = Server.CreateObject("ADODB.Connection")
connection.Open "DSN=AppOracle;UID=app_user;PWD=use-a-secret-store;"
%>

Use a least-privilege account, store credentials in protected configuration, test name resolution under the application-pool identity, and require encrypted transport for remote connections.