Re: Using VB to control isqlplus/sql scripts
From: Brian E Dick <bdick_at_cox.net>
Date: Fri, 13 Sep 2002 12:18:14 GMT
Message-ID: <aIkg9.17967$8F4.628849_at_news2.east.cox.net>
Date: Fri, 13 Sep 2002 12:18:14 GMT
Message-ID: <aIkg9.17967$8F4.628849_at_news2.east.cox.net>
Use WScript.Shell or some other process API to execute sqlplus.
"Pike" <voidrubbish_at_hotmail.com> wrote in message
news:8e8fa11e.0209121310.3b26bed4_at_posting.google.com...
> Hi,
>
> I know this probably has an obvious answer, but I've searched the web
> for over an hour and can't find it. The problem goes...
>
> In isqlplus I have a script which I run with something like
>
> _at_file.sql
>
> or
>
> start file.sql
>
> where file.sql contains numerous sql statments, and spools comments to
> a log file.
>
> How would I automate this process in VB? I won't be able to use a
> standard ADODB.Connection object as that won't do the log file
> spooling.
>
> Thanks!
>
>
> Pike
Received on Fri Sep 13 2002 - 14:18:14 CEST