asp connection to SQL server DB

[rjlorenzo]

Good Day,

Just want to ask some help please, currently I'm using MS Access as my database but now I would like to use SQL DB as my database. Could anyone help me how to convert my connection string from ms access to sql db. below is my connection on ms access please do modification to work it on SQL. Many thanks in advance.

<%
    dim strConn 
    strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& server.MapPath("bts_db.mdb") &";Persist Security Info=False;Jet OLEDB:Database Password = prs"
    function get_recordset(byval strSQL, byref recset)
        on error resume next
        set recset =  Server.CreateObject("ADODB.Recordset")
        recset.open strSQL, strConn, 3
        if err.number <> 0 then
            Response.Write err.Description & "<br>"
            Response.Write err.Source & "<br>"            
            Response.Write strSQL
            Response.End
        end if
        get_recordset = recset.recordcount
    end function
 
    sub Execute_Query (byval strSQL)
        on error resume next
        dim con
        Set con = Server.CreateObject("adodb.Connection")
        con.open strConn
        con.BeginTrans
        con.execute strSQL
        if err.number <> 0 then
            Response.Write err.Description & "<br>"
            Response.Write err.Source & "<br>"
            Response.Write strSQL & "<br>"
            Response.End
            con.RollbackTrans
        else
            con.CommitTrans
        end if
        Set con = nothing
    end sub
%>

[jeffstl]

http://www.connectionstrings.com/