running stored proc against db using script - issue

T

TJ

I am trying to update a database using a stored procedure and jscript.
I am basically following these instructions:
http://support.microsoft.com/kb/827007

But the sql command is not getting run against the SQL Server. I am
using the code below. I know the syntax is correct as I UI.Alert the
command, and I copied the command and ran it directly against the SQL
Server, and it worked fine.

XDocument.QueryAdapter.Command = "exec sp_ValidateDailyData " + "'" +
WellName + "', '" + Day + "', " + NewValue;
XDocument.Query();
XDocument.UI.Alert("ran: " + XDocument.QueryAdapter.Command);

The output of the Alert is:
execute sp_validateDailyData 'EM02', '2006-10-22T00:00:00', 999

The datasource uses embedded SA username and password.

There are no script errors. Why isn't the command making it to the SQL
Server?

thanks
tj
 

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

Infopath stored procedures with SQL Views 1
InfoPath Execute Stored Procedure Error 5
Secondary Datasource Code - http://support.microsoft.com/kb/826992 0
Execute SQL Stored Proc from Access 1
SQL multiple tables, web service or stored proc? 6
Referncing stored proc from a form 2
Running a stored proc in sql 2005 from Access using VBA 4
Calling SQL Stored Proc from Access (with Parameters) 9

Top