Cannot run a stored procedure from ASP

E

Eric W. Holzapfel

Hello FP Programmers,

I am trying to run a stored procedure that will insert records into SQL
Server 2000. it runs fine from the Query Analyzer, etc.

I use VBScript to set the paramters, etc (I can run a Select statement
stored procedure ok), and use the following command to execute the
stored procedure

insertCMD.Execute Lines (to give me the number of lines it inserts?)
I have a DSN set up for the database.

I get the following error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented

Any ideas here??? I am able to run a stored procedure that will insert
records fine in ASP.NET (C# code behind, etc) in the same database.

I must be missing something.
Any ideas here?

Thanks

eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run a SQL Stored Procedure from VBA 0
SQL Stored Procedure 1
SQL Server Stored Procedure timeout 3
Create Stored Procedure in SQL server from Access VBA? 4
Execute SQL Stored Proc from Access 1
stored procedure query 4
How to execute SQL stored procedure from Access 8
Stored Procedures - error handling 0

Top