Difference: APPX61ODBCInstallationInstructions (59 vs. 60)

Revision 602021-06-09 - BrianRyan

Line: 1 to 1
 
META TOPICPARENT name="APPX500InstallationInstructions"

APPX ODBC Installations Instructions

_This page provides instructions for installing APPX ODBC 6.1

Changed:
<
<

>
>

 

Overview

APPX ODBC is used by APPX customers to gain access to APPX data from external products, such as Crystal Reports or Excel. Installation of APPX ODBC 6.1 is accomplished by simply following the steps outlined below. APPX ODBC 6.1 is a Windows only product for now.

Line: 180 to 180
 

Troubleshooting

Troubleshooting AppxODBC Server
Troubleshooting AppxODBC Driver/ASQL
Changed:
<
<
Missing $APPXPATH\0SA\Struct\SYSDIR.dat
>
>
Appx ODBC Gateway Service stopped or blocked by firewall.
 
Changed:
<
<
If you receive an error like below when you connect to a local instance of APPX via ASQL, you may be missing the 0SA\Struct\SYSDIR.dat file. You can create this file by selecting System Administration > System Setup > System Administration File Management > Create Files. Then restart ASQL and attempt to connect to APPX again.
>
>
ODBC_ASQL_Cant_Connect.JPG
 
Changed:
<
<
037.jpg038.jpg
>
>
ASQL.exe failure to connect to the APPX ODBC gateway server (aka appxODBC Server) on TCP port 1992.
 
Changed:
<
<
The images above can occur when 0SA\Struct\SYSDIR.dat file is missing. This error will occur at the beginning of the connection attempt from ASQL to APPX.

This error can also occur if you specify a Database on the ASQL login screen. This is a bug, until it is fixed, just leave the database blank. You can specify an Application.

Appx ODBC Gateway Service stopped or blocked by firewall.

039.jpg

ASQL.exe failure to connect to the APPX ODBC gateway server (aka appxODBC Server) on TCP port 1990.

040.jpg

WinSQL failure to connect to the APPX ODBC gateway server (aka appxODBC Server) on TCP port 1990.

If you receive the either of the two above errors, verify that the appxODBC Server's service named "Appx ODBC Data Gateway Service 05.02.0000" is started. Also make sure the TCP port 1990 is not blocked between the Appx ODBC client and Appx ODBC server.

Installing on Windows 64 bit

AppxODBC is a 32 bit product. The Windows ODBC System DSN it creates is 32 bit not 64 bit. To view and manage 32 bit DSNs on a 64 bit version of Windows, you must specify the 32 bit version of odbcad32.exe. For 64 bit Windows, to manage 32 bit DSNs like AppxODBC, use \Windows\SysWOW64\odbcad32.exe and not the 64 bit version with the same name found at \Windows\system32\odbcad32.exe.

If you are working on a 32 bit version, this does not apply to you, just run the odbcad32.exe found in your Administrative tools (which is mapped to \Windows\system32\odbcad32.exe.)

Manuals

>
>
If you receive the above error, verify that the appxODBC Server's service named "Appx ODBC Data Gateway Service" is started. Also make sure the TCP port 1992 is not blocked between the Appx ODBC client and Appx ODBC server.
Manuals
  The Dharma Interface Manual explains how our ODBC interface works and details supported SQL statements and syntax.
Changed:
<
<

Linux and Unix

>
>

Windows, Linux and Unix

 

Known Issues

  • APPX Server version and AppxODBC version should match. Mismatched version can cause failure to connect, or extreme loss of performance in AppxODBC data connection.
Deleted:
<
<
  • Entering a Database on the connection screen will cause connection problems. Leave the database blank.
 
Deleted:
<
<
 

Comments:

Read what other users have said about this page or add your own comments.

Line: 219 to 198
  Read what other users have said about this page or add your own comments.
Changed:
<
<

<--/commentPlugin-->
>
>

<--/commentPlugin-->
  -- BrianRyan - 2021-06-07
Line: 299 to 278
 
META FILEATTACHMENT attachment="ODBC_Driver_Dharma_Setup_localhost.JPG" attr="h" comment="" date="1623248209" name="ODBC_Driver_Dharma_Setup_localhost.JPG" path="ODBC_Driver_Dharma_Setup_localhost.JPG" size="40730" user="BrianRyan" version="1"
META FILEATTACHMENT attachment="ODBC_Driver_Sources_Administrator_2.JPG" attr="h" comment="" date="1623248375" name="ODBC_Driver_Sources_Administrator_2.JPG" path="ODBC_Driver_Sources_Administrator_2.JPG" size="44991" user="BrianRyan" version="1"
META FILEATTACHMENT attachment="Appx_ODBC_Hierarchy.jpg" attr="h" comment="" date="1623251237" name="Appx_ODBC_Hierarchy.jpg" path="Appx_ODBC_Hierarchy.jpg" size="40683" user="BrianRyan" version="1"
Added:
>
>
META FILEATTACHMENT attachment="ODBC_ASQL_Cant_Connect.JPG" attr="h" comment="" date="1623256004" name="ODBC_ASQL_Cant_Connect.JPG" path="ODBC_ASQL_Cant_Connect.JPG" size="14508" user="BrianRyan" version="1"
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2022 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback