Linking of table from other database

Question

Linking of table from other database

Priyanka-314104

Valued Member

Points: 59
More actions
March 27, 2006 at 7:14 am

#93705

Hi,
I have a question related to linking of the tables in SQL server database from the other database.
I have tried to do so using Linked Server from MS ACCESS and it is successfully linked but I cannot see all of its rows as I do not have option to return all rows.
But when I am trying to use Linked Server for SQL server database only it works but give me this error:-
OLEDB PROVIDER 'SQLOLEDB' reported and error.
And I have one more questions Like in MS ACCESS we can link some of the tables from different databases like Access or other databases using ODBC, is that kind of thing is possible in SQL SERVER.
If yes then how?
Thanks is advance,

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Norene Malaney SSCommitted Points: 1896 More actions · Answer 1

And I have one more questions Like in MS ACCESS we can link some of the tables from different databases like Access or other databases using ODBC, is that kind of thing is possible in SQL SERVER.

If yes then how?

Not sure if this is what you are looking for but ...

You can set up "linked servers" in SQL server to setup links to other databases. To do this via SQL EM, under the server you want to setup the linked servers in, choose Security -> Linked Servers. Once all of the linked servers are setup, you can use the following convention to access tables in the linked server (replacing each of the four variables (SERVER_NAME, DATABASE_NAME, TABLE_OWNER, TABLE_NAME) with the appropriate values:

SERVER_NAME.DATABASE_NAME.TABLE_OWNER.TABLE_NAME

Have a good day,

Norene Malaney

Priyanka-314104 Valued Member Points: 59 More actions · Answer 2

Hi Norene,

Thanks for your reply.

What I am looking is linking of table from another database(Parent) to (child)database as if some changes occur in the parent database will be done in child database.

And I have tried to use Linked server it work perfectly fine for Access database as I explained in earlier post but it is not working for the SQL SERVER.

It would be king if you could have a look on my earlier post related to Linked Server.

Thanks,

Priyanka