Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

XML to a database

Options
  • 23-11-2005 4:42pm
    #1
    yeraulone
    Registered Users Posts: 597 ✭✭✭


    I have a situation where I need to update a database with information on an XML page. This is done by using a .vbs script. This script is to be run at random times and by a service know as "Windows Scheduler Service". Its news stories, so it has to be automated.

    So my question is, who sets this on a webserver? Or how can it be done? Has anyone ever dealt with this process before?

    Thanks


Comments

  • Options
    #2
    Seth Brundle
    Moderators, Politics Moderators Posts: 39,930 Mod ✭✭✭✭Seth Brundle


    Do you have access to the server?


  • Options
    #3
    yeraulone
    Registered Users Posts: 597 ✭✭✭yeraulone


    I do - I just found out that the .vbs script has to actually sit on my machine and the file has to reference the database on a webserver. I didn't actually think it was possible - is it??

    If it is, does that mean my connection would have to be something like:

    Set DbConn = Createobject("adodb.connection")
    DbConn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=http://www.blah.com/casinonewsxml.mdb"

    Sorry - new to this.


Advertisement