ODBC / ProvideX problem
ODBC / ProvideX problem
(OP)
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.
Talk To Other Members
RE: ODBC / ProvideX problem
DBC giving you any visibility anywhere?researchdatabase development, would it? -- Albert Einstein