Re: ASP .mdb ADO OLE automation error - but works in access!

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 08/22/04 

Date: Sun, 22 Aug 2004 09:05:06 -0400

SÁRINGER Zoltán wrote:
> First, thank you for your replies...!
>
> I've put onto web the screenshots:
>
> http://www.optinfo.hu/helpme/ie_err.jpg (hungarian message in IE
> about the 500.x http error, and error number)
> http://www.optinfo.hu/helpme/jet_like_error.jpg (debug screen in
> Interdev, on the line: rs.open "SELECT...")
>
> the connectionstring is:
>
> str_conn = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database
> Password=;Data Source=g:\vb60\autoflex-feladatutemezo\db\feladat.mdb;"

If g: is a mapped network drive, your IUSR account will probably not be able
to find it. You should use the UNC nomenclature in that case. Also, you need
to force this website to run under a domain account instead of the default
local IUSR account. Based on your below statement that changing "LIKE" to
"=", I doubt that this is your problem, In fact, I've probably wasted my
time typing this, since if this was a problem, you would be talking to us
about connection failure instead of OLE Automation Error ....

>
> Everything else are the defaults. Really, if I change "LIKE" to
> "equal" it works. This is a very simple code!!!! What do you
> recommend? Why doesnt work this simple query in ASP, what is the
> difference using the same ADODB component in VB6 or in ASP? (How can
> I ensure that ASP uses ADO 2.8.. (in VB6 I can select in the
> referencies, but in ASP...?)
>
> waiting for your suggestions...
> Zoltan

Everything I've found about this error indicates a problem with your MDAC
installation. Go to the microsoft site and download the Component Checker
which will verify the problem (mismatched dll's). The fix will depend on
your operationg system.

Bob barrows 

-- 
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Relevant Pages

  • Re: ASP .mdb ADO OLE automation error - but works in access!
    ... is a mapped network drive, your IUSR account will probably not be able ... about connection failure instead of OLE Automation Error ... Go to the microsoft site and download the Component Checker ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: ASP .mdb ADO OLE automation error - but works in access!
    ... is a mapped network drive, your IUSR account will probably not be able ... about connection failure instead of OLE Automation Error ... Go to the microsoft site and download the Component Checker ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: Server.MapPath() error ASP 0172 : 80004005
    ... >> Invalid Path ... >> set conn = CreateObject ... >> change permission on IUSR account? ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Reason: Not associated with a trusted SQL Server connection.
    ... > IIServer: Win XP ... > Mixed mode is enabled on SQL. ... In ASP, the IUSR account on your server is the user, not you. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Server.MapPath() error ASP 0172 : 80004005
    ... >> Invalid Path ... >> set conn = CreateObject ... >> change permission on IUSR account? ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)