ODBC Error-Optional Feature not Implemented

[Justin Dutoit]

Hello

I have this error message-

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

[Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented

/VBStyle/basket.asp, line 252

What does this message mean?

Can MS Access run PARAMETER queries in conjunction with the ADO Command
methods, and simulate stored procedures?

The line 252 is cmd.Execute below. If I need to add any args to that, please
let me know. Failing that though, um, can Access work as the db backend for
this sort of code (the following)? I read somewhere that Access might not
support this. Also below is the text of the "stored procedure". Please help
with any detail , I would be grateful.

Cheers
Justin Dutoit

set conn = server.CreateObject("ADODB.Connection")
conn.Open "vbstyle"

set param = server.CreateObject("ADODB.Parameter")
set cmd = server.CreateObject("ADODB.Command")

With cmd
Set .ActiveConnection = conn
.CommandText = "sproc_getbaskettotal"
.CommandType = adCmdStoredProc ' Public Const adCmdStoredProc =
&H0004
.Parameters.Append .CreateParameter("basketnum",adBigInt)
.Parameters("basketnum").Value = basketnumber
.Parameters.Append .CreateParameter("thetotal",adDouble)
end with
cmd.Execute
thetotal = cmd.Parameters("thetotal").Value
..
..
PARAMETERS [basketnum] Long, [thetotal] IEEEDouble;
SELECT basketnumber, total AS thetotal
FROM baskets
WHERE basketnumber=[basketnum];

[Intermedia.NET Support (shh)]

Please see if the following article can be useful:
http://support.microsoft.com/support/kb/articles/Q214/4/59.ASP

=============================================
Intermedia.NET (shh)
Microsoft Certified Solutions Provider
Providing expertise in hosting applications

More Tips at: http://www.intermedia.net/support/kb/
Windows 2000 Web Hosting: http://www.intermedia.net/
For a waiver of the set up fee use "IMFREE" code
==============================================

"Justin Dutoit" <justin...@free.net.au> wrote in message
news:#WV#PVPgAHA.1892@tkmsftngp05...

[Justin Dutoit]

Thanks! If you could email me on justin...@goconnect.net showing how to
look up an error by error name in the microsoft support site, if that's what
you did, I'd be grateful.

Ta

Justin

"Intermedia.NET Support (shh)" <news...@intermedia.net> wrote in message
news:emJXfGUgAHA.1892@tkmsftngp05...

[Intermedia.NET Support (shh)]

Go to Microsoft site at www.microsoft.com, in the Search field (on the
right) input the number of the error, for example 80040e21. When you get the
list of matches you can also add some details about the error you are
getting into the Search within Results field, for example Optional feature
not implemented. And here you go.

=============================================
Intermedia.NET (shh)
Microsoft Certified Solutions Provider
Providing expertise in hosting applications

More Tips at: http://www.intermedia.net/support/kb/
Windows 2000 Web Hosting: http://www.intermedia.net/
For a waiver of the set up fee use "IMFREE" code
==============================================

"Justin Dutoit" <justin...@free.net.au> wrote in message

news:#T1Uo4mgAHA.1844@tkmsftngp05...