Can MDAC upgrade cause ODBC driver error?

From: Ollie_Mac (OllieMac_at_discussions.microsoft.com)
Date: 09/12/04 

Date: Sun, 12 Sep 2004 16:27:07 -0700

The below ASP code was written to append data to to a external Oracle database.
The server OS is Windows 2000.
It worked OK until MDAC was upgraded on the server to 2.7
This was updated by applying the latest SQL patch.
Now I get the error message...
   Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
   ODBC driver does not support the requested properties.

at the line where rsf.open, see code below.
I am not sure if this upgrade is causing the problem.
Do you think that I need to apply a more uptodate Oracle driver?

Please Help!
Ollie.

<%
                Set cmdf = Server.CreateObject("ADODB.command")
                set rsf = server.createobject("ADODB.recordset")
                cmdf.ActiveConnection = Application("FastOra_ConnectionString")

                QSQL = "{call aoppack.getloodetails(?,{resultset 9, APPROVAL_DATE,
ACCEPT_DATE, PRIOR_CONDS_MET_DATE })}"
                                                                                                               
                cmdf.CommandText = QSQL
                cmdf.CommandType = adCmdText
                                                                                                 
                cmdf.Parameters.Append cmdf.CreateParameter(, adInteger, adParamInput)

                rsf.CursorType = adOpenStatic
                rsf.LockType = adLockReadOnly

                Set rsf.Source = cmdf
        
                cmdf(0) = request.form("txtLooNumber")

                rsf.open
                
%>
 
 
 
   

Relevant Pages

  • ASP: Get user login ID
    ... But when we register the dll on our web ... server, and call it from our ASP code, it generates an error. ... Dim lngCharsReturned As Long ...
    (microsoft.public.inetserver.iis.security)
  • Re: IISState log (IIS slow)
    ... It doesn't matter if the file does not have any ASP code in it or not. ... former is handled directly by the IIS Static file handler, ... which under any sort of appreciable load means your server is ... reached its allowed processing time limit. ...
    (microsoft.public.inetserver.iis)
  • Re: 80004005 Unspecified Error
    ... I did not expect MVPs to argue over cute variable names ("cn" vs. ... connecting to Access databases from asp code. ... It worked just fine (I had to restart my win2000 server) TILL I ... >> I tried using a different connection string hoping it was the driver: ...
    (microsoft.public.inetserver.asp.db)
  • Re: FP 2003 HowTo ASP pages?
    ... you have the option of adding asp code later without having to rename pages ... > - extra unnecessary calls to the server ... > |> I have tried creating a local empty web site under my ... > | that you *can* open and try publishing to a new web at ...
    (microsoft.public.frontpage.client)
  • Re: IISState log (IIS slow)
    ... IIS processes pages normally without errors(only IIS Log sometimes throws ... AVG server load is 50-60% when IIS stops responding normally, ... comes to opening asp files(even sometimes without asp code in it/plain html). ... Same sql queries which I launch in asp, ...
    (microsoft.public.inetserver.iis)