Re: How to run a script in ODBC?

From: corey lawson <corey.lawson_at_worldnet.att.com>
Date: Mon, 11 Mar 2002 03:13:44 GMT
Message-ID: <3c8c2031.30559188@netnews.att.net>

Sure, but you'll have to call sqlplus to do it with WinExec() or something in your C/C++ program.

Or write a parser to read the DDL in your C program in the "script" file. Simple enough to do. ODBC will send DDL (do it in "passthrough" mode, though) to Oracle for processing.

On Fri, 8 Mar 2002 09:26:27 +1100, "zhao" <zhaohui_at_goconnect.net> wrote:

>Hi,
>
>Is it possible to run an Oracle script from VC6? I am working through an
>> ODBC and need to run a scripts to create a number of tables for a user.
>> The syntax I am using is :
>>
>> myDatabase.Execute "@c:\Script.sql";
>> I receive and "Invalid SQL Command" error when it is run, but the command
>> works when pasted in SQLPlus....
>>
>> All suggestions appreciated!
>
>
>
Received on Sun Mar 10 2002 - 21:13:44 CST