Hey guys!
Thanks very much, working now - updating my MySQL DB from my Arduino ![]()
Thanks to 'doughboy' for the explanation and to 'SurferTim' for the solution.
New code;
byte mac[] = { 0x90, 0xA2, 0xDA, 0x00, 0x89, 0xC9 };
//the IP address for the shield:
byte ip[] = { 192, 168, 0, 14 };
// the router's gateway address:
byte gateway[] = { 192, 168, 0, 1 };
// the subnet:
byte subnet[] = { 255, 255, 255, 0 };
byte dns[] = { 192, 168, 0, 1};
/* Wetdreams.org.uk - 193.238.80.90 */
char server[] = "www.wetdreams.org.uk";
EthernetClient client;
and
void setup()
{
 Serial.begin(9600);
// initialize the ethernet device
Ethernet.begin(mac, ip, dns, gateway, subnet); //just use the default gateway just now
//analogReference(INTERNAL1V1);
delay(1000);
Serial.println("Connecting.....");
if(client.connect(server, 80)){
 Serial.println("connected");
 client.println("GET **get request to DB** HTTP/1.0");
 client.println("HOST: www.wetdreams.org.uk");
 client.println();
}
else{
Serial.println("Failed connection #2");
}
}
I've worked out what my problem was, I previously had a fairly complex Arduino WebServer (with JQuery and everything!) running, so when I went to experiment with the client here, I just copied my code across. Obviously the Client needs to go through the DHCP rigmarole whereas the Server just needs to go as far as the router. My Comms Networks professor wouldn't be happy with that mistake ![]()
Thanks for the help guys, I'm going to mark this as resolved and we can all move on with our lives.