Joining tables across multiple DSN's / Servers 1

[1DMF]

Is it possible to Join tables across multiple servers that reside on different DSN's?

I don't have a problem switching DSN's and getting the data separately, but i was hoping I could join them somehow

cheers,

1DMF

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[gmmastros]

It is possible. Do a little research on [google]SQL Server Linked Server[/google].


-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[1DMF]

great thanks George.

In the intertim I created a 'lookup' class, that converted a recordset to a key/value pair hash.

so getting the required data was a simple SQL select which was stored in a collection that can easily be accessed for the required lookup.

But it would be great if I can link them.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[1DMF]

Can't work it out I just keep getting

Access to remote server is denined because no login-mapping exists

I'm not sure what I'm trying to map, the two SQL servers have different logins so what am I mapping?

I tried to delete the linked server but now get

could not locate entry in sysdatabases for database 'distribution'. No entry found with that name

bah humbug!

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[1DMF]

I've tried

sp_dropserver 'servername', 'droplogins';

but get the same error?

How do i remove the linked server instance from SQL enterprise manager? it doesn't work, i can't edit the settings and I can't delete it!


"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[gmmastros]

What do you get when you run this?

sp_linkedservers

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[1DMF]

I get a list of the linked servers

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts