How to execute script.sql from VB6

From: Aleem A Mohammed (aleem.mohammed@datastructures.com)
Date: 09/24/02


From: "Aleem A Mohammed" <aleem.mohammed@datastructures.com>
Date: Tue, 24 Sep 2002 13:36:55 -0700


I am not a VB Guru or something but I can guide you to use
soemthing called OSQL

OSQL -Uusername -Ppassword -i c:\path\filename.sql

This can be executed using command prompt.

I hope this will help you.

Aleem A Mohammed

>-----Original Message-----
>Hi group... I have a question for your. How can I
execute a script.sql
>from VB6.0 like a file, this file was created in SQL
Server 2000 and
>conteins code to create database and tables.
>
>--------------------------------
>Atte.
>
>Ing. Juan Manuel Alegría Bobadilla
>jmanuel@mbge.com.mx
>
>Guadalajara, Jalisco, México
>
>
>.
>



Relevant Pages

  • Re: Question Multi A/V Tool
    ... You have to execute NET START WORKSTATION in a Command Prompt. ... What I get in the Command Prompt window is that the service has already been ...
    (microsoft.public.security.virus)
  • DWMX comes up for .net executable
    ... Then went to the console (command ... Well when I go to execute the program Dreamweaver opens up in the code ... of the picture and my program to execute through the command prompt ...
    (microsoft.public.vsnet.setup)
  • Re: Running a program from a SQL job
    ... This works fine when running it either as a bat file or just in a cmd ... When I set the SQL job to execute the same bat ... >> command prompt in the background which SQL apparently doesn't do. ... >> command prompt and then execute a program from there. ...
    (microsoft.public.sqlserver.server)
  • Re: Cant CreateProcess from custom shell
    ... I can't execute ... > from the command prompt as I am running my own custom shell. ... I include "CMD- Windows Command Processor" in my images ...
    (microsoft.public.windowsxp.embedded)
  • Re: Sysclean
    ... In WinXP SP2 open a Command Prompt and execute... ... transfer the executable to the problem machine and run it. ...
    (microsoft.public.windowsxp.general)