scottw
Well Known Member
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
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