Error-Optional Feature not Implemented (ODBC Access) 
Author Message
 Error-Optional Feature not Implemented (ODBC Access)


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

I am trying to use the Command ADO object to run PARAMETER queries in MS
Access 97.Can MS Access run PARAMETER queries in conjunction with the ADO
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.

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 =
.Parameters.Append .CreateParameter("basketnum",adBigInt)
.Parameters("basketnum").Value = basketnumber
.Parameters.Append .CreateParameter("thetotal",adDouble)
end with
thetotal = cmd.Parameters("thetotal").Value
PARAMETERS [basketnum] Long, [thetotal] IEEEDouble;
SELECT basketnumber, total AS thetotal
FROM baskets
WHERE basketnumber=[basketnum];

Tue, 08 Jul 2003 00:08:14 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Error -2147217887 [Microsoft][ODBC SQL Server Driver]Optional feature not implemented ,

2. Error -2147217887 [Microsoft][ODBC SQL Server Driver]Optional feature not implemented ,

3. Error -2147217887 [Microsoft][ODBC SQL Server Driver]Optional feature not implemented ,

4. [ODBC SQL Server Driver]Optional feature not implemented

5. HELP! Optional feature not implemented error

6. Error "optional features not implemented"

7. Optional feature not implemented???


9. Optional feature not implemented...

10. Error 501 - Not implemented or not supported Internet

11. JScript Optional recset.Open optional args error ( few args )

12. Newbie: Compile error: Argument (ShellExecute) not optional


Powered by phpBB® Forum Software