Re: ExecuteNonQuery() - Bach SQL Statement execution?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Val Mazur (group51a_at_hotmail.com)
Date: 11/09/04 

Date: Tue, 9 Nov 2004 18:59:39 -0500

Hi,

You would need to check documentation for the ODBC driver, but as I know
only OLEDB for SQL Server provider does it. To test if it supports batches
or not, you would need to separate statements with the semicolon (;) and run
this batch. See what happens. If it does not work this way, than most likely
driver/provider does not support this functionality 

-- 
Val Mazur
Microsoft MVP
"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.
>

Relevant Pages

  • RE: MS SQL, find list of tables
    ... connected to the Access ODBC driver. ... MS SQL, find list of tables ... Audit your website security with Acunetix Web Vulnerability Scanner: ... Up to 75% of cyber attacks are launched on shopping carts, forms, ...
    (Pen-Test)
  • Re: Strange ODBC error
    ... I have googled for this error, and it seems to be a very common Oracle ... SQL returns the error above. ... please use Oracle's ODBC driver. ... understand how the first SQL sent by the application works ok, ...
    (comp.databases.oracle.misc)
  • iSeries ODBC and Memory Leaks
    ... I'm using IBM's iSeries Access ODBC driver to access data from ... SQL 2005 via a Linked Server and with SQL Integration Services. ... mentions ODBC memory leaks. ... IBM DB2 for OS/400 V5R1 and later ...
    (microsoft.public.sqlserver.odbc)
  • Re: syntax error at or near "{" at character 86(#-1)
    ... Connecting using the PostgeSQL ODBC driver. ... tracking turned on and it shows a different statement SQL statement created ... in Access than is being actually sent to SQL. ...
    (microsoft.public.access.queries)
  • Re: uploading file into sql 2005 using .asp
    ... I also noticed that you are using the ODBC driver. ... take note that this code works perfectly well when inserting into SQL 2000 ... Anyone who can send me a sample code of how to upload a file into SQL ... the browser and the web server or between the web server and the ...
    (microsoft.public.inetserver.asp.db)