How do I connect to an SQL database that is on an intranet network through ASP?

If I wanted to connect to a standard Access database I would use:





Set adoCon = Server.CreateObject("ADODB.Connection")





adoCon.Provider="Microsoft.Jet.OLEDB.4...


adoCon.Open "LOCATION OF DATABASE"





If i know the table name how would I connect to a an SQL database.

How do I connect to an SQL database that is on an intranet network through ASP?
data source=(local);database=..


istead of "(local)" use server DNS or IP
Reply:http://www.connectionstrings.com/?carrie...

botanical garden