I am trying to link remote MAS 90 DB's to my LOCAL SQLServer. I am getting mixed results. In some cases it makes a connection but pulls no tables. At other times I get a network connection error. Yet still, I get one connection that brings in the tables in the catalogs. All connections are treated the same. What do I need to do to make all consistent?
I am using network share names to get to the MAS 90 home paths, they connect just fine. Two are in the office on the network and the rest are on a VPN, the connection passes on the VPN but no files on some of them.
One of the errors I get is:
Connection failed.
[ProvideX][ODBC Driver][ISAM]ISAM communication error.
More:
TITLE: Microsoft SQL Server Management Studio
------------------------------
The linked server has been created but failed a connection test. Do you want to keep the linked server?
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MAS_BRS".
OLE DB provider "MSDASQL" for linked server "MAS_BRS" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "MAS_BRS" returned message "[ProvideX][ODBC Driver][ISAM]ISAM communication error". (Microsoft SQL Server, Error: 7303)
