SQL Linked Server and MAS90 (ProviderX ODBC)

Posted on 2011-10-18
Medium Priority
Last Modified: 2012-05-12
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.

Any ideas?
Question by:mcballar65
  • 3
LVL 17

Expert Comment

by:Chris Mangus
ID: 36989729
It sounds like permissions.  In your linked server, under the security tab, have you left the defaults in place?  If so, you may want to hardcode an account here with permissions to the remote database.

Author Comment

ID: 36992267
I've tried it with the defaults and the remote user and get the same results.  The actual user information is embedded in the provider string that is set up in the linked server defintion.  Also the fact that it works from the hosting SQL server lends me to believe it's not related to the ODBC permissions?

Accepted Solution

mcballar65 earned 0 total points
ID: 36993825
I figued this out.  Basically, even if you're using SSMS conneting to a linked server, the client performing the query has to have the Sage MAS90 client software installed (I presume a licensing safeguard of some sort).  As soon as I installed the client software, my SSMS connected queries worked as expected.


Author Closing Comment

ID: 37016589
Figured this out by luck :)

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question