• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1487
  • Last Modified:

SQL Linked Server and MAS90 (ProviderX ODBC)

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?
  • 3
1 Solution
Chris MangusDatabase AdministratorCommented:
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.
mcballar65Author Commented:
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?
mcballar65Author Commented:
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.

mcballar65Author Commented:
Figured this out by luck :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now