Re: Get a list of available stored procedures

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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]
- mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx

"roundcrisis" <roundcrisis@xxxxxxxxx> wrote in message
news:e00dca7c-57c9-4e3d-9fe9-8dc01e5ca061@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: how to get functions from stored procedures
    ... Provider for SQL Server does not) u said u need to write non-generic code ... >> procedures but i get both functions as well as stored procedures from ...
    (microsoft.public.data.oledb)
  • Re: how to get functions from stored procedures
    ... You don't say which OLEDB provider you are using here, ... Provider for SQL Server does not), then you can just obtain unrestricted ... > procedures but i get both functions as well as stored procedures from that ...
    (microsoft.public.data.oledb)
  • Re: Get a list of available stored procedures
    ... (there is not one standardized way of getting stored procedures across all ... provider that can connect to many data sources, as is OLEDB) unless it is ... For SQL Server, you can simply run the sp_stored_procedures stored ... their database -- it's like implementing a common interface. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Disabling ASP.net 2.0 Membership
    ... I checked out the article you referenced and implemented my own provider. ... as a FoxPro database, an Oracle database, or other data sources. ... custom connection string so that I can use the Commerce Server SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ERROR: Provider Management - Could not establish a connection to t
    ... If you have not yet created the SQL Server database, ... Can any data provider be used to ... Exception Details: System.Data.SqlClient.SqlException: A connection ...
    (microsoft.public.dotnet.framework.aspnet)