Re: ExecuteNonQuery() - Bach SQL Statement execution?
From: Nathan (Nathan_at_discussions.microsoft.com)
Date: 11/09/04
- Next message: Val Mazur: "Re: Limit in Dataset?"
- Previous message: Val Mazur: "Re: Executing a select statement multiple times?"
- In reply to: Sahil Malik: "Re: ExecuteNonQuery() - Bach SQL Statement execution?"
- Next in thread: Val Mazur: "Re: ExecuteNonQuery() - Bach SQL Statement execution?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 9 Nov 2004 15:21:02 -0800
Thank You Malik.
I did try a batched query with DataReader. Datareader.NextResult doesn't
work.. so my ODBC driver doesn't allow, I guess.
"Sahil Malik" wrote:
> > How do I know if my underlying driver supports this?
> Depends on the ODBC driver. I say write up a quick test app and execute a
> batched query.
>
> > Is there something I can do to change any setting on the ODBC driver?
> Again depends on the ODBC driver, but I haven't ever come across such a
> setting, and logically it doesn't make any sense to not enable this by
> default -- in other words, my hunch is, no such setting exists because it
> doesn't seem to make sense.
>
> - Sahil Malik
> http://dotnetjunkies.com/weblog/sahilmalik
> Please reply to the newsgroups instead of email so everyone can benefit from
> your reply.
>
>
> "Nathan" <Nathan@discussions.microsoft.com> wrote in message
> news:8476A9BD-5D3E-49AA-A0F8-0F34FB78B4B2@microsoft.com...
> > Hi,
> > I am trying to use the ExecuteNonQuery() to execute multiple SQL update
> > statements. Though the SQL is correct, it only executes the first update
> > statement. When I looked through the documentation I found out this,
> > "You can also use ExecuteNonQuery to execute multiple SQL statements if
> the
> > underlying ODBC driver supports this functionality."
> > How do I know if my underlying driver supports this?
> > Is there something I can do to change any setting on the ODBC driver?
> > Thanks for any help.
> >
>
>
>
- Next message: Val Mazur: "Re: Limit in Dataset?"
- Previous message: Val Mazur: "Re: Executing a select statement multiple times?"
- In reply to: Sahil Malik: "Re: ExecuteNonQuery() - Bach SQL Statement execution?"
- Next in thread: Val Mazur: "Re: ExecuteNonQuery() - Bach SQL Statement execution?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
