Urgent Help Needed: "Optional Parameter Not Implemented"???

  • Thread starter Thread starter dwa
  • Start date Start date
D

dwa

I'm trying to insert a record into a table using Jet 4.0 with ADO (from a
C++ app) and I keep getting the error

"Optional feature not implemented"

There is nothing special I can see about the table or any of the parameters.
What might this mean?

Here's the query:

"insert into "
" patient( id,dob,height,weight,occupation,gender,glulow,gluhigh, "
" before_breakfast,
after_breakfast,before_lunch,after_lunch,before_dinner, "
" after_dinner,before_bedsnack,after_bedsnack,night_time,group_id) "
"values "
" (?,?,?,?,?,?,?,?, "
" ?, ?,?,?,?, "
" ?,?,?,?,?) ";

Here's a log of the parameters being passed in:

27,
1/1/1900,
0,
0,
,
0,
20,
600,
6:00:00 AM,
8:00:00 AM,
11:00:00 AM,
1:00:00 PM,
5:00:00 PM,
7:00:00 PM,
9:00:00 PM,
11:00:00 PM,
11:00:00 PM,
22
 
This group is for Microsoft Access.

You might try one of the 22 VC++ newsgroups that all start with microsoft.public.vc.

Your best bet might be microsoft.public.vc.database.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
There error message, as you quote it below, says optional *feature* not
implemented, not parameter.

There's a KB article that describes such an error message. Although at first
sight this KB article may appear to be specific to SQL Server and ODBC, I'm
not sure that is necessarily the case. According to the KB article, it
occurs when "you attempt to set the TYPE of a parameter in an ADODB command
object's parameters collection to a type that is not supported by the data
provider".

The URL to the KB article is ...
http://support.microsoft.com/default.aspx?scid=kb;en-us;214459
 
Back
Top