Difference: APPX61ODBCInstallationInstructions (58 vs. 59)

Revision 592021-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.

APPX ODBC 6.1 is a new product compared to earlier versions of APPX ODBC. There is no upgrade, just uninstall the older version prior to installing the new version.

Changed:
<
<
AppxODBC_5.0_chart_-_color.jpg
>
>
Appx_ODBC_Hierarchy.jpg
 
Changed:
<
<

AppxODBC requires 3 components to work. The Appx FMS Server (APPX server configured to listen on TCP 8060 by default), The Appx ODBC Data Gateway (aka AppxODBC Server, configured to listen on TCP 1992), and the Appx ODBC Driver with ASQL tool. These components can all be installed on one computer or each component could be installed on separate computers. The Appx FMS server should already be installed and running. The APPX FMS Server is an APPX server configured to accept APPX client connections via TCP, by default TCP 8060. Install the Appx ODBC Data Gateway, then the Appx ODBC Driver + ASQL. Run ASQL to import Apppx dictionaries. On non-admin PCs you could choose to install the Appx ODBC Driver (minus ASQL). Here's what each installer does do... This will install the "Appx ODBC Data Gateway" service and supporting files. This service listens on TCP port 1992 for connections from the Appx ODBC Driver installed on the ODBC client desktops. The Data Gateway contains one or more database directories each with it's own schemas imported via ASQL and each having its own appx.env file that tells it the host and port of the Appx FMS Server for that database. By default the installer creates a default database called "appx". This creates a directory tree in the server install directory called "appx.dbs". That directory contains all the schema files for database "appx" as well as its appx.env file. The bin subdirectory of the AppxODBC Server directory contains two important executables the gateway service tool AppxODBC.exe. This is the program that will listen for connection attempts on TCP port 1990 from desktop computers running the Appx ODBC driver. You'll also find in the bin sub directory the mdcreate.exe. I'll explain mdcreate in an example further in this documentation, mdcreate is a command line tool optionally used to create connections to secondary APPX servers.

When a connection request is received from a desktop driver it takes the database from the request, "appx" by default, reads the appx.env file, and attempts to start up an FMS connection to that Appx host using the login and password received from the desktop driver. If authentication is successful then the APPX ODBC server starts brokering requests from the ODBC client desktop's ODBC driver to the APPX FMS server. Your server's process list on the APPX ODBC server will have a new Data Gateway task for each ODBC client driver connection. Each Data Gateway task creates its own APPX FMS connection to the Appx server.

The installer should create everything needed in the way of the "appx" database, the appx.env file, and configure and start the service task. Upon completion of the installer the Appx ODBC Data Gateway should be ready for connections. This installer does not install an Appx ODBC driver or ASQL application. Nothing on this server is visibly runnable other than you can see that the service is running using Microsoft Windows Services applet. You might look at the appx.env file to see that it looks right.
>
>

AppxODBC requires 3 components to work. The Appx FMS Server (APPX server configured to listen on TCP 8060 by default), The Appx ODBC Data Gateway (aka AppxODBC Server, configured to listen on TCP 1992 by default), and the Appx ODBC Driver with ASQL tool. These components can all be installed on one computer or each component could be installed on separate computers. The Appx FMS server should already be installed and running. The APPX FMS Server is an APPX server configured to accept APPX client connections via TCP, by default TCP 8060. Install the Appx ODBC Data Gateway, then the Appx ODBC Driver + ASQL. Run ASQL to import Apppx dictionaries. On non-admin PCs you could choose to install the Appx ODBC Driver (minus ASQL). Here's what each installer does do... This will install the "Appx ODBC Data Gateway" service and supporting files. This service listens on TCP port 1992 for connections from the Appx ODBC Driver installed on the ODBC client desktops. The Data Gateway contains one or more database directories each with it's own schemas imported via ASQL and each having its own appx.env file that tells it the host and port of the Appx FMS Server for that database. By default the installer creates a default database called "appx". This creates a directory tree in the server install directory called "appx.dbs". That directory contains all the schema files for database "appx" as well as its appx.env file. The bin subdirectory of the AppxODBC Server directory contains two important executables the gateway service tool AppxODBC.exe. This is the program that will listen for connection attempts on TCP port 1992 from desktop computers running the Appx ODBC driver. You'll also find in the bin sub directory the mdcreate.exe. I'll explain mdcreate in an example further in this documentation, mdcreate is a command line tool optionally used to create connections to secondary APPX servers.

When a connection request is received from a desktop driver it takes the database from the request, "appx" by default, reads the appx.env file, and attempts to start up an FMS connection to that Appx host using the login and password received from the desktop driver. If authentication is successful then the APPX ODBC server starts brokering requests from the ODBC client desktop's ODBC driver to the APPX FMS server. Your server's process list on the APPX ODBC server will have a new Data Gateway task for each ODBC client driver connection. Each Data Gateway task creates its own APPX FMS connection to the Appx server.

