SqlDataSource

[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?

 

[Jonathan Wood]

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

 

[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.)

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

 

[HillBilly]

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

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

 

[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.