Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


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

Posted on 2004-10-28
Medium Priority
Last Modified: 2008-01-09
Hello, I have a program from work created by our IT team which runs a program that is a training aid for us. The training data (I think) is written using Microsoft access. Basically the problem is that I can use the program if installed on a Windows 98 or 2000 machine, but running on an XP Pro or Home machine the following error messages are given when the program tries to load the data for the topic I am reviewing:

SQL State: S1C00
Native 106
Message: [Microsoft][ODBC Microsoft Access Driver] Optional Feature not implemented

SQL State: S1010
Native: 0
Message: [Microsoft][ODBC Driver Manager] Function sequence error

Short of making one of my computers dual boot XP, 98 (which would mean Installing 98 first and loosing my current build of XP) which I could do. Is it possible to change something that allows this program to work in XP. I am not computer expert, Do I need to change the database in Access itself, how would i do that.

How does XP differ from 98/ 2000 which stops this program from working. Is there an SQL driver I need to add to my XP list, and could this have some bad impact on the running of XP?

If you think it can be made to work on XP or you can shed some light on this problem, I would be very interested in your views and ideas.

Question by:SNIFFER_dog
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

rlibrandi earned 2000 total points
ID: 12443633
For the first error
Look at MSDN on-line at these two Q numbers:


For the second error look at

you can at least go to your IT people with this information and see if they can offer some help.  It might simply take a recompile of the application to use the data access drivers thay your XP machine needs to use.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question