Ok, I have set it all up perfectly im sure, everything has worked fine including restoring the databases all worked first time.
Ok, when I load ODBC and try to set it up, it wont show me any SQL servers, I am setting it up on my PC so it should say Local when I try to add a SQL server on ODBC...