Hi folks
I'm looking to try and find out how to run a query from database a on server b, via a cron job on server b, that will then save on server a database
thank you
David
you don't run a query from a db, so im not sure what you are asking.
to query a db on another server you just specify its ip in the connection
Have tried to do the ip but keep getting cannot connect to server
just wondere if i was doing anything wrong
has the server\database been set up to allow remote connections?
I've set it up in cpanel to allow connections anything else?
what's the exact error message being returned?
Cannot connect to database
it tries for a minute or so then sprouts the error
assuming ip, user-name, password is correct, you may have to ask your host to see if they have anything set-up that may be an issue.
