Hi All;
I created a connection to a Microsoft SQL server. It worked fine and managed to create remote views from the remote database, however, creating the same connection in another station disable the first connection and I get this error message. Connectivity error :[microsoft][ODBC driver manager]data source name not found and no default driver specified. This message is displayed whenever i try to use the remote view from any workstation except the last one where the connection is created or modified.

Resolution or suggestions are appreciated.

Thanks