Well, if you don't have a SQL Server, then you will have to use whatever
DB-specific method will give you a list of the stored procedures (there is
not one standardized way of getting stored procedures across all data
sources).
Also, the provider really doesn't matter in this case (ODBC is a
provider that can connect to many data sources, as is OLEDB) unless it is
for one product and one product only (SQL Server, for example) and even
then, it might not give you the information you want.
For SQL Server, you can simply run the sp_stored_procedures stored
procedure and it will return a list of stored procedures to you:
http://msdn2.microsoft.com/en-us/library/ms190504.aspx
--
- Nicholas Paldino [.NET/C# MVP]
-
mv*@spam.guard.caspershouse.com
"roundcrisis" <ro*********@gmail.comwrote in message
news:e0**********************************@d4g2000p rg.googlegroups.com...
Hi there:
I would like to retrive a collection with the avvaialbe stored
procedures, if there are any,
I m using an ODBC connection,
How can this be achieved?
I know u can do a select of one of the system tables with a sql
server, but what happens if i dont have a sql server?
Cheers