openquery error 0x8000ffff

[gcole]

I have a linker server to an informix database. It quit working on Friday. Some of the drivers I needed were missing. I reinstalled and I can see the tables and views in the linked server but when I run :

select commodity
FROM OPENQUERY(ONLINE_TCP, 'SELECT * FROM adsave')

I get:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. The provider reported an unexpected catastrophic failure.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBProperties::GetProperties returned 0x8000ffff: The provider reported an unexpected catastrophic failure.].

Any ideas?

 

[nice95gle]

When you reinstalled you might of install a old version of MDAC by mistake. From what I can remember MDAC should be 2.5 or higher.

How to check MDAC version

http://support.microsoft.com/kb/301202

Well Done is better than well said
- Ben Franklin

 

[monksnake]

I ran into this on my google search for your error, it may help you out.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=53092&SiteID=1

States this as a fix to encountering that error:

Here are the steps to resolve the problem.
1. In OBDC, while creating the DSN (with the Sybase server name as DSN name) the database name should not be given.

2. In the Linked server properties only the Data source should be given. Remote login (sa and pwd) and in server options only Collation compatible and Data Access are to be selected.

3. The default database for sybase 'sa' login was taken as the user database for which the tables are to be linked.

The above solution works perfectly without issues.

Hope it is helpful to all.
Regards
Geeta

<.

 

[gcole]

The final on this is that we are using very old infomrix drivers. Rebooting several systems has fixed this. We are looking into getting newer drivers.