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

2 ⤊

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.0"
adoCon.Open "LOCATION OF DATABASE"

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

2007-02-26 07:01:47 · 2 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design

2 answers

data source=(local);database=..
istead of "(local)" use server DNS or IP

2007-02-26 07:18:06 · answer #1 · answered by Maysam 4 · 1⤊ 0⤋

http://www.connectionstrings.com/?carrier=sqlserver

2007-02-26 08:35:17 · answer #2 · answered by Kryzchek 4 · 1⤊ 0⤋