December 11, 2009 at 10:29 am
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')
December 30, 2009 at 6:17 pm
Figured it out.
Open Enterprise Manager, Right Click on the SQL Server Group. "Edit SQL Server Registration Properties..."
.... Why, why, why didn't I think of it before. Back to basics.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply