Mismatch error

Sheraz Khan · May 16th, 2007, 08:13 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>

gbianchi · May 16th, 2007, 08:17 AM

hi there...

please please if you post some code you have to point out what type of error you receive or at least the line that is making the fault... anyway I see 2 problems...
first every dim doesn't have the type of variable...
second:

Code:

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

if this is a string, it should had a = between DbStr and the rest...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Sheraz Khan · May 16th, 2007, 10:45 AM

thanks dude its been sorted.i will take care next time

Cheers

Cheers
Sheraz

dparsons · May 16th, 2007, 10:50 AM

Also, this is not .NET code, it is Classic ASP. Please post in the Classic ASP forums ^^

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========