Conexão do ASP com SQL Server 2000

[DanGust 0]

Olá,Qual a string de conexão do ASP com o SQl Server.Ex: o do ASP com o Access é set conn=server.createobject ("ADODB.Connection") conn.open "Driver={Microsoft Access Driver (*.mdb)}; dbq=" & server.mappath ("bd/bd.mdb")

[cfuser 0]

Veja se serve....<%Dim conn Set conn = Server.CreateObject("ADODB.Connection")conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = Northwind; User Id = sa; Password="If conn.errors.count = 0 Then Response.Write "Connected OK" End If%>