SQL AND ASP

Discussion in 'QnA (read only)' started by Aseem Nasnodkar, Dec 11, 2004.

Thread Status:
Not open for further replies.
  1. Aseem Nasnodkar

    Aseem Nasnodkar New Member

    Joined:
    Jan 10, 2004
    Messages:
    255
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Panaji - Goa
    I have installed sql and i want to connect it with asp.
    How do i do tht?
    Do i need to install MyODBC Driver?
     
  2. it_waaznt_me

    it_waaznt_me Coming back to life ..

    Joined:
    Nov 30, 2003
    Messages:
    2,023
    Likes Received:
    10
    Trophy Points:
    38
    Location:
    A bit closer to heaven
    What SQL ..?
    SQL Server or MySQL ...??
     
  3. Ethan_Hunt

    Ethan_Hunt New Member

    Joined:
    Jun 26, 2004
    Messages:
    5,219
    Likes Received:
    10
    Trophy Points:
    0
    Location:
    Bombay, India
    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
     
Thread Status:
Not open for further replies.

Share This Page