I keep getting mixed results when I connect MAS 90 to SQL Server. SOmetimes works, that is the connection works but no tables, other times it works while pulling in all tables. Other times I get:
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)
Help!
Thanks!
