Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. Web Development
  3. ASP.NET
  4. reg. database connection thru .bat file

reg. database connection thru .bat file

Scheduled Pinned Locked Moved ASP.NET
csharpasp-netdatabaseoracletools
2 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    montu3377
    wrote on last edited by
    #1

    Hi , I have to upload .csv file data to oracle 10g database from asp.net 2.0 page. As .csv file data are too much large (around 200,000 records) so decided to insert it using Sqlloader utility of oracle. Now to execute sqlloader utility from asp.net web page i have to use .Bat file(Batch file) and where .bat file will take oracle database connection and in first parameter as .csv file. Now i don't know how to take database connection to oracle from .bat file?? even i don't know is it possible or not ?? if it's not possible then what should be the alternative way to take database connection with oracle from .bat file?? Is any article /sample code /link then will be good for me. Thanks in advance. Regards, montu3377

    V 1 Reply Last reply
    0
    • M montu3377

      Hi , I have to upload .csv file data to oracle 10g database from asp.net 2.0 page. As .csv file data are too much large (around 200,000 records) so decided to insert it using Sqlloader utility of oracle. Now to execute sqlloader utility from asp.net web page i have to use .Bat file(Batch file) and where .bat file will take oracle database connection and in first parameter as .csv file. Now i don't know how to take database connection to oracle from .bat file?? even i don't know is it possible or not ?? if it's not possible then what should be the alternative way to take database connection with oracle from .bat file?? Is any article /sample code /link then will be good for me. Thanks in advance. Regards, montu3377

      V Offline
      V Offline
      Vasudevan Deepak Kumar
      wrote on last edited by
      #2

      You can invoke a VBS from within a BATCH file which can use ADO right?

      Vasudevan Deepak Kumar Personal Homepage Tech Gossips

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups