Hi,

It seems that the DSN wasn't created in the workstation or the ODBC driver didn't exist.
To connect a remote database, the PC must have the driver installed first.
Then, it may need a DSN created in the PC or a DSN-less connection in the VFP database.

:) Wilfred

>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