Step 1: The following files need to be
installed in the runtime environment:
C:\Empress\bin
C:\Empress\bin\basic.dll
C:\Empress\bin\api_r.dll
C:\Empress\bin\basic.dll
C:\Empress\bin\ms.dll
C:\Empress\bin\mscfg.dll
C:\Empress\bin\nlsmsgtab.dll
C:\Empress\bin\odbcbcs.dll
C:\Empress\common
C:\Empress\common\nls
C:\Empress\common\nls\nlsfile_english
C:\Empress\config
C:\Empress\config\initfile
C:\Empress\config\nettype.cfg
C:\Empress\config\netserver.cfg
C:\Empress\rdbms
C:\Empress\rdbms\spool\proc
C:\Empress\rdbms\spool\shm
C:\Winnt\system32\empOdbcBcs.dll
C:\Empress is the directory where Empress Runtime will be created.
Step 2: Create the Following Settings for Empress RDBMS Runtime
The following settings need to be created in the Windows registry:
[HKEY_LOCAL_MACHINE\SOFTWARE\Empress Software Inc.]
[HKEY_LOCAL_MACHINE\SOFTWARE\Empress Software Inc.\Empress]
[HKEY_LOCAL_MACHINE\SOFTWARE\Empress Software Inc.\Empress\v8.62-B(Latin1)]
@=""
EMPRESSPATH"="C:\\Empress"
[HKEY_LOCAL_MACHINE\SOFTWARE\Empress Software Inc.\Empress 8.62(Latin1)]
[HKEY_LOCAL_MACHINE\SOFTWARE\Empress Software Inc.\Empress 8.62(Latin1)\8.62-B]
C:\Empress is the directory where Empress Runtime will be
created.
Step 3: Create the following settings for Empress ODBC Local Access runtime
The following settings need to be created in the Windows registry:
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Empress ODBC Local Access Interface [Default]]
"Setup"="C:\\WINNT\\System32\\EmpOdbcBcsDrv.dll"
"Driver"="C:\\WINNT\\System32\\EmpOdbcBcsDrv.dll"
"ConnectFunctions"="YYY"
"DriverODBCVer"="03.51"
"APILevel"="1"
"SQLLevel"="1"
"FileUsage"="0"
"UsageCount"=dword:00000001
"CPTimeout"="<not pooled>"
Step 4: Register Empress ODBC Local Access Runtime
Create one string value in the Windows registry:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers
String :
Empress ODBC Local Access Interface [Default]
Value :
Installed
Step 5: Create the following setting for
Empress ODBC Local Access Data Source Name (DSN)
The following settings need to be created in the Windows registry for
the Empress ODBC Local Access DSN:
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Your_dsn_name]
"Driver"="C:\\Empress\\v8.62-B.Latin1\\bin\\odbcbcs.dll"
"Description"=""
"Server"=""
"Port"=""
"Database"="Your_Database_Location"
"CodeSet"="Latin1"
"TraceFile"=""
"TraceLevel"="0"
"TranslationDLL"=""
"TranslationName"=""
"TranslationOption"="0"
"DefaultHome"="."
"DefaultPwd"=""
"DefaultUID"=""
"ODBCLEVEL"="2"
"ODBCVERSION"="03.51"
"CACHE_SIZE"="263168"
"CACHE_BTSIZE"="263168"
"CACHE_FSIZE"="263168"
"PACKET_SIZE"="4096"
"Your_dsn_name" is the name of the DSN.
"Your_Database_Location" should be defined as logical database if
Empress Global Data Dictionary is used or a physical database path.
Step 6: Register Empress ODBC Local Access DSN
Create one string value in Windows registry:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources
String :
Your_dsn_name
Value :
Empress ODBC Local Access Interface [Default]
Step 7: Create a database
A database can be created using the following
command on the development machine
empmkdb -noshmem database_name
and copied into the runtime environment.
A database can also be created with Empress shared memory settings
and copied into the runtime environment. First time the database gets accessed
the required shared memory segment(s) will be created on the target system.
Step 8: Create Empress Global Data Dictionary (Optional)
If third party products, such as Microsoft Visual Basic, Excel, .NET are used to access Empress database, Empress Global Data Dictionary must be created.
Create Empress Global Data Dictionary file as follows,
|
MSDBLOGICALNAME=logical_database_name
MSDBLOCATION=physical database path
MSDBSERVERNAME=LOCAL MSDBLOGICALEND
|
The Windows environment variable MSGLOBALDATADICTIONARY must be set to
point to the above file.