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 |
|
bombdrop
Starting Member
5 Posts |
 Posted - 2004-04-29 : 04:43:52
|
[code]select ptq.*from OPENROWSET('SQLOLEDB','ServerName'; 'sa';'',"SELECT * FROM ace.dbo.client") ptq[/code]This works fine on one of my servers but i get the following error on my other server quote:
Server: Msg 7302, Level 16, State 1, Line 1Could not create an instance of OLE DB provider 'SQLOLEDB'.
Anyone got any ideias why??? Thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-04-29 : 04:57:29
|
| Is the version of MDAC the same on both servers? If not, this may cause problems on the lower versioned machine... |
 |
|
|
|
|
|
Problem with OPENROWSET