SQL Server Performance Forum – Threads Archive

sp_addlinkedserver

I wanted to be able to select data from server A and insert into server B, so in server B I ran this procedure: sp_addlinkedserver @server =’BSCCMARS’
, @srvproduct = ”
, @provider = ‘SQLOLEDB’
, @datasrc = ‘BSCCMARS’
, @location = ”
, @provstr = ‘BSCCMARS’ (1 row(s) affected) and then did (still in server B): insert into dbnameB.dbo.rawdata select * from
bsccmars.dbnameA.dbo.rawdata and I got this error: Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider ‘SQLOLEDB’ reported an error.
[OLE/DB provider returned message: Invalid connection string attribute]
OLE DB error trace [OLE/DB Provider ‘SQLOLEDB’ IDBInitialize::Initialize returned 0x80004005: ]. Did I input anything wrong in sp_addlinkedserver? Thanks for your help in advance.

---

Never mind. @provstr should have been set to NULL in this case.

---

]]>