Prev: Select on current date
Next: Returning status/error codes and messages from stored procedures
From: Andrea Rivetti - Zeta Bi Internet on 16 Mar 2010 07:36
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.MAGAnagraficaArticoli 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.




From: Uri Dimant on 16 Mar 2010 07:45
Andrea
Are you able to create a linked server between two and issue INSERT
statement

INSERT INTO .... SELECT ServerName.DataBase.dbo.Tbl
WHERE...........


"Andrea Rivetti - Zeta Bi Internet" <rivetti(a)zbservizi.net> wrote in message
news:%23Fei1zPxKHA.1692(a)TK2MSFTNGP04.phx.gbl...
>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.MAGAnagraficaArticoli 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.
>
>
>
>


From: Andrea Rivetti - Zeta Bi Internet on 16 Mar 2010 09:12
that's what I did. But when launching the query, it returns me that error.
Probably an incompatibility between my sql server 2005 and its SQL Server
2000 SP3. I believe that SQL Server 2000 SP4 solves the problem. No one has
ever found in this case?

"Uri Dimant" <urid(a)iscar.co.il> ha scritto nel messaggio
news:%23RTia4PxKHA.4492(a)TK2MSFTNGP05.phx.gbl...
> Andrea
> Are you able to create a linked server between two and issue INSERT
> statement
>
> INSERT INTO .... SELECT ServerName.DataBase.dbo.Tbl
> WHERE...........
>
>
> "Andrea Rivetti - Zeta Bi Internet" <rivetti(a)zbservizi.net> wrote in
> message news:%23Fei1zPxKHA.1692(a)TK2MSFTNGP04.phx.gbl...
>>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.MAGAnagraficaArticoli 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.
>>
>>
>>
>>
>
>

From: Uri Dimant on 16 Mar 2010 09:20
Andrea
I was confused about why are you using OPENDATASOURCE command?
Are both servers 64 bit?


"Andrea Rivetti - Zeta Bi Internet" <rivetti(a)zbservizi.net> wrote in message
news:OUfsspQxKHA.1796(a)TK2MSFTNGP02.phx.gbl...
> that's what I did. But when launching the query, it returns me that error.
> Probably an incompatibility between my sql server 2005 and its SQL Server
> 2000 SP3. I believe that SQL Server 2000 SP4 solves the problem. No one
> has ever found in this case?
>
> "Uri Dimant" <urid(a)iscar.co.il> ha scritto nel messaggio
> news:%23RTia4PxKHA.4492(a)TK2MSFTNGP05.phx.gbl...
>> Andrea
>> Are you able to create a linked server between two and issue INSERT
>> statement
>>
>> INSERT INTO .... SELECT ServerName.DataBase.dbo.Tbl
>> WHERE...........
>>
>>
>> "Andrea Rivetti - Zeta Bi Internet" <rivetti(a)zbservizi.net> wrote in
>> message news:%23Fei1zPxKHA.1692(a)TK2MSFTNGP04.phx.gbl...
>>>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.MAGAnagraficaArticoli 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.
>>>
>>>
>>>
>>>
>>
>>
>


From: Andrea Rivetti - Zeta Bi Internet on 16 Mar 2010 09:47
i'm using OPENDATASOURCE cause i have to take all the record modified in
local DB and put into online database.

What's you alternative solution?

"Uri Dimant" <urid(a)iscar.co.il> ha scritto nel messaggio
news:OOMoltQxKHA.1796(a)TK2MSFTNGP02.phx.gbl...
> Andrea
> I was confused about why are you using OPENDATASOURCE command?
> Are both servers 64 bit?
>
>
> "Andrea Rivetti - Zeta Bi Internet" <rivetti(a)zbservizi.net> wrote in
> message news:OUfsspQxKHA.1796(a)TK2MSFTNGP02.phx.gbl...
>> that's what I did. But when launching the query, it returns me that
>> error. Probably an incompatibility between my sql server 2005 and its SQL
>> Server 2000 SP3. I believe that SQL Server 2000 SP4 solves the problem.
>> No one has ever found in this case?
>>
>> "Uri Dimant" <urid(a)iscar.co.il> ha scritto nel messaggio
>> news:%23RTia4PxKHA.4492(a)TK2MSFTNGP05.phx.gbl...
>>> Andrea
>>> Are you able to create a linked server between two and issue INSERT
>>> statement
>>>
>>> INSERT INTO .... SELECT ServerName.DataBase.dbo.Tbl
>>> WHERE...........
>>>
>>>
>>> "Andrea Rivetti - Zeta Bi Internet" <rivetti(a)zbservizi.net> wrote in
>>> message news:%23Fei1zPxKHA.1692(a)TK2MSFTNGP04.phx.gbl...
>>>>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.MAGAnagraficaArticoli 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.
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>
>

 | 
Pages: 1
Prev: Select on current date
Next: Returning status/error codes and messages from stored procedures