<% 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 [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <#ccAT5giEHA.596@TK2MSFTNGP11.phx.gbl> [ref] => [htmlstate] => on_nl2br [postusername] => SARINGER [ip] => kecskemetisrac@ [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 1 [islastshown] => [isfirstshown] => 1 [attachments] => [allattachments] => ) --> ASP + JET + VStudioSP6 + bug - half solution yet !!! - ASP Database
Professional Web Applications Themes

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

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 ...

  1. #1

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

    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 Guest

  2. #2

    Default Re: ASP + JET + VStudioSP6 + bug - half solution yet !!!

    SARINGER Zolt嫕 wrote: 

    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 Guest

  3. #3

    Default Re: solution!!!!!!!

    asdf wrote: 

    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 Guest

  4. #4

    Default 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 Guest

  5. #5

    Default Re: ASP + JET + VStudioSP6 + bug - half solution yet !!!


    "Bob Barrows [MVP]" <SPAMcom> wrote in message
    news:phx.gbl... 
    >
    > Have you tried uninstalling SP6?
    >
    > You are not the only one to encounter issues with SP6. You should contact[/ref]
    MS 


    夢僥熱 Guest

  6. #6

    Default Re: ASP + JET + VStudioSP6 + bug - half solution yet !!!


    "夢僥熱" <anstn1269> wrote in message
    news:uh2NJx#phx.gbl... 
    > >
    > > Have you tried uninstalling SP6?
    > >
    > > You are not the only one to encounter issues with SP6. You should[/ref][/ref]
    contact 
    >
    >[/ref]


    夢僥熱 Guest

Similar Threads

  1. animation stops half way through
    By joned webforumsuser@macromedia.com in forum Macromedia Flash Sitedesign
    Replies: 0
    Last Post: October 30th, 02:34 PM
  2. Half or One Gig
    By Colin Walls in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 8
    Last Post: July 3rd, 03:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139