The installer should create everything needed in the way of the "appx" database, the appx.env file, and configure and start the service task. Upon completion of the installer the Appx ODBC Data Gateway should be ready for connections. This installer does not install an Appx ODBC driver or ASQL application. Nothing on this server is visibly runnable other than you can see that the service is running using Microsoft Windows Services applet. You might look at the appx.env file to see that it looks right.
 This will install the desktop Appx ODBC Driver. This is what WinSQL and other desktop application will use to connect to the Appx ODBC Data Gateway, which in turn connect to APPX. During the install it will create a default System DSN using the driver and setting up the DSN to properly connect to the Appx ODBC Data Gateway. Once this installer is done the driver should be installed and there should be a functioning System DSN you can use to request data. That can't happen until ASQL has been run to import Appx data dictionaries into the Data Gateway database schemas. ASQL is not included in this installer for security reasons. When you use the driver to get data the user and password you use is your Appx user and password for the Appx server on the back end of the FMS connection between the Appx ODBC Data Gateway and the Appx FMS server.
Changed:
<
<
>
>
 This is the same as the other driver installer except that it does include ASQL. This must be installed on at least one desktop so that ASQL.exe can be used to import the APPX data dictionary of the desired APPX files.

Disclaimer

Line: 26 to 26
 APPX ODBC 6.1.0 includes many new features and bug fixes. As always, before upgrading your APPX production system, you are strongly encouraged to install APPX ODBC 6.1.0 into a test environment where you can verify the compatibility of your applications. APPX ODBC 6.1.0 has been thoroughly tested but, because of the complexity of computer software, there will certainly be bugs and some ODBC clients that will not be able to connect to the ODBC server. Consequently, there is no guarantee that your applications will be completely compatible with this significant new release. It is your responsibility to test your applications to ensure that they are compatible with this new release of APPX ODBC and to make any changes that may be necessary to maintain compatibility. Finally, before upgrading your production system, make a backup of your applications and your data. Your computer software and your data are important assets of your organization. Please be prudent and take the steps needed to protect this important investment.

Known Issues:

Changed:
<
<
  • ?
>
>
  • None
 

APPX ODBC Server and Driver Installation Instructions

Windows Server/XP/Vista/Win 7/Win 8/Win8.1/Win 10

Line: 35 to 35
 

New Installation

We're going to install APPX ODBC Server on a Windows 10. APPX 6.1.0 is already installed on a Windows 10 and configured to listen on TCP port 8063. You should keep the versions the same between APPX ODBC and APPX Server, otherwise you could end up with performance issues or failure to connect errors. APPX ODBC Server listens on TCP port 1992. Let's make sure that that TCP port is available with the OS netstat command line tool.

Changed:
<
<
Verify TCP Port 1990 is open via Netstat Command
>
>
Verify TCP Port 1992 is open via Netstat Command
  Verify_Port_1992.JPG
Line: 120 to 120
 
Importing APPX data structure via the AppxODBC ASQL tool.
Changed:
<
<
020.jpg
>
>
ODBC_Driver_ASQL_Login.JPG
  Running ASQL, you are first prompted for a Data Source Name (aka DSN), and a user name and password to log into APPX with. Optionally you can enter a Database ID and Application ID. Bug: Entering a database may cause connection errors. If this happens, leave the database blank.
Changed:
<
<
021.jpg
>
>
ODBC_Driver_ASQL_Login_Filled_In.JPG
  In the image above, I'm using the default created DSN named AppxODBC, and I've specified an APPX user name and password. I am going to leave Database ID and Application ID empty and will browse via the data selector after I log in.
Changed:
<
<
022.jpg
>
>
ODBC_Driver_ASQL_Connecting.JPG
  The connecton to the Appx server is being made via the AppxODBC server.
Changed:
<
<
023.jpg

The ASQL program is performing some initial setup of the data structure.

025.jpg

The ASQL program is performing some initial setup of the data structure.

026.jpg

>
>
ODBC_Driver_ASQL_Db_Treeview.JPG
  At this point, we are presented with the databases available to our appx user that we logged into APPX with since we did not identify the initial database in the ASQL login screen. Out account can see the 1EX and DMO databases.
Changed:
<
<
027.jpg
>
>
ODBC_Driver_ASQL_DMO_Prospect.JPG
  Prospect in the DMO database is selected, and IMPORT is run. The APPX DMO PROSPECT data is then made available to external sources such as WinSQL or Excel using thier ODBC connection / data import and referencing the AppxODBC System DSN.

Manually creating a new AppxODBC data source on the AppxODBC Server

Changed:
<
<
028.jpg
>
>
ODBC_Driver_Dharma_Mdcreate.JPG
 
