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

[SARINGER Zoltán]

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

 

[Bob Barrows [MVP]]

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

 

[Bob Barrows [MVP]]

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

 

[asdf]

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

 

[¹Ú¹®¼ö]

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.

 

[¹Ú¹®¼ö]

contact