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 |
|
srinii2005
Starting Member
6 Posts |
 Posted - 2009-03-20 : 14:09:36
|
| I am trying to Connect DB2 DataBase from SQL Server2005 without using Linked Server..When i tried to call a select query from th SQL Serer Views, select test AS test1 from OPENROWSET('DB2CLI', 'Provider=DB2CLI;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=****;Data Source=****','Select trim(sample) as sample1 from XYZ.columnname')..im getting folowing error..OLEDB Provider DB2CLI is not registered..Can anyone please help me.. |
|
|
|
|
|
OPENROWSET Query