SQL AND ASP

[Aseem Nasnodkar]

I have installed sql and i want to connect it with asp.
How do i do tht?
Do i need to install MyODBC Driver?

[it_waaznt_me]

What SQL ..?
SQL Server or MySQL ...??

[Ethan_Hunt]

Well Assumig That Ur's Is a Sql Server Then use this code To try Connecting to Ur ASP

Dim objConn, objRS
Set objConn = server.CreateObject("ADODB.Connection")
set objRS = server.CreateObject("ADODB.Recordset")

objConn.Provider = "SQLOLEDB.1"
objConn.Properties("Persist Security Info").Value = "False"
objConn.Properties("User ID").Value = "WebUser"
objConn.Properties("Password").Value = "password"
objConn.Properties("Initial Catalog").Value = "MovieMSDE"
objConn.Properties("Data Source").Value = "ZBOROWSKI"

objConn.Open

See if this works.....
Or try This Link for A little help http://support.microsoft.com/kb/176380/EN-US/ or
http://www.15seconds.com/Issue/001025.htm