Re: Bulkloading external xml file

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Paulo (paulo_at_msdn.com)
Date: 12/02/04 

Date: Thu, 2 Dec 2004 04:41:02 -0800

Alright, but how can I retrieve it and save it to a local file? Would please
write a VBScript example?

"Dennis Redfield" wrote:

> I do not believe that the execute method implements http resolution - you
> will need to resolve and retrieve your data either into a stream or to a
> local file and pass the stream or file reference to the execute method.
>
> dlr
>
> "Paulo" <paulo@msdn.com> wrote in message
> news:7FDD076C-0CA9-4FCD-A93B-45AF015D5917@microsoft.com...
> > Can I call an external url which requests a xml file when executing a
> > BulkLoad operation? I'm getting the error message:
> > Error opening the datafile. Code:80004005.
> > There is no problem with my database connection and I am able to access
> the
> > url from an internet browser.
> >
> > Below is my code:
> > set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
> > objBL.ConnectionString = "provider=SQLOLEDB.1;data
> > source=localhost;database=db0681;uid=sa;pwd=as"
> > objBL.ErrorLogFile = "d:\xml\error.log"
> > objBL.Execute "AddressSchema.xml",
> >
> "http://mypartnerurl.com/addresslookup.pce?postcode=AAA&userId=myUser&passwo
> rd=pwd"
> > set objBL=Nothing
>
>
>

Relevant Pages

  • Re: C code for Internet Access
    ... > Can someone provide me with a simple prototype for internet access ... That will retrieve the URL and store it in the local file as given ... you can parse it locally using some program you write. ...
    (comp.lang.c)
  • [exploits] phpMyVisites 1.3 local file retrieval
    ... Remote user can retrieve local file on the webserver ... Contact the Vendor ...
    (Bugtraq)