请教一个openrowset的问题！

[bushy]

Informix and openrowset
select *
from openrowset ('ifxoledbc','data source=/pbook/build/
pbook/;uid=abc123;pwd=abc123','select vendor from hold_item')

提示错误是：
Could not locate registry entry for OLE DB provider 'Ifxoledbc'.
OLE DB error trace [Non-interface error: Provider not registered.].

还有date soure感觉配置也不对，正确的格式着么写，谢谢了！
希望各位能提供一个完整的例子，通过informax

[wgzaaa]

http://topic.csdn.net/t/20041022/12/3480986.html
select * from
OpenRowset('MSDASQL'
,'DSN=scmtest;DATABASE=acdbshop;uid=rbscm;pwd=rbscm_2004'
,'select * from supply') as a

[bushy]

MS SERVER 我知道这样连接，但用ifxoledbc，连接不起来！

[bushy]

谢谢了

[budong0000]

给个excel的；

OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source="C:\ExcelData.xls";Extended properties=Excel 8.0')...Sheet1$

[bushy]

还是谢谢了，
但我最需要的是
select *
from openrowset ('ifxoledbc','data source=/pbook/build/
pbook/;uid=abc123;pwd=abc123','select vendor from hold_item')


Informix and openrowset，这个的真确使用方法

[bushy]

置顶！

[wgsasd311]

不懂,帮顶