JAS server install

[scottw]

There is a file JDEdwardsOneWorld\B7333\internet\jas\tnsnames.sql. This file
is for the JAS server and I want to know what is the function of this file?
One must change the file to reflect the correct server and the correct
library. Also the is this file used when the enterprise server is a AS400.

Example of the tsnames.sql file

Data Dictionary - B7333=(jdbc:ff-microsoft://SERVERNAME:1433/JDE7333)
SERVERNAME - B7333 Server Map=(jdbc:ff-microsoft://SERVERNAME:1433/JDE7333)
Object Librarian - B7333=(jdbc:ff-microsoft://SERVERNAME:1433/JDE7333)
System - B7333=(jdbc:ff-microsoft://SERVERNAME:1433/JDE7333)

Business Data - CRP=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_CRP)
Central Objects - PD7333=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_PD7333)
Control Tables - CRP=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_CRP)
Versions - PY7333=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_PY7333)

Business Data - JDE=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_PRISTINE)
Central Objects - JD7333=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_JD7333)
Control Tables - JDE=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_PRISTINE)
Versions - JD7333=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_JD7333)

Business Data - PROD=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_PRODUCTION)
Central Objects - PD7333=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_PD7333)
Control Tables - PROD=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_PRODUCTION)
Versions - PD7333=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_PD7333)

Business Data - TEST=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_DEVELOPMENT)
Central Objects - DV7333=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_DV7333)
Control Tables - Test=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_DEVELOPMENT)
Versions - DV7333=(jdbc:ff-microsoft://SERVERNAME:1433/JDE_DV7333)

Scott Whipple
LDSI
Technical/Application Consultant
303-740-5500 Office
303-885-1405 Cell
303-843-0227 Fax

 

[WalterD]

ODBC use. JAVA (JAS) reads the .txt file when the server loads and reads from database.

Walter De Melo
Mosaic Group Inc.