Retrieve a list of parameters for an MS Access SPROC/Stored Proced

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Since System.Data.GetOleDbSchemaTable does not support the querying of SPROC
parameters in MDAC 2.7, does anybody know of a work-around?

Does anybody know of a specific SQL query that can return the details of
sproc parameters?
 
Nate. said:
Since System.Data.GetOleDbSchemaTable does not support the querying
of SPROC parameters in MDAC 2.7, does anybody know of a work-around?

Does anybody know of a specific SQL query that can return the details
of sproc parameters?
Click to expand...

I looked hard for this, but it's IMHO non-retrievable meta-data. Even
in the mdb file I couldn't find it in the system tables. I guess Access
parses the proc text manually to obtain the parameters.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
 
Thank you Frans for your reply. I have searched hi/lo for this too, it's
really a frustrating because this "should" be easy to accomplish?? But I just
wanted to thank you for your time/effort looking into this too, I really
appreciate it. Thanks again.

Nate.
 
Back
Top