Execute SQL Script File through VB RRS feed

  • Question

  • I have a SQL Scrip file (oracle). I unable to run the following script by using ado object in vb 6.

    adoConnection.Execute "@ " & strScriptFileName

    In oracle, we are using
    @<Script File name path>. This is working in Oracle perfectly. Why is this not working in vb?

    The above line returns error as 'Invalid SQL Command'. I want to execute this script file vb itself. Please reply to me if anyone have suggestions.


    • Edited by Diamond.Jegan Friday, September 26, 2008 7:36 AM
    • Moved by Xingwei Hu Tuesday, September 30, 2008 5:07 AM Visual Basic 6 questions (Moved from Visual Basic Language to Off-Topic Posts (Do Not Post Here))
    Friday, September 26, 2008 7:09 AM

All replies