Calling a remote PHP script from within Access?

[jj]

Is it possible to call a remote php script from within Access? I'm thinking
something like:

DoCMD... http://www.domain.com/scripts/dataquery.php
DoCmd.OpenQuery "update_dat a", acNormal, acEdit
.....

So the PHP script does something on the server database, then when a linked
table is viewed within access, the data changes have been made?

The problem is, ODBC is too slow for certain things and if I can call a php
script and have it run the more intense data queries on the server, it'd be
a lot faster.

Is this possible?

[jj]

After I closed and opened access again, the pass through query is working.
Kind of odd but that did the trick.

I guess there isn't a quick way to do an INSERT from the desktop to the
remote database? There's around 3,000 records and it runs for about 5-10
minutes. But that can't be done by a pass-through query since it's going
desktop --> server. Any other suggestions to speed that process up?

"jj" <[e-mail]> wrote in message
news:jk******** **********@twis ter.rdc-kc.rr.com...

Here's what it creates in the ODBC Connect Str field:
ODBC;DSN=XXXX;D ESC=MySQL ODBC 3.51 Driver
DSN;DATABASE=de velop;SERVER=11 1.111.111.118;U ID=develop;PASS WORD=pass223;PO R T=3306;OPTION=3 ;STMT=;

Does that look right?

The error it returns is:
The Microsoft Jet database engine cannot find the input table or query
'ODBC;DSN=XXXX; DESC=MySQL ODBC 3.51 Driver DSN;DATABASE=de velop;SE'. Make
sure it exists and that its name is spelled correctly.
Hmmm.... it's like it's reading the connection string as the query?

"Phobos" <la******@spamm ers.co.uk> wrote in message
news:xo******** ************@br ightview.com...

"jj" <[e-mail]> wrote in message
news:Gu******** **********@twis ter.rdc-kc.rr.com...

The only strange thing is, if I leave it to default ODBC; and I select the ODBC DSN when running the query, it works fine. When I use the ... build connection method and try to store the connection info, I get an error

back

about it not being to find the connection or table.

Strange, are you sure that your connection string is correct?

Also, read the help files as pass-through queries can be a bit
temperamental.

Thanks!

You're welcome.

P

[David W. Fenton]

rp*****@aol.com (Rich P) wrote in
<3f************ *********@news. frii.net>:

You are sort of mixing apples and oranges (I think). I do ASP and
JSP which operate in web servers. I believe PHP is the same
thing. I am assuming your data server is either Oracle or
Microsoft Sql Server. In either case you can use ADO to invoke
stored procedures on your data Databases. That would be the
fastest way to get a result set. It is true that you can invoke
stored procedures from a webpage, ASP, JSP, PHP, but that would be
a hands on ineraction. You are asking if you could invoke the PHP
command from Access, that would be like using send keys to type
something in your webpage (assuming the browser is up and
running).

While it is certainly better to use the pass-through query, as you
suggested, there is absolutely nothing wrong with executing a
remote script on a web server from Access. I've done it in cases
where I had no way of actually connecting to the remote server, and
it's accomplished in exactly the same way as if a user wanted to
open any old web page, you just execute a URL. I don't let Access
handle it, but instead use the Windows ShellExecute API, because
this will use the default browser, whereas the native Access
functions will use Internet Explorer even if a good browser such as
Mozilla is the default browser.

In any event, conceptually, there is nothing wrong with the idea of
executing a remote PHP script from Access. I've done it in order to
remotely initiate a text file data dump a remote MySQL database
that is then FTP'd to the local system.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[ss]

Cool, do you have an example of this?

Is there a way to call the remote URL without opening a browser?

Is there also a way for Access to call this remote web page and look for a
specific variable? Say the remote PHP runs it's script then returns a var =
yes and if the var = yes access would run another query? if var = no Access
wouldn't do anything else at that point?

Thanks in advance.

"David W. Fenton" <dX********@bwa y.net.invalid> wrote in message
news:94******** *************** ****@24.168.128 .78...

rp*****@aol.com (Rich P) wrote in
<3f************ *********@news. frii.net>: While it is certainly better to use the pass-through query, as you
suggested, there is absolutely nothing wrong with executing a
remote script on a web server from Access. I've done it in cases
where I had no way of actually connecting to the remote server, and
it's accomplished in exactly the same way as if a user wanted to
open any old web page, you just execute a URL. I don't let Access
handle it, but instead use the Windows ShellExecute API, because
this will use the default browser, whereas the native Access
functions will use Internet Explorer even if a good browser such as
Mozilla is the default browser.

In any event, conceptually, there is nothing wrong with the idea of
executing a remote PHP script from Access. I've done it in order to
remotely initiate a text file data dump a remote MySQL database
that is then FTP'd to the local system.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Steve Jorgensen]

I think the Windows port of the wget program should do exactly what you're
asking. See http://unxutils.sourceforge.net/. If you try this, it would
be nice if you post back and tell us if it worked for you.

On Thu, 09 Oct 2003 04:51:33 GMT, "ss" <[e-mail] > wrote:

Cool, do you have an example of this?

Is there a way to call the remote URL without opening a browser?

Is there also a way for Access to call this remote web page and look for a
specific variable? Say the remote PHP runs it's script then returns a var =
yes and if the var = yes access would run another query? if var = no Access
wouldn't do anything else at that point?

Thanks in advance.

"David W. Fenton" <dX********@bwa y.net.invalid> wrote in message
news:94******* *************** *****@24.168.12 8.78...

rp*****@aol.com (Rich P) wrote in
<3f************ *********@news. frii.net>:

While it is certainly better to use the pass-through query, as you
suggested, there is absolutely nothing wrong with executing a
remote script on a web server from Access. I've done it in cases
where I had no way of actually connecting to the remote server, and
it's accomplished in exactly the same way as if a user wanted to
open any old web page, you just execute a URL. I don't let Access
handle it, but instead use the Windows ShellExecute API, because
this will use the default browser, whereas the native Access
functions will use Internet Explorer even if a good browser such as
Mozilla is the default browser.

In any event, conceptually, there is nothing wrong with the idea of
executing a remote PHP script from Access. I've done it in order to
remotely initiate a text file data dump a remote MySQL database
that is then FTP'd to the local system.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Phobos]

"jj" <[e-mail]> wrote in message
news:c5******** ***********@twi ster.rdc-kc.rr.com...

After I closed and opened access again, the pass through query is working.
Kind of odd but that did the trick.

I guess there isn't a quick way to do an INSERT from the desktop to the
remote database? There's around 3,000 records and it runs for about 5-10
minutes. But that can't be done by a pass-through query since it's going
desktop --> server. Any other suggestions to speed that process up?

Other than saving the records to a floppy and sending it by post? <g>

5-10 minutes is not that bad to be honest.

P