ODBC / ProvideX problem

[nfalk]

I'm trying to figure out how the programmer before me setup the connection between our MAS90 Db and our SQL Server 2005. (I'm not even sure they had it working before I started).

The problem I'm running into is this error:

[PROVIDEX][ODBC DRIVER][FILEIO] Table is not accessible

My SQL statement looks like:

USE [MAS90_Reporting]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[IM1]
AS
SELECT *
FROM OPENQUERY(MAS90_410, 'SELECT * FROM AR_InvoiceHeader') AS derivedtbl_1

MAS90_410 is the linked Db and I queried the sys.servers table and the connection string looks fine. SO I'm not sure if it's a permissions thing or something else...

Let me know if you need more info and thanks for the help.

 

[GKChesterton]

Is ODBC giving you any visibility anywhere?

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​