Sub VersionX()
Dim cnn1
Dim strCnn
Dim strVersionInfo
' Open connection.
Set cnn1 = Server.CreateObject("ADODB.Connection")
strCnn = "driver={SQL Server};server=srv;" & _
"user id=sa;password=;database=Pubs;"
cnn1.Open strCnn
strVersionInfo = "ADO Version: " & cnn1.Version & vbCr & _
"DBMS Name: " & cnn1.Properties("DBMS Name") & vbCr & _
"DBMS Version: " & cnn1.Properties("DBMS Version") & vbCr & _
"OLE DB Version: " & cnn1.Properties("OLE DB Version") & vbCr & _
"Provider Name: " & cnn1.Properties("Provider Name") & vbCr & _
"Provider Version: " & cnn1.Properties("Provider Version") & vbCr & _
"Driver Name: " & cnn1.Properties("Driver Name") & vbCr & _
"Driver Version: " & cnn1.Properties("Driver Version") & vbCr & _
"Driver ODBC Version: " & cnn1.Properties("Driver ODBC Version")
Response.Write strVersionInfo
cnn1.Close
End Sub
Call VersionX()
