How to connect to a microsoft sql server if you are using asp?

I am teaching myself asp programming. I now want to ask the codes man can incorporate into his asp codes so that his sql server can be seen on the net. thank you.How to connect to a microsoft sql server if you are using asp?
%26lt;%


dim con, rs


set con=server.CreateObject(';adodb.connectio鈥?br>

con = ';Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=database name;Data Source=(local)';


str=';select * from pims_event';


rs.open str, con, 1, 2


%%26gt;





Even you can learn ASP, SQL Server from http://www.w3schools.com This is very useful site for Beginner...





Thanks


KailashHow to connect to a microsoft sql server if you are using asp?
Usually you use ADO which is ActiveX Data Objects if using ASP. If you are using ASP.NET then you use ADO.NET. Basically they are a set of objects used to connect to databases. I would look for tutorials on using ADO.