Question : asp classic connect to database
Answered by : graceful-grouse-orijfptjxsr4
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = Northwind; User Id = sa; Password="
If conn.errors.count = 0 Then
Response.Write "Connected OK"
End If
%>Source : https://stackoverflow.com/questions/1569303/how-to-connect-to-a-sql-database-using-classic-asp | Last Update : Wed, 27 May 20