Changed:
<
<
On the appxODBC server, open a command window in the appxODBC\bin\ directory, and execute "mdcreate development" where development is the name of the name you wish to give the odbc gateway. It doesn't have to match anything on the APPX server side, but it would be a good idea to name it meaningfully.
>
>
On the AppxODBC server, open a command window in the AppxODBC Server\bin\ directory, and execute "mdcreate development" where development is the name of the name you wish to give the odbc gateway. It doesn't have to match anything on the APPX server side, but it would be a good idea to name it meaningfully.
 
Changed:
<
<
029.jpg
>
>
ODBC_Driver_appx_env.JPG
 
Changed:
<
<
In the screen shot above, you can see the newly created directory on the appxODBC server. I named my new appxODBC gateway localhost, and the mdcreate tool created a directory on the appxODBC server named localhost.dbs. Inside the directory localhost.dbs you can see a configuration file named appx.env. This appx.env file contains a string "APPX_DATA_SERVER=localhost:8060". This string tells the appxODBC server that listens on TCP port 1990 to connect to the APPX Server on localhost at TCP port 8060.
>
>
In the screen shot above, you can see the newly created directory on the appxODBC server. I named my new appxODBC gateway localhost, and the mdcreate tool created a directory on the appxODBC server named localhost.dbs. Inside the directory localhost.dbs you can see a configuration file named appx.env. This appx.env file contains a string "APPX_DATA_SERVER=localhost:8063". This string tells the appxODBC server that listens on TCP port 1992 to connect to the APPX Server on localhost at TCP port 8063.
 
Changed:
<
<
030.jpg
>
>
ODBC_Data_Source_Apps.JPG
 
Changed:
<
<
As you can see above, there are actually two odbcad32.exe files on my APPX ODBC client (the desktop that I install ASQL.exe). My 64 bit OS places the 32 bit odbcad32.exe inside \Windows\SysWOW64\odbcad32.exe. Use the 32bit version to create the new DSN for the newly created ODBC datasource on the appxODBC server.
>
>
As you can see above, there are actually two odbcad32.exe files on my APPX ODBC client (the desktop that I install ASQL.exe). My 64 bit OS places the 64 bit odbcad32.exe inside \Windows\System32\odbcad32.exe. Use the 64bit version to create the new DSN for the newly created ODBC datasource on the AppxODBC server.
 
Changed:
<
<
031.jpg
>
>
ODBC_Driver_Sources_Administrator.JPG
 
Changed:
<
<
\Windows\SysWOW64\odbcad32.exe (for 64 bit windows) or \Windows\System32\odbcad32.exe (for 32 bit Windows), System DSN tab shows the default created AppxODBC System DSN. We want to create a new DSN to match the manually created data source that we created on the appxODBC server.
>
>
\Windows\SysWOW64\odbcad32.exe (a 32 bit application) or \Windows\System32\odbcad32.exe (a 64 bit application), System DSN tab shows the default created AppxODBC System DSN. We want to create a new DSN to match the manually created data source that we created on the appxODBC server.
 
Changed:
<
<
032.jpg
>
>
ODBC_Driver_Dharma_Setup_Appx.JPG
  In the photo above as a point of reference, you can see the values that are assigned to the default created AppxODBC System DSN. Notice the database is named appx. This corresponds to the appx.dbs directory on the appxODBC server in the \Program Files (x86)\AppxODBC Server\ directory. In the next steps below we will create a System DSN using a database named localhost to match what we created on the appxODBC server.
Changed:
<
<
033.jpg
>
>
ODBC_Create_New_Data_Source.JPG
  In the image above, after clicking the Add button on the System DSN tab, we are presented with the choice of data source driver. Choose AppxODBC Driver.
Changed:
<
<
034.jpg
>
>
ODBC_Driver_Dharma_Setup_blank.JPG
  The blank fields above are presented after you select the driver. You'll want to fill in the first four fields: Data Source Name, Description, Host and Database.
Changed:
<
<
035.jpg
>
>
ODBC_Driver_Dharma_Setup_localhost.JPG
  The value you use in the first field in the image above, Data Source Name, will be referenced by the ASQL data importer when you are prompted for the Data Source Name. The second field, Description, is just for reference. The third field, Host, should be a DNS name that is resolvable, or an IP address to the appxODBC server, that may or may not be the same as the Appx server.. The last field we will fill in is the Database field. This field is the name of the database on the appxODBC server that we wish to connect to. Each database will have a databasename.dbs directory in the C:\Program Files\AppxODBC Server\ directory.
Changed:
<
<
036.jpg
>
>
ODBC_Driver_Sources_Administrator_2.JPG
  Your newly created appxODBC System DSN is now ready for the schema importer ASQL.exe.

Troubleshooting

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

