<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta http-equiv="X-UA-Compatible" content="IE=edge" />
				<meta name="viewport" content="width=device-width, initial-scale=1" />
		<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
		<meta name="format-detection" content="telephone=no" />
		<meta name="robots" content="noindex" />
			<title>DAL: How to Access Database on Remote VAX</title><body class="ac-gn-current-support">
	<input type="hidden"  id="cdsHeaderObj" data-json='{"setPod": "true",
"resourceUrl": "https://support.apple.com",
"akamaiUrl": "https://km.support.apple.com",
"modelValue": "Support",
"aiSearchServiceURL": "support.apple.com",
"podLocaleValue": "en_US",
"omnitureLocale": "us_en",
"aiCrossDomainSearchServiceURL": "support-suggestions.apple.com",
"podValue": "us~en",
"searchCountry": "us",
"enableAppleInstant": "yes",
"pageName": "kb",
"amlSuggestionsUrl": "https://www.apple.com/search-services/suggestions/",
"title": "DAL: How to Access Database on Remote VAX",
"channelName": "LEGACY"
}'>
	<input type="hidden"  id="httpDownloadURL" value="http://support.apple.com">
<!-- 	
 -->

	
<aside id="ac-gn-segmentbar" class="ac-gn-segmentbar" lang="en-US" dir="ltr" data-strings="{ 'exit': 'Exit', 'view': '{%STOREFRONT%} Store Home', 'segments': { 'smb': 'Business Store Home', 'eduInd': 'Education Store Home', 'other': 'Store Home' } }">
</aside>

<h1 id="main-title">DAL: How to Access Database on Remote VAX</h1>
<div id="abstract">
 
<div id="intro-container"><div class="truncate"><div class="attr SYMPTOMS"><div class="attr TOPIC">We have some VAX systems running VAX/VMS.  What logical names are required for DAL on one VAX to access an ORACLE RDBMS on the other VAX? We were able to run SQLPlus, but we've customized it so the access required a few logical names.<BR></div></div> <!--  attr Symptom  --></div> <!--  truncate --></div> <!--  intro-container --><div class="clear"> </div>
 </div>   <!-- abstract end -->
<div id="articlecontent">
<div id="indicator-container">      
<div class="indicator archived"></div></div> <!-- Indicator-container -->
  <div class="attr SUMMARY">
If the VAX systems are part of a VAXcluster, you must connect to a node that is running the DAL Server and AppleTalk for VMS. If the DAL Server and AppleTalk for VMS has been licensed for each node on the VAXcluster, then you may access a shared database via DAL from any node running the DAL Server and AppleTalk for VMS.<BR>
<BR>
If the VAX systems aren't part of a VAXcluster, you still can access the remote database, if the database is set up for remote access. ORACLE, Ingres, and Sybase all have mechanisms to support remote database access.<BR>
<BR>
For example, if you have the DAL Server and AppleTalk for VMS installed on VAX A and the ORACLE database installed on VAX B, you can allow users on VAX A to access the database on VAX B in this way:<BR>
<BR>
1) Select either the Async Driver, the DECnet Driver, or the TCP Driver for SQL*Net during ORACLE installation.<BR>
<BR>
2) Create a database link for each database.  This database link contains enough information to uniquely identify a path to the remote database. It normally contains the following information:<BR>
<BR>
   - Network protocol<BR>
   - Nodename<BR>
   - Dbname<BR>
   - Username/password<BR>
   - Protocol options<BR>
<BR>
If the users on VAX A can access the database on VAX B, then the DAL Server has access, too. The database application handles the Async, DECnet or, TCP/IP communications between VAX A and VAX B, not DAL.<BR></div>
</div>


<!-- Start SiteCatalyst code version: H.8. -->


<!-- End SiteCatalyst code version: H.8. -->


<div class="mod-date">Published Date: Feb 18, 2012</div>
  <div id="mimosa-tags">
  
  <input type ="hidden" id="mimosa-tags-heading" value="Related Topics" />
  <input type ="hidden" id="showNavTagFlag" value="true" />
  <input type ="hidden" id="tags-localised" value="Tag" />
        </div>

</div><!--/#content-->
</div><!--/#main-->

<!-- Helpful not helpful section -->
 <div style="display:none">
<div id="meta">
                </div> <!--/#meta-->
</div>          
        <!-- Related Section -->
<div class="border-div"></div>      <!-- Offer Section -->
<div class="border-div"></div>
<div id="promo" style="display:none;"> Still need help?</div>          
         
<div style="clear:both;"></div>

</div>
<input type="hidden"  id="cdsArticleObj" data-json='{"docId": "TA48170",
"cdsLocale": "en_US",
"imgSrc": "",
"akamaiUrl": "https://km.support.apple.com",
"strTitle": "DAL: How to Access Database on Remote VAX",
"strLocale": "en_US",
"omniturePageName": "acs::kb::dl::ta48170::dal: how to access database on remote vax",
"metaUrl": "",
"baseLink": "https://km.support.apple.com/kb/",
"reportLink": "https://support.apple.com",
"lcl": "en_US",
"localeParam": "en_US",
"viewLocale": "null",
"domainName": "0",
"archive": "true",
"enableAffectedProductPortlet": "false",
"configHeaderFooterLocale": "en_US",
"strCategoryListRefKeys": "",
"lastModifiedDate": "2012-02-18",
"creationDate": "1992-03-05",
"publishedDate": "Sat, 18 Feb 2012 03:48:55 GMT",
"publishedDateHeader": "Sat, 18 Feb 2012 03:48:55 GMT",
"oldInquiraID": "",
"articleNo": "TA48170",
"strChannel": "LEGACY",
"isOmnitureSupported": "true",
"referringPage": "unknown",
"messageResourcesArticleTempEmail": "Email Download Link",
"messageResourcesArticleTempDown": "Download",
"ACStaticText": "{\"more\": \"…more\", \"less\": \"less\" }"
}'>

<div class="footer-wrapper">

</div>


</html>