Type Mismatch error

Sheraz Khan · May 16th, 2007, 08:12 AM

Can someone help me out to fiind what i m doing wrong in the code bellow....

<HTML>
<head>

    <title>MY First Page</title>

</head>

    <body>

    <%
        dim con
        dim rs
        dim DBstr
        dim conStr

    Set Con = Server.CreateObject("ADODB.Connection")

    DBStr "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &_
    "D:\ASP Databases\student.mdb" & ";"

    con.ConnectionString = DBstr
    con.open

    Response.write = "connection is successfull"

    Con.close
    Response.write = "connection is closed"

        %>

</body>

</HTML>