Difference: APPX61ODBCInstallationInstructions (7 vs. 8)

Revision 82010-06-25 - JoeOrtagus

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

APPX ODBC Installations Instructions

Line: 35 to 35
  Let's download the APPX ODBC Server and start the installation.
Changed:
<
<
001.jpg
>
>
001.jpg
  Execute the AppxODBCserver _5_0_2_windows.exe installation file shown in the image above.
Line: 49 to 49
  004.jpg
Added:
>
>
You can accept the default Start Menu Folder name of AppxODBC Server.
 005.jpg
Added:
>
>
In the image above, you can see the ODBC Server prompting for the TCP port that your APPX Server's appxLoginMgr is configured to listen on. This can be APPX on any platform (Windows, Linux, HPUX, IBM AIX, Sun Sparc based Solaris) with the same version of APPX as the AppxODBC that you are installing now.
 006.jpg
Added:
>
>
The image above shows that I'm instructing AppxODBC to point to the APPX server named hankwilliams.internal.appx.com on TCP port 8060.
 007.jpg
Added:
>
>
AppxODBC server installation is complete.

008.jpg

The image above demonstrates the use of OS commands tasklist, findstr and netstat to verify that the AppxODBC server process is indeed running and listening on TCP port number 1990.

009.jpg

In the image above, you can see the service "Appx ODBC Data Gateway Service" in the OS Services panel. Notice that the Startup Type is set to Automatic, and the Status is Started.

010.jpg

As you can see in the image above, the tool placed an uninstall option in the just created AppxODBC menu group.

011.jpg

The directory listing above shows some of the files that are created in the AppxODBC Server directory structure. Notice the executable in the bin subdirectory, the appx.dbs subdirectory and the appx.env file inside appx.dbs. appx.dbs is the directory created for the default DSN database named appx. The configuration information for TCP port number of APPX and the APPX Server name is contained in the appx.env file.

C:\Program Files (x86)\AppxODBC Server>more appx.dbs\appx.env

APPX_DATA_SERVER=hankwilliams.internal.appx.com:8060

C:\Program Files (x86)\AppxODBC Server>

See above the contents of the appx.env file.

Download and run the AppxODBC driver and ASQL data importer.

012.jpg

With AppxODBC 5.0.2 we've seperated the ODBC driver from the data importer. You may wish to put the APPX Server, AppxODBC server and AppxODBC driver and ASQL all on one machine. Then put just the AppxODBCdriver on each client's desktop that needs to access APPX from an application such as Microsoft Excel. If the AppxODBC user is an APPX developer, it might be desirable to have the AppxODBC driver and ASQL importer on the same desktop as the ODBC client client application (Excel, Crystal Reports, etc...). For this example I am keeping all AppxODBC components on a single machine, with the APPX Server on a separate machine. Your configuration could demand each component be installed on a separate machine.
I'm going to execute the AppxODBCdriver+ASQL_5_0_2_windows.exe to begin the installation of the driver and ASQL importer.

013.jpg

014.jpg

015.jpg

016.jpg

017.jpg

018.jpg

019.jpg

020.jpg

021.jpg

 

Comments:

 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback