• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

14. SQL Server > 14.8. Reference Data from More than One SQL Server Database in...

14.8. Reference Data from More than One SQL Server Database in an ADP

Problem

You’d like to have your ADP connect to multiple SQL Server databases at one time. However, the Data Link dialog allows room for only one SQL Server database.

Solution

Although at first glance this seems to be a problem, the solution is readily at hand with SQL Server’s three-part naming convention. You are probably already familiar with the OwnerName.ObjectName syntax for referring to SQL Server objects, which is needed when users other than the owner (or creator) of that object wish to use the object. The three-part naming syntax is:

DatabaseName.OwnerName.ObjectName

To refer to another SQL Server database in your ADP, follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint