Re: Need help with using HTTP from VBA in Access 2003.

Have a look at:

http://www.mvps.org/access/modules/mdl0037.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"Janet Wilson" <nospam@xxxxxxxxxx> wrote in message
news:3h9o52ts8vfikuhn0c522dv9q61l4mapp4@xxxxxxxxxx
Can someone point me to some good instructions on using the
WinInet.dll functions from VBA?

I need to interact with a MySQL database via HTTP strings.
We already have the database set up and a PHP script that can receive
commands via HTTP. The script receives the HTTP commands and performs
the database actions, then responds with XML.

This system already works when I test it from IE. I simply send it an
HTTP string similar to this:


http://www.lmc.bz/tblAdvisories.php?username=UserNameHere&password=PwdHere&q
uery=SELECT%20%2A%20FROM%20tblAdvisories%20WHERE%20contact_id%20%3D%2012

The PHP script executes the query and sends back the results in XML. I
just need to know how to set up the VBA code to send the requests. I
THINK I must use WinInet functions to do this. Am I correct, or is
there a simpler way to do it, perhaps using ADO?

More info is available if needed.

Thanks,

JW


.

Relevant Pages

  • Re: Re: Need help with using HTTP from VBA in Access 2003.
    ... See http://www.QBuilt.com for all your database needs. ... was for a charity to tutor disadvantaged youth, yada, yada, yada. ... I need to interact with a MySQL database via HTTP strings. ... The PHP script executes the query and sends back the results in XML. ...
    (microsoft.public.access.forms)
  • Re: HTTP 403
    ... just saying HTTP 403. ... Then when you click "Sign Up" the same script ... was if I, if using your code, can use the given inputs, username and ... variables for checking against a database table with approved users. ...
    (comp.lang.php)
  • Re: connect databases via http
    ... Do you know of any means to connect two Oracle 10g databases via http ... use a database link in source and select data from target. ... you would not be talking HTTP protocol - but SQL*Net or Oracle Net or whatever it is called today on ports "reserved" for HTTP/HTTPS... ...
    (comp.databases.oracle.server)
  • Re: Need Access 2K3 VBA code for using WinInet functions
    ... I need to interact with a MySQL database via HTTP strings. ... THINK I must use WinInet functions to do this. ... Windows Internet - WinINet Reference ...
    (microsoft.public.access.developers.toolkitode)
  • Re: HTTP 500 Internal Server Error while running ASP page
    ... you need to turn off the "Show friendly HTTP error ... > I made a guest book with ASP page and MS access 2000. ... > can display data from the database via my asp page. ... > HTTP 500 Internal Server Error ...
    (microsoft.public.frontpage.programming)
Loading