Hi all, first time posting on this forum, but I've been reading it a lot lately. Can't find an answer to this one, any help you can give is appreciated.
We use Sage's MAS 200 ERP system which is set up as a Linked Server in SQL 2000. If I am logged into the server, I can run queries against all tables. When using QA from my new workstation, XP Pro SP3, some work some don't. When it fails I get 1 of the 2 errors below. It might be important to state all queries still work form my old XP Pro SP3 workstation.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [ProvideX][ODBC Driver][FILEIO]No data dictionary found for specified database]
OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandPrepare::Prepare returned 0x80004005: ].
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [ProvideX][ODBC Driver][FILEIO]Table is not accessible]
OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandPrepare::Prepare returned 0x80004005: ].
Here are the queries
From Workstation Works
select * from openquery( MAS90_RPT_LINK, ' select * from GL_Account')
From Workstation Fails
select * from openquery( MAS90_RPT_LINK, ' select * from IM1_InventoryMasterFile')