Check Domain Name


SQL connectivity script using ASP

The following ASP sample script Code allows you connect to SQL Database

In the code given below the DSN Name is sql123, Database is Shabbier, Username
and Password is Shabbier.

Note : Users are requested to change the above said parameters with their respective
DSN, Username and Password.

<html>

<body>

<%

set con=server.CreateObject("ADODB.connection")

con.Open "dsn=sql123;database=shabbier","shabbier","shabbier"

set rs=server.CreateObject("ADODB.recordset")

rs.Open "select * from sample",con,1,3

while(not rs.EOF)

for i=0 to rs.RecordCount

Response.Write rs(i) & ":"

next

Response.Write "<br>"

rs.MoveNext()

wend

%>

</body>

</html>

Visit Indian SEO for Search Engine Optimization Website
Maintenance Services Bangalore India
Visit indianattire.com for Indian attire
Copy Right 2001 - 2005 All Rights Reserved Terms and Conditions