u.u the second options doeskin seems trusty , my anti-virus prevent it to start when i tried to install it, and the first option just provides the installer i already...

omg now you made me think on the driver, the one i used is this:

i've created the connection with odbc data source admin , i used 32...

so my boss and i gave up trying to pull the tables this was because at the end we succeed in doing it, (thanks a lot to you all guys)...

i tried like you wrote Sue and i receive the following after pressing f5:

Msg 7312, Level 16, State 1, Line 4

Invalid use of schema or catalog for OLE DB provider...

Thanks Chris!

another question XD

well the query is saying that incorrect syntax near "hagent". Expecting '.', ID, or QUOTED_ID.

im writing frederico's query like this:

USE [Pit]

GO

select * from cms196.root.'hagent' and hagent is...

hey SSChampion , thanks for replying , another question when i write that query in sql server what buttons should i press instead of ctrl+enter (that's what i press in...

I tried and nothing , stills the same error message T.T , do you think this might be cause due to a bad set up from my odbc data source...

hi

yes, it is supported indeed :

https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-ver15

hi Sue, thanks for replying, yeah its a rough explanation, to make it simple  my problem is :

I've created a linked server, as i commented in the previous post the...