Post reply

Accessing multiple DBs through one DSN

  • February 27, 2006 at 4:54 am

    #90614

    Hello,

    I would be very grateful if anyone can help me with this.  I have a series of databases which at the moment exist in Access, all on the same server.  There is one Access DB which is used as the central db, and all the other dbs are just linked tables in the main db.

    I want to move this set up across to SQL Server and get rid of the access setup.  So my plan was to move all the dbs onto the same sql server, and then create a master db also on that server.  But I would like to have a similar setup to the access one in the sense that I would like the users to connect to the one master sql server db, and be able to view all other dbs from there.  Is it possible to create views onto other databases within sqlserver?  I would like them to be able to connect to DB1 via a DSN on their desktop, and automatically be able to see DB2 and DB3 and DB4 etc. 

    Is this making sense?

    Please can someone suggest the best way of doing this?

    Many thanks,

    Paula.

  • February 27, 2006 at 6:35 am

    #623428

    Views or use full reference of database.schema.object when referencing the other databases. You only have to make sure the login has permissions in all databases to interact with the objects in question.

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

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