Its an SQL problem but I am writing in PHP so my apologies to Admin and feel free to move this if you think it would be better located.

I have some working code to access the database on the same server but if I try to change it to the database on a separate server it will not work. Surely this can be done or am I wasting my time and remaining hair?

Many thanks for your help.