OleDbSchema Guid

hi

i am using OleDbSchemaGuid to display the schema information of a database
when i use OleDbSchemaGuid.Procecdures method it returns a data table
containing all procedures as well as functions..

but i am not able to separately get the list of procedures and the list of
functions....i need those details separately...

how do we do it using OleDbSchemaGuid??????

Avinash

Kalpesh
Wed Sep 28 07:07:56 CDT 2005


Hi,

You can create a dataview by applying filter on the resultant datatable
to seperate functions & proedures

eg.

myTable.DefaultView.RowFilter = "PROCEDURE_TYPE = " & DB_PT_PROCEDURE;

DB_PT_UNKNOWN = 1
DB_PT_PROCEDURE = 2
DB_PT_FUNCTION = 3

HTH
Kalpesh

Trainee
Wed Sep 28 07:45:22 CDT 2005

can't we specify this procedure_type value in the restriction array.
eg
OleDbGuid.Procedures,new object[]{null,null,null,2}

where 2 is the procedure_type value for procedures

but if i put it this way it throws error saying parameter incorrect

why?????


"Kalpesh" <shahkalpesh@gmail.com> wrote in message
news:1127909276.746594.128380@z14g2000cwz.googlegroups.com...
>
> Hi,
>
> You can create a dataview by applying filter on the resultant datatable
> to seperate functions & proedures
>
> eg.
>
> myTable.DefaultView.RowFilter = "PROCEDURE_TYPE = " & DB_PT_PROCEDURE;
>
> DB_PT_UNKNOWN = 1
> DB_PT_PROCEDURE = 2
> DB_PT_FUNCTION = 3
>
> HTH
> Kalpesh
>

Mark
Mon Oct 03 21:18:58 CDT 2005

Its lame, but the fourth parameter is expecting a Int16 not an Int32.

OleDbGuid.Procedures,new object[]{null,null,null,(short)2}

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbprocedures_rowset.asp

--
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Trainee" <trniac@honeywell.com> wrote in message
news:e4gSSmCxFHA.2960@tk2msftngp13.phx.gbl...
> can't we specify this procedure_type value in the restriction array.
> eg
> OleDbGuid.Procedures,new object[]{null,null,null,2}
>
> where 2 is the procedure_type value for procedures
>
> but if i put it this way it throws error saying parameter incorrect
>
> why?????
>
>
> "Kalpesh" <shahkalpesh@gmail.com> wrote in message
> news:1127909276.746594.128380@z14g2000cwz.googlegroups.com...
>>
>> Hi,
>>
>> You can create a dataview by applying filter on the resultant datatable
>> to seperate functions & proedures
>>
>> eg.
>>
>> myTable.DefaultView.RowFilter = "PROCEDURE_TYPE = " & DB_PT_PROCEDURE;
>>
>> DB_PT_UNKNOWN = 1
>> DB_PT_PROCEDURE = 2
>> DB_PT_FUNCTION = 3
>>
>> HTH
>> Kalpesh
>>
>
>

Trainee
Tue Oct 04 03:59:07 CDT 2005

hi ashton i am using an oledb provider to connect to any database such as
sql server or oracle so i need a generic way to list the procedures and
functions but what u suggested works well for oracle alone sql does not
support this method????

"Mark Ashton" <markash@online.microsoft.com> wrote in message
news:uEwW7nIyFHA.3236@TK2MSFTNGP14.phx.gbl...
> Its lame, but the fourth parameter is expecting a Int16 not an Int32.
>
> OleDbGuid.Procedures,new object[]{null,null,null,(short)2}
>
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbprocedures_rowset.asp
>
> --
> This posting is provided "AS IS", with no warranties, and confers no
rights.
> Please do not send email directly to this alias. This alias is for
newsgroup
> purposes only.
>
> "Trainee" <trniac@honeywell.com> wrote in message
> news:e4gSSmCxFHA.2960@tk2msftngp13.phx.gbl...
> > can't we specify this procedure_type value in the restriction array.
> > eg
> > OleDbGuid.Procedures,new object[]{null,null,null,2}
> >
> > where 2 is the procedure_type value for procedures
> >
> > but if i put it this way it throws error saying parameter incorrect
> >
> > why?????
> >
> >
> > "Kalpesh" <shahkalpesh@gmail.com> wrote in message
> > news:1127909276.746594.128380@z14g2000cwz.googlegroups.com...
> >>
> >> Hi,
> >>
> >> You can create a dataview by applying filter on the resultant datatable
> >> to seperate functions & proedures
> >>
> >> eg.
> >>
> >> myTable.DefaultView.RowFilter = "PROCEDURE_TYPE = " & DB_PT_PROCEDURE;
> >>
> >> DB_PT_UNKNOWN = 1
> >> DB_PT_PROCEDURE = 2
> >> DB_PT_FUNCTION = 3
> >>
> >> HTH
> >> Kalpesh
> >>
> >
> >
>
>

