ONYXPLUS non-card solution error: Cannot connect to database

Moderator: Luanda_Junzi

ONYXPLUS non-card solution error: Cannot connect to database

Postby Belinda Frick » Mon Dec 13, 2010 11:43 am

Required:
OnyxPlus 1.0.0.1 or newer
Onyx 1.2.0.3 or newer
ONYXPlus uses PORT 27005.

Download:
OnyxPlus: Provided by Datatex on purchase of ONYXPlus.
[www.datatex.co.za -> SUPPORT -> LOGON -> onyx],
Onyx 1.2.0.3 or newer. This is an upgrade.

Please check the following:

    Access:

    • ONYXPlus:

      The windows user on the ONYXPlus PC must have full control over the ONYX folder on that PC.

      The folder with the ONYXPLUS database folder must be shared.

      Default file path: "C:\Program Files\Datatex\Onyx\ONYX.FDB".

      Right-click on the ONYX folder, choose sharing and security:
      share my folder on the network.
      allow network users to change my files.

    • ONYX:

      In Windows XP and 2000:
      The Windows user on the ONYX PC must have full
      control of the ONYX folder on the ONYXPLUS PC.
      This needs to be setup on the ONYXPLUS PC.

      XP:
      ALSO SEE: How to configure the Windows XP SP2 firewall to work with Datatex products
    Ports:

      ONYX uses port 27004 and Firebird on port 3050 tcp.
      Ensure that these ports is available for ONYXPlus.

      START -> RUN -> CMD, netstat -na
      Code: Select all
      Proto  Local Address          Foreign Address        State
      TCP    0.0.0.0:3050           0.0.0.0:0              LISTENING
      UDP    0.0.0.0:27002          *:*
      UDP    0.0.0.0:27004          *:*
      UDP    0.0.0.0:27005          *:*

      START -> RUN -> CMD, netstat -nba
      Code: Select all
        Proto  Local Address          Foreign Address        State           PID
        TCP    0.0.0.0:3050           0.0.0.0:0              LISTENING       3000
        [fbserver.exe]

      In this example 'fbserver.exe' is the Firebird Service required for ONYXPlus.

      Code: Select all
        UDP    0.0.0.0:27004          *:*                                    200
        [Onyx_Sweeper.exe]

    Firebird: Client

      The "fbclient.dll" must be present in the folder
      "C:\Program Files\Datatex\Onyx" on the ONYX PC.

    File paths:

      Example of the ONYX_Sweeper.ini:

      Code: Select all
      [PATHS]
      DATAPATH=\\cardserver\Onyx\data\
      WORKPATH=\\cardserver\Onyx\temp\
      INCOMPLETEPATH=C:\Program Files\Datatex\Onyx\incomplete\
      DATABASE=cardserver:C:\Program Files\Datatex\Onyx\ONYX.FDB
      [PORTS]
      LISTENPORT=27005


      Example of an ONYX.INI file

      Code: Select all
      [RECORD]
      WORKPATH=C:\Program Files\Datatex\Onyx\work\
      DATAPATH=C:\Program Files\Datatex\Onyx\Data\


      Please note the use of the network paths and notation.

      If they do not match the ONYX is not able to update the PLUS* paths.
      Tick 'Enable ONYX + connection' in ONYX for each ONYX.
      This could be an access problem on the network or incorrect IP/PC Name
      entered. Once this is sorted out the PLUS* paths will be updated
      automatically.
      Also check in the task manager that there is no OnyxPlus running in the background.

      Once you have changed settings, please restart the ONYXPlus server to startup with
      the new settings.

      If you still get the error, please use for example IBExpert to try and connect to
      the database from the ONYX PC. Place IBExpert in the same folder as ONYX.exe, set it up
      to point to the ONYXPlus database and run it from there. It will give you error descriptions.


      PLEASE NOTE: TRY USING THE SERVERNAME INSTEAD OF THE IP ADDRESS IN THE INI FILES.
Belinda Frick
 
Posts: 3808
Joined: Fri Nov 12, 2010 4:25 pm

Return to Support Archive's (ONYXPLUS)

Who is online

Users browsing this forum: No registered users and 1 guest