Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Radha S
Starting Member
1 Post |
 Posted - 2009-12-03 : 01:06:10
|
| Hi,I am running a query "SELECT * FROM OPENQUERY([%s], 'SELECT 1')", strDestServer" in sql server 2000 from my application. This is giving OLE DB error trace [Non-interface error: OLE DB provider unable to process object, since the object has no columnsProviderName='SQLOLEDB', Query="...." in some sql 2000 databases alone. what could be the cause? I found the solution that we have to use 'Set FMTONLY OFF' with the query... but how it is working fine in some sql 2000. Kindly help me if any one faced this kind of issue and what solution you have made. Also is there any alternative solution instead of making changes in query.. Is Microsoft gave any SP with the fix... Kindly help me. Thanks. |
|
|
asuni
Yak Posting Veteran
55 Posts |
Posted - 2010-03-22 : 07:46:09
|
| This kind of error normally comes because we have to check the checkbox at linked servers->Provides->properties of particular provider which u r using. |
 |
|
|
|
|
|
OPENQUERY retunrs NoColumn Error