"Failed to get schema for this stored proceure"

I'm trying to configure an SqlDataAdapter to a stored procedure that has no
recordsets, but rather a handful of output parameters. VS.Studio gives me
"Failed to get schema for this stored procedure"

--
_____
DC G

William
Tue Sep 07 19:46:39 CDT 2004

I just dragged a fairly complex SP with mostly output parameters from the
server explorer to the form and the IDE built a correct Command object for
it.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"DC Gringo" <dcgringo@visiontechnology.net> wrote in message
news:ey8SDxSlEHA.3544@TK2MSFTNGP15.phx.gbl...
> I'm trying to configure an SqlDataAdapter to a stored procedure that has
> no
> recordsets, but rather a handful of output parameters. VS.Studio gives me
> "Failed to get schema for this stored procedure"
>
> --
> _____
> DC G
>
>

DC
Tue Sep 07 20:26:04 CDT 2004

Bill,

Ok, I tried the same thing but to no avail. Do I need a data adapter if
there are no recordsets and only parameters? All I got was a connection and
a command object.

_____
DC G

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:u0aQO1TlEHA.3760@TK2MSFTNGP12.phx.gbl...
> I just dragged a fairly complex SP with mostly output parameters from the
> server explorer to the form and the IDE built a correct Command object for
> it.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
>
> "DC Gringo" <dcgringo@visiontechnology.net> wrote in message
> news:ey8SDxSlEHA.3544@TK2MSFTNGP15.phx.gbl...
> > I'm trying to configure an SqlDataAdapter to a stored procedure that has
> > no
> > recordsets, but rather a handful of output parameters. VS.Studio gives
me
> > "Failed to get schema for this stored procedure"
> >
> > --
> > _____
> > DC G
> >
> >
>
>

William
Wed Sep 08 14:33:26 CDT 2004

The only reason to use a DataAdapter is to populate the DataSet with the
rowsets from SELECT statements.
That's all you need--a Command object and its associated connection.


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"DC Gringo" <dcgringo@visiontechnology.net> wrote in message
news:uM0SRLUlEHA.3428@TK2MSFTNGP14.phx.gbl...
> Bill,
>
> Ok, I tried the same thing but to no avail. Do I need a data adapter if
> there are no recordsets and only parameters? All I got was a connection
> and
> a command object.
>
> _____
> DC G
>
> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
> news:u0aQO1TlEHA.3760@TK2MSFTNGP12.phx.gbl...
>> I just dragged a fairly complex SP with mostly output parameters from the
>> server explorer to the form and the IDE built a correct Command object
>> for
>> it.
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> __________________________________
>>
>> "DC Gringo" <dcgringo@visiontechnology.net> wrote in message
>> news:ey8SDxSlEHA.3544@TK2MSFTNGP15.phx.gbl...
>> > I'm trying to configure an SqlDataAdapter to a stored procedure that
>> > has
>> > no
>> > recordsets, but rather a handful of output parameters. VS.Studio gives
> me
>> > "Failed to get schema for this stored procedure"
>> >
>> > --
>> > _____
>> > DC G
>> >
>> >
>>
>>
>
>