Asp/VB Script Source Codes

Data MSSQL Connection

Example how to connect to MS SQL server database

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">

<title>MS SQL CONNECTION TEST</title>
</head>

<body>

<%
set rs = server.createobject("ADODB.Recordset")

DsnWebSQL = "Provider=SQLOLEDB;Server=128.121.4.12;Database=DataName;UID=user;PWD=password;"

rs.CursorLocation = 3
timer1 = timer
response.write "beginning time=" & timer1 & "
"
rs.Open "SELECT top 20 * FROM TableName", DsnWebSQL

timer2 = timer
response.write "time to select record=" & (timer2 - timer1) & "
"
Do While rs.EOF = False
response.write "
" & rs.Fields(1)
rs.MoveNext
Loop

response.write "
time to fetch " & rs.recordcount & " records =" & timer - timer2

rs.close
set rs = nothing
%>

</body>

</html>

<<<----- Return to Asp/VB Script Source Code Questions Page.

Have a Question ? post your questions here. It will be answered as soon as possible.