Re: -2147217887 [Microsoft][ODBC SQL Server Driver]Optional feature not implemented

From: Ted Thibodeau Jr (tthibodeau_at_openlinksw.com)
Date: 01/04/05 

Date: Tue, 04 Jan 2005 16:37:18 -0500
To: "Peter Afonin" <peter@gudzon.net>

[[ This message was both posted and mailed: see
   the "To," "Cc," and "Newsgroups" headers for details. ]]

In article <#L7W1$rxEHA.1260@TK2MSFTNGP12.phx.gbl>, Peter Afonin
<peter@gudzon.net> wrote:

> Hello,
>
> I'm trying to execute a stored procedure in SQL Server 2000 from a VB^
> program, but getting this error:
>
> -2147217887 [Microsoft][ODBC SQL Server Driver]Optional feature not
> implemented
>
> What does it mean? The only explanation I've found so far is about
> MS Access and Unicode, but I don't use either.
>
> I would appreciate your help.
>
> Thank you,

Learning what the error is about, and thus being able to resolve it,
requires that you trace the ODBC activity -- configured through the
Data Sources (ODBC) control panel's Tracing tab.

This does not always succeed, depending on how you've specified your
connection, and how the VB is being executed.

Sometimes, manually editing the Registry, and setting up System-level
logging works better than using teh Administrator.

You may want to try using a different ODBC Driver for SQL Server, such
as that from OpenLink (downloadable for a free 30-day trial, from our
main website, linked in my .sig).

Good luck,

Ted 

-- 
A: Yes.                                       http://learn.to/attribute
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?
Ted Thibodeau, Jr.           //               voice +1-781-273-0900 x32
Evangelism & Support         //        mailto:tthibodeau@openlinksw.com
OpenLink Software, Inc.      //              http://www.openlinksw.com/
                                 http://www.openlinksw.com/weblogs/uda/
OpenLink Blogs              http://www.openlinksw.com/weblogs/virtuoso/
                               http://www.openlinksw.com/blog/~kidehen/
    Universal Data Access and Virtual Database Technology Providers

Relevant Pages

  • Re: -2147217887 [Microsoft][ODBC SQL Server Driver]Optional feature not implemented
    ... > I'm trying to execute a stored procedure in SQL Server 2000 from a VB^ ... Data Sources (ODBC) control panel's Tracing tab. ... You may want to try using a different ODBC Driver for SQL Server, ... Universal Data Access and Virtual Database Technology Providers ...
    (microsoft.public.vb.database.ado)
  • Re: How to have SQL_ERROR returned from RAISERROR within IF-BLOCK
    ... The problem has been fixed in SQL Server 2005. ... even modify the sequence of ODBC function calls and checking of the return ... I want to return SQL_ERROR to my application with a custom error message ... I get it returned fine when I execute the following statement using ...
    (microsoft.public.data.odbc)
  • ODBC --Call Failed Error
    ... settings and originally did not change any ODBC connections. ... Within one procedure I execute 2 SQL ... I have profiled SQL Server and I see the successful ...
    (microsoft.public.access.forms)
  • ODBC vs OLE DB ???
    ... Here is an except from the book "SQL Server 2000 Weekend Crash Course" ... OSQL-A command-line utility used to connect to SQL Server and execute ... In SQL Server 2000, all utilities except isql use the ODBC ...
    (microsoft.public.sqlserver.odbc)
  • SQL Server ODBC Driver Ignores Authentication Setting
    ... set their ODBC connections with SQL Server Authentication, ... Microsoft Data Access Components 2.6 RTM, ... authentication to log into the database. ...
    (microsoft.public.sqlserver.security)
Loading