Discover our Clipsal Smart Home packages as seen on The Block 2018

in location


I'm looking for

  • Wholesalers
    • Uncheck All Check All
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    ODBC connection for Crystal Reports in ClearSCADA

    ClearSCADA uses a native 64-bit Crystal Reports runtime and therefore requires a 64-bit ODBC system DSN configured.

    Crystal Reports itself is a 32-bit program and needs a 32-bit ODBC system DSN configured.

    For this reason, both a 32-bit system DSN and 64-bit system DSN need to be configured on the ClearSCADA server PC.  A user may use the following steps in order to configure both of these system DSN's:

    1) Using Windows File Explorer, navigate to C:\Windows\System32 and locate the odbcad32.exe file.

    2) Double-click to open the ODBC Data Source Administrator (64-bit).  Click on the 'System DSN' tab and then click the 'Add' button.  Select the 'ClearSCADA Driver'.

    3) In the name field enter: ClearSCADA  Ensure the system is set to the local database (i.e. MAIN) and ensure 'Allow Anonymous' is checked.
        (Optional: fill out the 'User Name' and 'Password' fields.)

    4) Click 'OK and 'OK' again to close these dialogs.

    5) Now navigate to C:\Windows\SysWOW64 and locate the odbcad32.exe file.

    6) Double-click to open the ODBC Data Source Administrator (32-bit)

    7) Repeate steps 3) and 4)

    8) No go into the ClearSCADA server configuration | Global Parameters | Crystal Reports dialog

    9) Ensure the DSN field reads: ClearSCADA

    It is important that the spelling of ClearSCADA is consistent in both system DSN's and in the server configuration.

    Restart the ClearSCADA server in order to activate the connection.

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance