Thanks Flame. I followed the steps in the link you gave. I got to where it prompted for id and password and click next after that but it gives error message as below.
SQL ServerError: 14
[Microsoft][ODSC SQL Server Driver][DBNETLIB]ConnectionOpen (ParceConnectParams()).
SQL Sever Error: 14
[Microsoft][ODSC SQL Server Driver][DBNETLIB]invalid connection.
At the point it promted for Name; Description; and Server, I had used
Wallchart Live Data as name
Optional as Description and
22.214.171.124:1433 as IP.
Please what could be the problem and what should I do.