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...


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


Kailash
Reply: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.