Executing SQL via MDAC ODBC multiple statements?

From: Richard Adams <ackthpt_at_concentric.net>
Date: 9 Jan 2004 15:10:11 -0800
Message-ID: <c2352af0.0401091510.9904358_at_posting.google.com>

Is it possible to execute more than one statement in SQL via MDAC ODBC? I have a fairly complex select I wanted to create a view with, but trying to send it all as one string with terminators ';' between doesn't work (invalid character.) How can I do this kind of thing from VB.NET?

Thanks in advance
Richard Received on Sat Jan 10 2004 - 00:10:11 CET

This message: [ Message body ]
Next message: Axel Dachtler: "meaning of TNS (Transparent Network Substrate)"
Previous message: leecho_at_unitem.edu.my: "user authorazation"
Next in thread: Justin Cave: "Re: Executing SQL via MDAC ODBC multiple statements?"
Reply: FaheemRao: "Re: Executing SQL via MDAC ODBC multiple statements?"
Reply: Justin Cave: "Re: Executing SQL via MDAC ODBC multiple statements?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message