Thankyou so much for the wealth of information provided. I appreciate that. I luckily found out that the ODBC file on my machine was tampered. I had it exported from a different machine and ran the file. Bingo, im now able to connect without problems.
Once again, thank you for your efforts involved.