Re: How to run a script in ODBC?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 08 Mar 2002 06:41:22 +0100
Message-ID: <2kjg8u43t9cla26ef871i87mjslu0cr19r@4ax.com>

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!
>
>

ODBC is NOT sql*plus. You either need direct ODBC calls or to package your code in a PL/SQL procedure (Hint if you do this you need dynamic sql to create your tables)

Other than that, I think a 3GL program creating tables from a client on the fly should be dumped immediately.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Mar 07 2002 - 23:41:22 CST