"Optional feature not implenented"

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: dwa (da_at_hotmail.com)
Date: 04/22/04


Date: Thu, 22 Apr 2004 16:47:48 -0400

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



Relevant Pages

  • Re: Run ADO/OLE DB from a CD-R
    ... using ADO/OLE Db from a CD. ... I need to get my VB6 app. ... also have had Visual Studio installed, however on all other machines, the ADO ... I've tried to include all possible files on the CD (MDAC, ADO, Jet, etc etc) ...
    (microsoft.public.data.ado)
  • XP SP2 vs. Jet/ADO - Error in simple query?
    ... I have an app that has been installed successfully on dozens of machines. ... The app is written in VB6, and used ADO 2.5 to connect to a local ... by installing Jet 4.0 SP8, but the install procedure told him that his Jet ...
    (microsoft.public.vb.database.ado)
  • Re: [Access2003, VBA] Use DAO or ADO?
    ... One of the reasons my clients preferred Access / Jet / ODBC was that they ... Autonumber or its server equivalent and could have been shown to the users ... real world of development, Dot Net", ADO has been superceded by ADO.NET ...
    (comp.databases.ms-access)
  • Re: How to enforce subtypes/supertypes in Access 2000?
    ... DAO is the native object model for Jet databases and, as such, is the ... ever need ADO. ... Private Sub SetContactType() ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Use DAO or ADO?
    ... tables to a jet backend to open a ado recordset. ... will ALSO work for mysql, oracle and sql server if I take that sql ... engine that they don't understand who want to avoid Jet at all ...
    (comp.databases.ms-access)