SQL AND ASP

Status
Not open for further replies.

Ethan_Hunt

Aspiring Novelist
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 *support.microsoft.com/kb/176380/EN-US/ or
*www.15seconds.com/Issue/001025.htm
 
Status
Not open for further replies.
Top Bottom