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.
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.
