all groups > sql server odbc > april 2004 >
You're in the

sql server odbc

group:

ODBC Error Code = S1C00 (Driver not capable)


ODBC Error Code = S1C00 (Driver not capable) Bill Youngman
4/26/2004 4:54:23 PM
sql server odbc:
I am attempting to write data to a database from a web form. I am using =
stored procedures to write the data to different tables in the db and =
using the transaction and rollback functionality to ensure that the sp =
have executed properly before commiting the data to the db.

All of my sp seem to pass but one, incidentally the sp that is =
generating the error is writing data to a table that is part of the =
vendor's database (an activity log).

The specific error that I am getting when I try to execute this sp is -

ODBC Error Code =3D S1C00 (Driver not capable)=20

[Microsoft][ODBC SQL Server Driver]Optional feature not implemented

Any ideas/suggestion will be appreciated.

TIA,

Re: ODBC Error Code = S1C00 (Driver not capable) Sue Hoegemeier
4/26/2004 5:04:28 PM
What MDAC version? What SQL Server version? Did you run an
ODBC trace to see what command is failing? Did you test the
stored procedure from another workstation using Query
Analyzer.
In addition, one possibility is that you can run into the
error with outdated ODBC drivers or if your MDAC
installation has mismatched dlls. You can verify your MDAC
installation using the Component Checker. You can download
the tool and recent MDAC versions from:
http://msdn.microsoft.com/data/mdac/default.aspx

-Sue

On Mon, 26 Apr 2004 16:54:23 -0400, "Bill Youngman"
[quoted text, click to view]
AddThis Social Bookmark Button