ASP + JET + VStudioSP6 + bug - half solution yet !!!

Discussion in 'ASP General' started by SARINGER Zoltán, Aug 24, 2004.

  1. Hello!

    Shortly: I have a simple Jet OLEDB query using "LIKE" operator, which works
    from VB, Access, WSH, etc.., but DOES NOT from ASP page.
    (As my earlier thread in asp newsgroup I wrote my strange problem, see: ASP
    ..mdb ADO OLE automation error - but works in access!"

    I had not any solution, I've begun to install every software from the
    begining, and checked, when the error will occour. My system is:

    - W2000 (HUN) SP4, and all security patches...
    - Visual Studio 6 enterpr.

    .... after installing Visual Studio _Service_Pack_6_ the bug came:

    OLE automation error 80040E14.

    the code:

    <!-- #include file="adovbs.inc" -->
    <%
    Dim str_conn
    Dim cn
    Dim rs

    set cn=server.createobject("ADODB.Connection")
    str_conn = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database
    Password=;Data Source=g:\vb60\autoflex-feladatutemezo\db\feladat.mdb;"
    cn.Open str_conn

    set rs=server.CreateObject("ADODB.Recordset")
    rs.open "SELECT * FROM feladat WHERE megjegyzes LIKE '%abcd%' ",cn

    set rs=nothing
    set cn=nothing
    %>

    What is this?????
    reinstalling VS SP5 or SP6 doesnt solve the problem. Installing JET SP8, and
    MDAC 2.8 doesnt solve the problem also...!

    Waiting for your reply,
    thank you,
    Zoltan
     
    SARINGER Zoltán, Aug 24, 2004
    #1
    1. Advertising

  2. SARINGER Zoltán wrote:
    >
    > What is this?????
    > reinstalling VS SP5 or SP6 doesnt solve the problem. Installing JET
    > SP8, and MDAC 2.8 doesnt solve the problem also...!
    >


    Have you tried uninstalling SP6?

    You are not the only one to encounter issues with SP6. You should contact MS
    Product support. This definitely sounds like a bug so you will not be
    charged for the call.

    Bob Barrows

    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.
     
    Bob Barrows [MVP], Aug 24, 2004
    #2
    1. Advertising

  3. Re: solution!!!!!!!

    asdf wrote:
    > thank you!
    >
    > searching on google.. i found a news-letter what describes problem
    > about IIS on W2k server with VS 6 SP6.
    >
    > the solution is: add read/execute permission to IWAM_computername
    > user to file: mfc42.dll
    >
    > yeah.., who would think it??????? (this is the reason of OLE
    > atomation error using LIKE...)


    Thank you! I will make a note of this. Aaron? Could this be added to a FAQ?

    Bob barrows

    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.
     
    Bob Barrows [MVP], Aug 25, 2004
    #3
  4. SARINGER Zoltán

    asdf Guest

    solution!!!!!!!

    thank you!

    searching on google.. i found a news-letter what describes problem about IIS
    on W2k server with VS 6 SP6.

    the solution is: add read/execute permission to IWAM_computername user to
    file: mfc42.dll

    yeah.., who would think it??????? (this is the reason of OLE atomation error
    using LIKE...)
     
    asdf, Aug 25, 2004
    #4
  5. SARINGER Zoltán

    ¹Ú¹®¼ö Guest

    "Bob Barrows [MVP]" <> wrote in message
    news:...
    > SARINGER Zolt? wrote:
    > >
    > > What is this?????
    > > reinstalling VS SP5 or SP6 doesnt solve the problem. Installing JET
    > > SP8, and MDAC 2.8 doesnt solve the problem also...!
    > >

    >
    > Have you tried uninstalling SP6?
    >
    > You are not the only one to encounter issues with SP6. You should contact

    MS
    > Product support. This definitely sounds like a bug so you will not be
    > charged for the call.
    >
    > Bob Barrows
    >
    > --
    > Microsoft MVP -- ASP/ASP.NET
    > Please reply to the newsgroup. The email account listed in my From
    > header is my spam trap, so I don't check it very often. You will get a
    > quicker response by posting to the newsgroup.
    >
    >
     
    ¹Ú¹®¼ö, Aug 27, 2004
    #5
  6. SARINGER Zoltán

    ¹Ú¹®¼ö Guest

    "¹Ú¹®¼ö" <anstn1269> wrote in message
    news:uh2NJx#...
    >
    > "Bob Barrows [MVP]" <> wrote in message
    > news:...
    > > SARINGER Zolt? wrote:
    > > >
    > > > What is this?????
    > > > reinstalling VS SP5 or SP6 doesnt solve the problem. Installing JET
    > > > SP8, and MDAC 2.8 doesnt solve the problem also...!
    > > >

    > >
    > > Have you tried uninstalling SP6?
    > >
    > > You are not the only one to encounter issues with SP6. You should

    contact
    > MS
    > > Product support. This definitely sounds like a bug so you will not be
    > > charged for the call.
    > >
    > > Bob Barrows
    > >
    > > --
    > > Microsoft MVP -- ASP/ASP.NET
    > > Please reply to the newsgroup. The email account listed in my From
    > > header is my spam trap, so I don't check it very often. You will get a
    > > quicker response by posting to the newsgroup.
    > >
    > >

    >
    >
     
    ¹Ú¹®¼ö, Aug 27, 2004
    #6
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    2
    Views:
    5,821
    Paul Clement
    Dec 30, 2005
  2. Berehem
    Replies:
    4
    Views:
    564
    Lawrence Kirby
    Apr 28, 2005
  3. trint
    Replies:
    4
    Views:
    708
    =?ISO-8859-1?Q?G=F6ran_Andersson?=
    Sep 11, 2007
  4. joe chesak
    Replies:
    7
    Views:
    290
    (r.*n){2}
    Sep 23, 2010
  5. Mike Ballard
    Replies:
    6
    Views:
    273
    Dr.Ruud
    Nov 15, 2005
Loading...

Share This Page