ms sql queries against informix database[resolved]

[thebloke]

Guys

I'm having a problem running some queries in sqlserver against an informix database. The database is set up as a linked server through enterprise manager and I can run some basic queries using a system DSN named electra:

select * from openquery
(electra,'select * from agent')

fine, however if I try anything more than that, eg:

select * from openquery
(electra, 'select top 10 * from agent')

I get nasty errors:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.  
[OLE/DB provider returned message: ODBC Driver cannot be used because it does not support one or more of the following APIs: SQLTables, SQLColumns, or SQLGetTypeInfo.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005:   ].

This isn't necessarily the query I want to run, there will be a few, it's just that anything I try other than a basic select returns this error.

Any ideas?!

Cheers