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.
Maybe better to ask in one of the Access newsgroups, maybe microsoft.public.access.internet, but that may not be the most appropriate. I suggest that you browse through the Access newsgroups to try and determine which would be the best one for your question or post to a number of the most likely ones by inserting all of the addressess into the address control of a single message. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Charles Wilson" wrote in message news:72ao52ljs6mcahbb6kmsatksg3930906po@4ax.com... > 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.
It works the same way using the Inet control: use that entire string as the 'address', and you'll get back whatever the script at the end sends as the page content. "Charles Wilson" wrote in message news:72ao52ljs6mcahbb6kmsatksg3930906po@4ax.com... > 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.
