SQL Linked Server and MAS90 (ProviderX ODBC)

Posted on 2011-10-18
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
    LVL 17

    Expert Comment

    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

    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

    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

    Figured this out by luck :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now