add linked server

Hi ,
I have tried to add a linked server(sql2000) residing
at location B from Location A (a server computer ,using
SQL 7.0) but i got the error "general network error , pls
check network documentation" I have gotten the correct
login id & pwd from the user at the other end.
have also configured the port#(under Client Utility)
correctly for client connection and also triedthe
sp_addlinkedservers & sp_addsvrlogin already
Is there any dll file needed ? such as DBNET.dll ? to
add linked server from sql ver 7.0 to sql2000 ?
Does it need any specific version of the odbc driver
for SQL Server ? current it's version is 3.70.10.63 i have
tried to add and odbc link but still have the same error
I have no problem when using Query Analyzer from my
client computer AND the user from the other end is able to
add my sqlserver successfully as a linked server. The odbc
driver for SQL Server is 3.85.xx.xx
Appreciate if somebody could help me out as i am doing
some data migration which i have set up some DTS jobs to
copy data daily over instead of one big chunks the day
before migration
many thksmaxzim
Can you show us your creation script?
This example works without creating a linked server
declare @.pid varchar(30)
set @.pid='2450'
select id from openrowset('sqloledb',
'server';'sa';'pass',database.dbo.table)
where id > @.pid
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:680a01c493d3$071362b0$a501280a@.phx.gbl...
> Hi ,
> I have tried to add a linked server(sql2000) residing
> at location B from Location A (a server computer ,using
> SQL 7.0) but i got the error "general network error , pls
> check network documentation" I have gotten the correct
> login id & pwd from the user at the other end.
> have also configured the port#(under Client Utility)
> correctly for client connection and also triedthe
> sp_addlinkedservers & sp_addsvrlogin already
> Is there any dll file needed ? such as DBNET.dll ? to
> add linked server from sql ver 7.0 to sql2000 ?
> Does it need any specific version of the odbc driver
> for SQL Server ? current it's version is 3.70.10.63 i have
> tried to add and odbc link but still have the same error
> I have no problem when using Query Analyzer from my
> client computer AND the user from the other end is able to
> add my sqlserver successfully as a linked server. The odbc
> driver for SQL Server is 3.85.xx.xx
> Appreciate if somebody could help me out as i am doing
> some data migration which i have set up some DTS jobs to
> copy data daily over instead of one big chunks the day
> before migration
> many thks
>|||Hi Uri ,
thks will try out urs
but for my creation script
i have used the Enterprise Manager and just specify the
remote user & pwd
for the query analyzer on the sql server i used :
sp_addlinkedserver 'serverA' -- it's using sql server so
i did not specify the rest of the connection
sp_addsvrlogin 'serverA' ,
false , 'sa', 'userid' , 'userpassword'
for the query analyzer from my local client computer ,
i simply enter the server name , enter the pwd & id and i
get connected
>--Original Message--
>maxzim
>Can you show us your creation script?
>This example works without creating a linked server
>declare @.pid varchar(30)
>set @.pid='2450'
>
>select id from openrowset('sqloledb',
>'server';'sa';'pass',database.dbo.table)
>where id > @.pid
>
>
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:680a01c493d3$071362b0$a501280a@.phx.gbl...
>> Hi ,
>> I have tried to add a linked server(sql2000) residing
>> at location B from Location A (a server computer ,using
>> SQL 7.0) but i got the error "general network error ,
pls
>> check network documentation" I have gotten the correct
>> login id & pwd from the user at the other end.
>> have also configured the port#(under Client Utility)
>> correctly for client connection and also triedthe
>> sp_addlinkedservers & sp_addsvrlogin already
>> Is there any dll file needed ? such as DBNET.dll ? to
>> add linked server from sql ver 7.0 to sql2000 ?
>> Does it need any specific version of the odbc driver
>> for SQL Server ? current it's version is 3.70.10.63 i
have
>> tried to add and odbc link but still have the same error
>> I have no problem when using Query Analyzer from my
>> client computer AND the user from the other end is able
to
>> add my sqlserver successfully as a linked server. The
odbc
>> driver for SQL Server is 3.85.xx.xx
>> Appreciate if somebody could help me out as i am doing
>> some data migration which i have set up some DTS jobs to
>> copy data daily over instead of one big chunks the day
>> before migration
>> many thks
>>
>
>.
>|||Hi
Do you have specified Server Type in the first tab when you use EM?
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:695e01c493d8$fbf0ae50$a301280a@.phx.gbl...
> Hi Uri ,
> thks will try out urs
> but for my creation script
> i have used the Enterprise Manager and just specify the
> remote user & pwd
> for the query analyzer on the sql server i used :
> sp_addlinkedserver 'serverA' -- it's using sql server so
> i did not specify the rest of the connection
> sp_addsvrlogin 'serverA' ,
> false , 'sa', 'userid' , 'userpassword'
> for the query analyzer from my local client computer ,
> i simply enter the server name , enter the pwd & id and i
> get connected
> >--Original Message--
> >maxzim
> >Can you show us your creation script?
> >This example works without creating a linked server
> >declare @.pid varchar(30)
> >set @.pid='2450'
> >
> >
> >select id from openrowset('sqloledb',
> >'server';'sa';'pass',database.dbo.table)
> >where id > @.pid
> >
> >
> >
> >
> >
> >
> >
> >"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:680a01c493d3$071362b0$a501280a@.phx.gbl...
> >> Hi ,
> >>
> >> I have tried to add a linked server(sql2000) residing
> >> at location B from Location A (a server computer ,using
> >> SQL 7.0) but i got the error "general network error ,
> pls
> >> check network documentation" I have gotten the correct
> >> login id & pwd from the user at the other end.
> >>
> >> have also configured the port#(under Client Utility)
> >> correctly for client connection and also triedthe
> >> sp_addlinkedservers & sp_addsvrlogin already
> >>
> >> Is there any dll file needed ? such as DBNET.dll ? to
> >> add linked server from sql ver 7.0 to sql2000 ?
> >>
> >> Does it need any specific version of the odbc driver
> >> for SQL Server ? current it's version is 3.70.10.63 i
> have
> >> tried to add and odbc link but still have the same error
> >>
> >> I have no problem when using Query Analyzer from my
> >> client computer AND the user from the other end is able
> to
> >> add my sqlserver successfully as a linked server. The
> odbc
> >> driver for SQL Server is 3.85.xx.xx
> >>
> >> Appreciate if somebody could help me out as i am doing
> >> some data migration which i have set up some DTS jobs to
> >> copy data daily over instead of one big chunks the day
> >> before migration
> >>
> >> many thks
> >>
> >>
> >
> >
> >.
> >|||Hi Uri ,
i used SQL Server in the 1st tab
>--Original Message--
>Hi
>Do you have specified Server Type in the first tab when
you use EM?
>
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:695e01c493d8$fbf0ae50$a301280a@.phx.gbl...
>> Hi Uri ,
>> thks will try out urs
>> but for my creation script
>> i have used the Enterprise Manager and just specify
the
>> remote user & pwd
>> for the query analyzer on the sql server i used :
>> sp_addlinkedserver 'serverA' -- it's using sql server
so
>> i did not specify the rest of the connection
>> sp_addsvrlogin 'serverA' ,
>> false , 'sa', 'userid' , 'userpassword'
>> for the query analyzer from my local client
computer ,
>> i simply enter the server name , enter the pwd & id and
i
>> get connected
>> >--Original Message--
>> >maxzim
>> >Can you show us your creation script?
>> >This example works without creating a linked server
>> >declare @.pid varchar(30)
>> >set @.pid='2450'
>> >
>> >
>> >select id from openrowset('sqloledb',
>> >'server';'sa';'pass',database.dbo.table)
>> >where id > @.pid
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >"maxzsim" <anonymous@.discussions.microsoft.com> wrote
in
>> message
>> >news:680a01c493d3$071362b0$a501280a@.phx.gbl...
>> >> Hi ,
>> >>
>> >> I have tried to add a linked server(sql2000)
residing
>> >> at location B from Location A (a server
computer ,using
>> >> SQL 7.0) but i got the error "general network error ,
>> pls
>> >> check network documentation" I have gotten the
correct
>> >> login id & pwd from the user at the other end.
>> >>
>> >> have also configured the port#(under Client
Utility)
>> >> correctly for client connection and also triedthe
>> >> sp_addlinkedservers & sp_addsvrlogin already
>> >>
>> >> Is there any dll file needed ? such as
DBNET.dll ? to
>> >> add linked server from sql ver 7.0 to sql2000 ?
>> >>
>> >> Does it need any specific version of the odbc
driver
>> >> for SQL Server ? current it's version is 3.70.10.63 i
>> have
>> >> tried to add and odbc link but still have the same
error
>> >>
>> >> I have no problem when using Query Analyzer from my
>> >> client computer AND the user from the other end is
able
>> to
>> >> add my sqlserver successfully as a linked server. The
>> odbc
>> >> driver for SQL Server is 3.85.xx.xx
>> >>
>> >> Appreciate if somebody could help me out as i am
doing
>> >> some data migration which i have set up some DTS
jobs to
>> >> copy data daily over instead of one big chunks the
day
>> >> before migration
>> >>
>> >> many thks
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>.
>|||Hi Uri ,
i have used the openrowset but it says "server does not
exist or access denied" which i am using the
administrator's id & pwd
rdgs
>--Original Message--
>Hi
>Do you have specified Server Type in the first tab when
you use EM?
>
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:695e01c493d8$fbf0ae50$a301280a@.phx.gbl...
>> Hi Uri ,
>> thks will try out urs
>> but for my creation script
>> i have used the Enterprise Manager and just specify
the
>> remote user & pwd
>> for the query analyzer on the sql server i used :
>> sp_addlinkedserver 'serverA' -- it's using sql server
so
>> i did not specify the rest of the connection
>> sp_addsvrlogin 'serverA' ,
>> false , 'sa', 'userid' , 'userpassword'
>> for the query analyzer from my local client
computer ,
>> i simply enter the server name , enter the pwd & id and
i
>> get connected
>> >--Original Message--
>> >maxzim
>> >Can you show us your creation script?
>> >This example works without creating a linked server
>> >declare @.pid varchar(30)
>> >set @.pid='2450'
>> >
>> >
>> >select id from openrowset('sqloledb',
>> >'server';'sa';'pass',database.dbo.table)
>> >where id > @.pid
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >"maxzsim" <anonymous@.discussions.microsoft.com> wrote
in
>> message
>> >news:680a01c493d3$071362b0$a501280a@.phx.gbl...
>> >> Hi ,
>> >>
>> >> I have tried to add a linked server(sql2000)
residing
>> >> at location B from Location A (a server
computer ,using
>> >> SQL 7.0) but i got the error "general network error ,
>> pls
>> >> check network documentation" I have gotten the
correct
>> >> login id & pwd from the user at the other end.
>> >>
>> >> have also configured the port#(under Client
Utility)
>> >> correctly for client connection and also triedthe
>> >> sp_addlinkedservers & sp_addsvrlogin already
>> >>
>> >> Is there any dll file needed ? such as
DBNET.dll ? to
>> >> add linked server from sql ver 7.0 to sql2000 ?
>> >>
>> >> Does it need any specific version of the odbc
driver
>> >> for SQL Server ? current it's version is 3.70.10.63 i
>> have
>> >> tried to add and odbc link but still have the same
error
>> >>
>> >> I have no problem when using Query Analyzer from my
>> >> client computer AND the user from the other end is
able
>> to
>> >> add my sqlserver successfully as a linked server. The
>> odbc
>> >> driver for SQL Server is 3.85.xx.xx
>> >>
>> >> Appreciate if somebody could help me out as i am
doing
>> >> some data migration which i have set up some DTS
jobs to
>> >> copy data daily over instead of one big chunks the
day
>> >> before migration
>> >>
>> >> many thks
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>.
>|||Hi
Probably this is a permission issue. Make sure that you have full
permissions on destination server.
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:673f01c493dc$63f279e0$a601280a@.phx.gbl...
> Hi Uri ,
> i have used the openrowset but it says "server does not
> exist or access denied" which i am using the
> administrator's id & pwd
> rdgs
> >--Original Message--
> >Hi
> >Do you have specified Server Type in the first tab when
> you use EM?
> >
> >
> >
> >
> >"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:695e01c493d8$fbf0ae50$a301280a@.phx.gbl...
> >> Hi Uri ,
> >> thks will try out urs
> >> but for my creation script
> >>
> >> i have used the Enterprise Manager and just specify
> the
> >> remote user & pwd
> >>
> >> for the query analyzer on the sql server i used :
> >>
> >> sp_addlinkedserver 'serverA' -- it's using sql server
> so
> >> i did not specify the rest of the connection
> >>
> >> sp_addsvrlogin 'serverA' ,
> >> false , 'sa', 'userid' , 'userpassword'
> >>
> >> for the query analyzer from my local client
> computer ,
> >> i simply enter the server name , enter the pwd & id and
> i
> >> get connected
> >> >--Original Message--
> >> >maxzim
> >> >Can you show us your creation script?
> >> >This example works without creating a linked server
> >> >declare @.pid varchar(30)
> >> >set @.pid='2450'
> >> >
> >> >
> >> >select id from openrowset('sqloledb',
> >> >'server';'sa';'pass',database.dbo.table)
> >> >where id > @.pid
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >"maxzsim" <anonymous@.discussions.microsoft.com> wrote
> in
> >> message
> >> >news:680a01c493d3$071362b0$a501280a@.phx.gbl...
> >> >> Hi ,
> >> >>
> >> >> I have tried to add a linked server(sql2000)
> residing
> >> >> at location B from Location A (a server
> computer ,using
> >> >> SQL 7.0) but i got the error "general network error ,
> >> pls
> >> >> check network documentation" I have gotten the
> correct
> >> >> login id & pwd from the user at the other end.
> >> >>
> >> >> have also configured the port#(under Client
> Utility)
> >> >> correctly for client connection and also triedthe
> >> >> sp_addlinkedservers & sp_addsvrlogin already
> >> >>
> >> >> Is there any dll file needed ? such as
> DBNET.dll ? to
> >> >> add linked server from sql ver 7.0 to sql2000 ?
> >> >>
> >> >> Does it need any specific version of the odbc
> driver
> >> >> for SQL Server ? current it's version is 3.70.10.63 i
> >> have
> >> >> tried to add and odbc link but still have the same
> error
> >> >>
> >> >> I have no problem when using Query Analyzer from my
> >> >> client computer AND the user from the other end is
> able
> >> to
> >> >> add my sqlserver successfully as a linked server. The
> >> odbc
> >> >> driver for SQL Server is 3.85.xx.xx
> >> >>
> >> >> Appreciate if somebody could help me out as i am
> doing
> >> >> some data migration which i have set up some DTS
> jobs to
> >> >> copy data daily over instead of one big chunks the
> day
> >> >> before migration
> >> >>
> >> >> many thks
> >> >>
> >> >>
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||Hi Uri ,
i'll have to check wif the administrator at the other
end then
thks for all the help given =)
>--Original Message--
>Hi
>Probably this is a permission issue. Make sure that you
have full
>permissions on destination server.
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:673f01c493dc$63f279e0$a601280a@.phx.gbl...
>> Hi Uri ,
>> i have used the openrowset but it says "server does not
>> exist or access denied" which i am using the
>> administrator's id & pwd
>> rdgs
>> >--Original Message--
>> >Hi
>> >Do you have specified Server Type in the first tab when
>> you use EM?
>> >
>> >
>> >
>> >
>> >"maxzsim" <anonymous@.discussions.microsoft.com> wrote
in
>> message
>> >news:695e01c493d8$fbf0ae50$a301280a@.phx.gbl...
>> >> Hi Uri ,
>> >> thks will try out urs
>> >> but for my creation script
>> >>
>> >> i have used the Enterprise Manager and just
specify
>> the
>> >> remote user & pwd
>> >>
>> >> for the query analyzer on the sql server i used :
>> >>
>> >> sp_addlinkedserver 'serverA' -- it's using sql
server
>> so
>> >> i did not specify the rest of the connection
>> >>
>> >> sp_addsvrlogin 'serverA' ,
>> >> false , 'sa', 'userid' , 'userpassword'
>> >>
>> >> for the query analyzer from my local client
>> computer ,
>> >> i simply enter the server name , enter the pwd & id
and
>> i
>> >> get connected
>> >> >--Original Message--
>> >> >maxzim
>> >> >Can you show us your creation script?
>> >> >This example works without creating a linked server
>> >> >declare @.pid varchar(30)
>> >> >set @.pid='2450'
>> >> >
>> >> >
>> >> >select id from openrowset('sqloledb',
>> >> >'server';'sa';'pass',database.dbo.table)
>> >> >where id > @.pid
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >"maxzsim" <anonymous@.discussions.microsoft.com>
wrote
>> in
>> >> message
>> >> >news:680a01c493d3$071362b0$a501280a@.phx.gbl...
>> >> >> Hi ,
>> >> >>
>> >> >> I have tried to add a linked server(sql2000)
>> residing
>> >> >> at location B from Location A (a server
>> computer ,using
>> >> >> SQL 7.0) but i got the error "general network
error ,
>> >> pls
>> >> >> check network documentation" I have gotten the
>> correct
>> >> >> login id & pwd from the user at the other end.
>> >> >>
>> >> >> have also configured the port#(under Client
>> Utility)
>> >> >> correctly for client connection and also triedthe
>> >> >> sp_addlinkedservers & sp_addsvrlogin already
>> >> >>
>> >> >> Is there any dll file needed ? such as
>> DBNET.dll ? to
>> >> >> add linked server from sql ver 7.0 to sql2000 ?
>> >> >>
>> >> >> Does it need any specific version of the odbc
>> driver
>> >> >> for SQL Server ? current it's version is
3.70.10.63 i
>> >> have
>> >> >> tried to add and odbc link but still have the same
>> error
>> >> >>
>> >> >> I have no problem when using Query Analyzer
from my
>> >> >> client computer AND the user from the other end is
>> able
>> >> to
>> >> >> add my sqlserver successfully as a linked server.
The
>> >> odbc
>> >> >> driver for SQL Server is 3.85.xx.xx
>> >> >>
>> >> >> Appreciate if somebody could help me out as i am
>> doing
>> >> >> some data migration which i have set up some DTS
>> jobs to
>> >> >> copy data daily over instead of one big chunks the
>> day
>> >> >> before migration
>> >> >>
>> >> >> many thks
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>.
>