[asp] ASP 連DB by TLS1.2~

ODBC Driver 版本 可以檢查新增移除程式畫面

<%
set cnn2 = Server.CreateObject("ADODB.Connection")
cnn2.Open "driver={ODBC Driver 13 for SQL Server};database=test;server=servername;uid=sa;pwd=0000"

Response.write("abc<br/>def")

sql = "select * from master..spt_values"

set rs= Server.CreateObject("ADODB.RecordSet")
Response.write("<br/>ghi<br/>jkl<br/>")
rs.Open sql,cnn2 ,1,1

Response.write("spt_values rows:"&rs.recordcount&"<br/><br/>")

%>