<--/commentPlugin-->
>
>

<--/commentPlugin-->
  -- BrianRyan - 2021-06-07
Line: 292 to 284
 
META FILEATTACHMENT attachment="ODBC_Driver_Create_DSN.jpg" attr="h" comment="" date="1623174047" name="ODBC_Driver_Create_DSN.jpg" path="ODBC_Driver_Create_DSN.jpg" size="29981" user="BrianRyan" version="1"
META FILEATTACHMENT attachment="ODBC_Driver_Create_DSN_Selected.jpg" attr="h" comment="" date="1623174590" name="ODBC_Driver_Create_DSN_Selected.jpg" path="ODBC_Driver_Create_DSN_Selected.jpg" size="29420" user="BrianRyan" version="1"
META FILEATTACHMENT attachment="ODBC_Driver_Finish.jpg" attr="h" comment="" date="1623177675" name="ODBC_Driver_Finish.jpg" path="ODBC_Driver_Finish.jpg" size="30647" user="BrianRyan" version="1"
Added:
>
>
META FILEATTACHMENT attachment="ODBC_Driver_ASQL_Login_Filled_In.JPG" attr="h" comment="" date="1623241037" name="ODBC_Driver_ASQL_Login_Filled_In.JPG" path="ODBC_Driver_ASQL_Login_Filled_In.JPG" size="37393" user="BrianRyan" version="1"
META FILEATTACHMENT attachment="ODBC_Driver_ASQL_Login.JPG" attr="h" comment="" date="1623241037" name="ODBC_Driver_ASQL_Login.JPG" path="ODBC_Driver_ASQL_Login.JPG" size="37063" user="BrianRyan" version="1"
META FILEATTACHMENT attachment="ODBC_Driver_ASQL_DMO_Prospect.JPG" attr="h" comment="" date="1623242012" name="ODBC_Driver_ASQL_DMO_Prospect.JPG" path="ODBC_Driver_ASQL_DMO_Prospect.JPG" size="69603" user="BrianRyan" version="1"
META FILEATTACHMENT attachment="ODBC_Driver_ASQL_Db_Treeview.JPG" attr="h" comment="" date="1623242012" name="ODBC_Driver_ASQL_Db_Treeview.JPG" path="ODBC_Driver_ASQL_Db_Treeview.JPG" size="32275" user="BrianRyan" version="1"
META FILEATTACHMENT attachment="ODBC_Driver_ASQL_Connecting.JPG" attr="h" comment="" date="1623242012" name="ODBC_Driver_ASQL_Connecting.JPG" path="ODBC_Driver_ASQL_Connecting.JPG" size="14873" user="BrianRyan" version="1"
META FILEATTACHMENT attachment="ODBC_Driver_Dharma_Mdcreate.JPG" attr="h" comment="" date="1623243302" name="ODBC_Driver_Dharma_Mdcreate.JPG" path="ODBC_Driver_Dharma_Mdcreate.JPG" size="100930" user="BrianRyan" version="1"
META FILEATTACHMENT attachment="ODBC_Driver_appx_env.JPG" attr="h" comment="" date="1623245592" name="ODBC_Driver_appx_env.JPG" path="ODBC_Driver_appx_env.JPG" size="204403" user="BrianRyan" version="1"
META FILEATTACHMENT attachment="ODBC_Data_Source_Apps.JPG" attr="h" comment="" date="1623246604" name="ODBC_Data_Source_Apps.JPG" path="ODBC_Data_Source_Apps.JPG" size="46300" user="BrianRyan" version="1"
META FILEATTACHMENT attachment="ODBC_Driver_Sources_Administrator.JPG" attr="h" comment="" date="1623246766" name="ODBC_Driver_Sources_Administrator.JPG" path="ODBC_Driver_Sources_Administrator.JPG" size="44005" user="BrianRyan" version="1"
META FILEATTACHMENT attachment="ODBC_Driver_Dharma_Setup_Appx.JPG" attr="h" comment="" date="1623247318" name="ODBC_Driver_Dharma_Setup_Appx.JPG" path="ODBC_Driver_Dharma_Setup_Appx.JPG" size="39638" user="BrianRyan" version="1"
META FILEATTACHMENT attachment="ODBC_Create_New_Data_Source.JPG" attr="h" comment="" date="1623247507" name="ODBC_Create_New_Data_Source.JPG" path="ODBC_Create_New_Data_Source.JPG" size="32285" user="BrianRyan" version="1"
META FILEATTACHMENT attachment="ODBC_Driver_Dharma_Setup_blank.JPG" attr="h" comment="" date="1623247859" name="ODBC_Driver_Dharma_Setup_blank.JPG" path="ODBC_Driver_Dharma_Setup_blank.JPG" size="37489" user="BrianRyan" version="1"
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"
 
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