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

Chapter 25. Creating Access Data Projects > Connecting to Remote MSDE Databases

Connecting to Remote MSDE Databases

If MSDE is running under Windows NT or 2000 (Workstation or Server) and your client PC runs Windows NT or 2000 Workstation, connecting to the remote MSDE database is simple. The Named Pipes protocol advertises the NetBIOS name of all Windows NT or 2000 PCs in your current domain that have MSDE or SQL Server installed. Thus you can select the MSDE or SQL Server to which to connect from the Servers drop-down lists of ADP connection dialogs. (If the server name doesn't appear, type it in the list's text box.) For Windows 9x clients or servers, you must specify the MSDE or SQL Server connection.

Using the SQL Server Client Network Utility

MSDE running under Windows 9x and Windows 9x Access clients don't support the Named Pipes protocol, so you must establish server aliases with the SQL Server Client Network Utility. The following example sets up aliases to connect the OAKLEAF1 client, which runs Windows 98, to the following servers:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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