SqlDataSource

A

Arne Garvander

I have a problem configuring a SqlDataSource.
1. I click Specify SQL Statement or stored procedure
2. When I try to select a stored procedure that dropdown is greyed out. The
radio button for stored procedure is greyed out.
I use VS studio 2008 sp1.
What am I doing wrong?
 
J

Jonathan Wood

Before that, you must specify things about your database, such as the
connection string. Are you certain all that is correct?
 
A

Arne Garvander

Yes, the connection strings is there because dynamic sql works. Stored proc
is greyed out.


--
Arne Garvander
(I program VB.Net for fun and C# to get paid.)


Jonathan Wood said:
Before that, you must specify things about your database, such as the
connection string. Are you certain all that is correct?
Click to expand...
 
H

HillBilly

Can you run the procedure yourself to verify it functions and can be called
by your SQL login?

Arne Garvander said:
Yes, the connection strings is there because dynamic sql works. Stored
proc
is greyed out.
Click to expand...
 
A

Arne Garvander

None of my stored procs had the correct security. That is why I had a problem.
I granted execute privileges to one stored proc and now my SQLDataSource
wizard is helpful again.
 

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

SqlDataSource UpdateParameters supplies wrong number of params to storedproc 2
OleDb SqlDataSource stored procedure call parameter order mixed up ? 0
SqlDataSource OnSelected Event Not Firing 0
Stored Procedure fast in SSMS but times out in ADO.NET app 5
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Using a Transaction with a SqlDataSource 3
LINQ to XML: stored procedure returning result of FOR XML PATH 4
step into SQL Stored Procedures? 1

Top