SQL Linked Server and MAS90 (ProviderX ODBC)
Posted on 2011-10-18
I have a linked server established using ODBC drivers provided to Sage software for MAS90 from a company called ProviderX. On the SQL server where the ODBC drivers are installed (MAS90 client as well) - the linked server works fine - I can make SQL select calls to the linked server successfully.
When I try to connect form any other location via SSMS I get the follow error message.
OLE DB provider "MSDASQL" for linked server "mas90" returned message "[ProvideX][ODBC Driver][FILEIO]Table is not accessible".
Msg 7306, Level 16, State 2, Line 1
Cannot open the table "gl_account" from OLE DB provider "MSDASQL" for linked server "mas90".
gl_account is a valid table in the schema of the linked server - and the select statement "select * from mas90...gl_account" works fine from the actual sql server but not from anywhere else.