« Return to Thread: MS DataShape and Stored Procedures

MS DataShape and Stored Procedures

by Daniele Barzotti :: Rate this Message:

Reply to Author | View in Thread

Hi,

I don't know if this is a mistake with the ODBC Driver, but I try...
I'm working with FB v2.0.3 and ODBC v2.00.00.144 and ADO with VB6.

I have to open a hierarchical recordset with MSDATASHAPE provider:

PERSON
   |- RADIO
        |- RADIO DETAILS

The query is:

SHAPE {{ CALL SP_PERSONALE( ?) }} AS PERSONALE
APPEND ({SELECT * FROM "VIEW_RTX_DETAILS"}
RELATE PERS_IDRADIO TO IDRADIO) AS RADIO_PERS

where "VIEW_RTX_DETAILS" is a VIEW and SP_PERSONALE is a stored
procedure that returns a people list if I pass 0 to it.

When I execute this command, I receive:

Err.Number      = -2147217904
Err.Description = No values specified for some parameters needed.
Err.Source = Microsoft OLE DB Provider for ODBC Drivers

Can anyone give me some suggestions?
Thanks in advance!

Regards,
Daniele.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

 « Return to Thread: MS DataShape and Stored Procedures

LightInTheBox - Buy quality products at wholesale price!