Need help with sending HTTP strings from Access VBA.
- From: Charles Wilson <dontsendspam@xxxxxxxx>
- Date: Fri, 05 May 2006 23:41:22 -0500
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.myweb.com/tblAdvisories.php?username=UserNameHere&password=PwdHere&query=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.
.
- Follow-Ups:
- Re: Need help with sending HTTP strings from Access VBA.
- From: '69 Camaro
- Re: Need help with sending HTTP strings from Access VBA.
- Prev by Date: Re: Problem adding records via Data***
- Next by Date: Session specific GUID
- Previous by thread: Re: Howto Clear unbound Listbox Items
- Next by thread: Re: Need help with sending HTTP strings from Access VBA.
- Index(es):