Type 'adCmdStoredProc' is not declared

[stingrays]

I am trying to set up a "cmd.CommandType = adCmdStoredProc" but I
receive the error "Type 'adCmdStoredProc' is not declared". What do I
need to do to declare it? I am using MSDE with SQLDataAdapter. I am
trying to exceute a stored procedure from within my VB .NET 2003 code.

Thanks.

JH

[Simon Hayes]

st*******@mindspring.com (stingrays) wrote in message news:<60**************************@posting.google. com>...

I am trying to set up a "cmd.CommandType = adCmdStoredProc" but I
receive the error "Type 'adCmdStoredProc' is not declared". What do I
need to do to declare it? I am using MSDE with SQLDataAdapter. I am
trying to exceute a stored procedure from within my VB .NET 2003 code.

Thanks.

JH

I think you'll probably get a better answer in a .NET newsgroup - it
looks like the ADO constants are not being recognized, but I know very
little about .NET and ADO, so I may be completely wrong.

Simon

[Jesper Jensen]

Seems to me, you're using a legacy ADO constant with a .NET component.

Try: 'cmd.CommandType = CommandType.StoredProcedure'.

Rgds - Jesper

"stingrays" <st*******@mindspring.com> skrev i en meddelelse
news:60**************************@posting.google.c om...

I am trying to set up a "cmd.CommandType = adCmdStoredProc" but I
receive the error "Type 'adCmdStoredProc' is not declared". What do I
need to do to declare it? I am using MSDE with SQLDataAdapter. I am
trying to exceute a stored procedure from within my VB .NET 2003 code.

Thanks.

JH

[stingrays]

Thanks. I changed it to cmd.CommandType = CommandType.StoredProcedure
and my parameters to cmd.Parameters.Add("@EntryDate") and now I have
the statement: 'Add' is not a member of ADODB.Parameters.

It isn't listed there in the drop down as I am typing so I expected
this. Am I missing a reference in my project? I am using the
'ActiveX Data Objects 2.7 Library.

Thanks for the help.

Jason

"Jesper Jensen" <mo********@post.tdcadsl.dk> wrote in message news:<40*********************@dread12.news.tele.dk >...

Seems to me, you're using a legacy ADO constant with a .NET component.

Try: 'cmd.CommandType = CommandType.StoredProcedure'.

Rgds - Jesper

"stingrays" <st*******@mindspring.com> skrev i en meddelelse
news:60**************************@posting.google.c om...

I am trying to set up a "cmd.CommandType = adCmdStoredProc" but I
receive the error "Type 'adCmdStoredProc' is not declared". What do I
need to do to declare it? I am using MSDE with SQLDataAdapter. I am
trying to exceute a stored procedure from within my VB .NET 2003 code.

Thanks.

JH

[Samuel Hon]

It appears to me that you are getting confused by ADO

In .NET, you use ADO.NET via the System.Data namespace and you
shouldnt actually need to reference 'ActiveX Data Objects 2.7 Library'

Sam

st*******@mindspring.com (stingrays) wrote in message news:<60*************************@posting.google.c om>...

Thanks. I changed it to cmd.CommandType = CommandType.StoredProcedure
and my parameters to cmd.Parameters.Add("@EntryDate") and now I have
the statement: 'Add' is not a member of ADODB.Parameters.

It isn't listed there in the drop down as I am typing so I expected
this. Am I missing a reference in my project? I am using the
'ActiveX Data Objects 2.7 Library.

Thanks for the help.

Jason

"Jesper Jensen" <mo********@post.tdcadsl.dk> wrote in message news:<40*********************@dread12.news.tele.dk >...

Seems to me, you're using a legacy ADO constant with a .NET component.

Try: 'cmd.CommandType = CommandType.StoredProcedure'.

Rgds - Jesper

"stingrays" <st*******@mindspring.com> skrev i en meddelelse
news:60**************************@posting.google.c om...

I am trying to set up a "cmd.CommandType = adCmdStoredProc" but I
receive the error "Type 'adCmdStoredProc' is not declared". What do I
need to do to declare it? I am using MSDE with SQLDataAdapter. I am
trying to exceute a stored procedure from within my VB .NET 2003 code.

Thanks.

JH

[Samuel Hon]

It appears to me that you are getting confused by ADO

In .NET, you use ADO.NET via the System.Data namespace and you
shouldnt actually need to reference 'ActiveX Data Objects 2.7 Library'

Sam

st*******@mindspring.com (stingrays) wrote in message news:<60*************************@posting.google.c om>...

Thanks. I changed it to cmd.CommandType = CommandType.StoredProcedure
and my parameters to cmd.Parameters.Add("@EntryDate") and now I have
the statement: 'Add' is not a member of ADODB.Parameters.

It isn't listed there in the drop down as I am typing so I expected
this. Am I missing a reference in my project? I am using the
'ActiveX Data Objects 2.7 Library.

Thanks for the help.

Jason

"Jesper Jensen" <mo********@post.tdcadsl.dk> wrote in message news:<40*********************@dread12.news.tele.dk >...

Seems to me, you're using a legacy ADO constant with a .NET component.

Try: 'cmd.CommandType = CommandType.StoredProcedure'.

Rgds - Jesper

"stingrays" <st*******@mindspring.com> skrev i en meddelelse
news:60**************************@posting.google.c om...

I am trying to set up a "cmd.CommandType = adCmdStoredProc" but I
receive the error "Type 'adCmdStoredProc' is not declared". What do I
need to do to declare it? I am using MSDE with SQLDataAdapter. I am
trying to exceute a stored procedure from within my VB .NET 2003 code.

Thanks.

JH