I want to update with same tables an online sql server with local data of a
software.

The online and local tables structures are the same, the name of the table
also.

I receive this error:

Errore -2147217900
OLE DB provider "SQLNCLI" for linked server "(null)" returned message
"Unspecified error".

the code is:

set connACC=Server.createobject("adodb.connection")
connNostrosql1 = "Provider=SQLOLEDB;Data
Source=**.**.**.**;database=030918ferwoodsrl;uid=* *;pwd=**;"
connACC.Open connNostrosql1

INSERT INTO MAGAnagraficaArticoli SELECT * FROM
OPENDATASOURCE('SQLOLEDB','Data Source=***.***.***.**;User
ID=***;Password=***).ferwoodsrl.dbo.MAGAnagraficaA rticoli where
UltimaModifica >= '1/2/2010 10:00:54' and NCPWeb <> 0

in our server (insert into) there is sql server 2005 , in local server there
is sql server 2000.





Andrea Rivetti -------------------------- Zeta Bi srl Marketing & ADV
Aderente a Confindustria Direzione e Uffici: Via dell'Acquedotto, 2/b -
12051 - Alba (Cn) -Italy Tel.: +39 0173.440953 - Fax: +39 0173.280381
Website: www.zbservizi.net - rivetti (AT) zbservizi (DOT) net Reg.impr di Cuneo
02800170041 - P.I.: 02800170041 Cap.Soc. 20.000? i.v. - REA 237570