Results 1 to 7 of 7

Thread: SQL LOADER with VB --> Example

  1. #1

    Thread Starter
    Fanatic Member mutley's Avatar
    Join Date
    Apr 2000
    Location
    Sao Paulo - Brazil
    Posts
    709

    SQL LOADER with VB --> Example

    Hi

    Somebody have a example using VB with Sql Loader ?


    Thank you in advance

  2. #2
    Frenzied Member SeanK's Avatar
    Join Date
    May 2002
    Location
    Boston MA
    Posts
    1,160

    Re: SQL LOADER with VB --> Example

    Have a look here
    Beantown Boy
    Please use [highlight=vb]your code goes in here[/highlight] tags when posting code.
    When you have received an answer to your question, please mark it as resolved using the Thread Tools menu.

  3. #3

    Thread Starter
    Fanatic Member mutley's Avatar
    Join Date
    Apr 2000
    Location
    Sao Paulo - Brazil
    Posts
    709

    Re: SQL LOADER with VB --> Example

    ?

    It is not a solution

  4. #4
    Frenzied Member SeanK's Avatar
    Join Date
    May 2002
    Location
    Boston MA
    Posts
    1,160

    Re: SQL LOADER with VB --> Example

    Quote Originally Posted by mutley
    ?

    It is not a solution
    It is the only thing I found and it does have work arounds.
    Beantown Boy
    Please use [highlight=vb]your code goes in here[/highlight] tags when posting code.
    When you have received an answer to your question, please mark it as resolved using the Thread Tools menu.

  5. #5
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,495

    Re: SQL LOADER with VB --> Example

    Did you try shelling the SQL*Loader to a command prompt? All the peices can be included in a control file and use that on the call.
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

  6. #6
    Frenzied Member SeanK's Avatar
    Join Date
    May 2002
    Location
    Boston MA
    Posts
    1,160

    Re: SQL LOADER with VB --> Example

    By the way....what the heck is SQL Loader?
    Beantown Boy
    Please use [highlight=vb]your code goes in here[/highlight] tags when posting code.
    When you have received an answer to your question, please mark it as resolved using the Thread Tools menu.

  7. #7
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,495

    Re: SQL LOADER with VB --> Example

    It is a buld data loader for Oracle DB. You must have the SQL*Net software loaded on the computer you want to use it on (unless the DB is on that machine). You also need a TNSNames file entry for the database you want to connect to.
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width