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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

XML to a database

  • 23-11-2005 3:42pm
    #1
    yeraulone
    Registered Users, Registered Users 2 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

  • #2
    Seth Brundle
    Moderators, Politics Moderators Posts: 41,211 Mod ✭✭✭✭Seth Brundle


    Do you have access to the server?


  • #3
    yeraulone
    Registered Users, Registered Users 2 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