Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > ASP + JET + VStudioSP6 + bug - half solution yet !!!

Reply
Thread Tools

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

 
 
SARINGER Zolt嫕
Guest
Posts: n/a
 
      08-24-2004
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







 
Reply With Quote
 
 
 
 
Bob Barrows [MVP]
Guest
Posts: n/a
 
      08-24-2004
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.


 
Reply With Quote
 
 
 
 
Bob Barrows [MVP]
Guest
Posts: n/a
 
      08-25-2004
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.


 
Reply With Quote
 
asdf
Guest
Posts: n/a
 
      08-25-2004
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...)


 
Reply With Quote
 
夢僥熱
Guest
Posts: n/a
 
      08-27-2004

"Bob Barrows [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>



 
Reply With Quote
 
夢僥熱
Guest
Posts: n/a
 
      08-27-2004

"夢僥熱" <anstn1269> wrote in message
news:uh2NJx#(E-Mail Removed)...
>
> "Bob Barrows [MVP]" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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.
> >
> >

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ie7 displaying only half of page (cuts page in half)... trint ASP .Net 4 09-11-2007 10:56 AM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-30-2006 03:16 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 1 03-24-2006 04:20 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-24-2006 02:22 PM



Advertisments