Lester, > OK it's been probably 10 years since I played with some of this stuff. SO I > need a bit of a sanity check. > > I'm running PHP most of the time, although the old windows stuff is still > working as well. Everything runs off network connections, and I don't > normally have any problems, but one site has asked if we can send SMS > messages for the next days appointments. No problem, I have a PHP script > which generates the XML file to go to the SMS messaging service. Now just > need to 'schedule' it, but when running the script from the command line it > fails as it can't find the network :( > > No I should be able to access the database using a local connection? This is > on > the main server. Question is how ... and will that cause any problems with > the main web server side?
There are a couple of possible sources to your problem, so need to ask some questions to start with. What Firebird version # are you running? If pre v2.5, are you running SuperServer or Classic? What OS is the local machine running? If Win Vista/7 or 2008, (a) what user context/credentials is the scheduled script running in? (b) Has UAC been disabled? What is the status of the Windows Firewall? Can you run/schedule other scripts? If so, can you run/schedule scripts which access network resources? Sean
