Company         Products         Services         Partners         Media      
 
 Empress Extreme

Home

 

Empress Technical Support


Tech Support

Training Courses

Course Description

Consulting

Email: Support

Downloads

Empress Extreme

 

Extreme 4

How to Create Empress ODBC Local Access Runtime Configuration on Microsoft Windows Platforms

 

1. Introduction

    The purpose of this technical note is to give an overview on how to create Empress ODBC Local Access Runtime configuration on Microsoft WinXP/2K/NT Platforms. It is useful for those ODBC application developers who would like to provide their application on the target runtime system with its own installation procedure, therefore avoiding regular Empress ODBC Driver/Empress RDBMS installation.


2. The procedure to create Empress ODBC
      Local Access Runtime Configuration


    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.



3. Conclusion

    The above steps are needed to create a minimum set of components for the Empress ODBC Local Access Runtime configuration. If more components are to be added (e.g. additional tools/utilities) into Empress ODBC Local Access runtime configuration, please contact Empress technical support at support@empress.com for further help.



Contact Us   Contact Distributors   Company  Products   Services   Partners    Media    Product Profile   Free Trial    Home

    USA: 301-220-1919          Canada & International:    905-513-8888             

          Copyright © 2010               Empress Software Inc.              info@empress.com