Kalpesh
Tue Oct 04 07:34:20 CDT 2005

Hi Mark,

Great work !!
I tried UInt16 for the last parameter & it threw exception related to
Parameters

I didnt dig deep into it further. I thought filtering the datatable
would be simple to do
Anyways, good work Mark

Kalpesh

Mark
Wed Oct 05 15:52:27 CDT 2005

UInt16 (DBTYPE_UI2) is still not the same as Int16 (DBTYPE_I2)

--
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Kalpesh" <shahkalpesh@gmail.com> wrote in message
news:1128429260.888129.14390@g43g2000cwa.googlegroups.com...
> Hi Mark,
>
> Great work !!
> I tried UInt16 for the last parameter & it threw exception related to
> Parameters
>
> I didnt dig deep into it further. I thought filtering the datatable
> would be simple to do
> Anyways, good work Mark
>
> Kalpesh
>

Mark
Wed Oct 05 15:56:25 CDT 2005

The support of the individual schemas is native OLE DB provider dependent.
The SQLOLEDB provider does support the Procedures schema table.

--
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Trainee" <trniac@honeywell.com> wrote in message
news:%23j$a1DMyFHA.1132@TK2MSFTNGP10.phx.gbl...
> hi ashton i am using an oledb provider to connect to any database such as
> sql server or oracle so i need a generic way to list the procedures and
> functions but what u suggested works well for oracle alone sql does not
> support this method????
>
> "Mark Ashton" <markash@online.microsoft.com> wrote in message
> news:uEwW7nIyFHA.3236@TK2MSFTNGP14.phx.gbl...
>> Its lame, but the fourth parameter is expecting a Int16 not an Int32.
>>
>> OleDbGuid.Procedures,new object[]{null,null,null,(short)2}
>>
>>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbprocedures_rowset.asp
>>
>> --
>> This posting is provided "AS IS", with no warranties, and confers no
> rights.
>> Please do not send email directly to this alias. This alias is for
> newsgroup
>> purposes only.
>>
>> "Trainee" <trniac@honeywell.com> wrote in message
>> news:e4gSSmCxFHA.2960@tk2msftngp13.phx.gbl...
>> > can't we specify this procedure_type value in the restriction array.
>> > eg
>> > OleDbGuid.Procedures,new object[]{null,null,null,2}
>> >
>> > where 2 is the procedure_type value for procedures
>> >
>> > but if i put it this way it throws error saying parameter incorrect
>> >
>> > why?????
>> >
>> >
>> > "Kalpesh" <shahkalpesh@gmail.com> wrote in message
>> > news:1127909276.746594.128380@z14g2000cwz.googlegroups.com...
>> >>
>> >> Hi,
>> >>
>> >> You can create a dataview by applying filter on the resultant
>> >> datatable
>> >> to seperate functions & proedures
>> >>
>> >> eg.
>> >>
>> >> myTable.DefaultView.RowFilter = "PROCEDURE_TYPE = " & DB_PT_PROCEDURE;
>> >>
>> >> DB_PT_UNKNOWN = 1
>> >> DB_PT_PROCEDURE = 2
>> >> DB_PT_FUNCTION = 3
>> >>
>> >> HTH
>> >> Kalpesh
>> >>
>> >
>> >
>>
>>
>
>