Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPX ODBC Installations Instructions | ||||||||
Line: 35 to 35 | ||||||||
Let's download the APPX ODBC Server and start the installation. | ||||||||
Changed: | ||||||||
< < | ||||||||
> > | ||||||||
Execute the AppxODBCserver _5_0_2_windows.exe installation file shown in the image above. | ||||||||
Line: 49 to 49 | ||||||||
Added: | ||||||||
> > | You can accept the default Start Menu Folder name of AppxODBC Server. | |||||||
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. | |||||||
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. | |||||||
Added: | ||||||||
> > | AppxODBC server installation is complete.
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.
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.
As you can see in the image above, the tool placed an uninstall option in the just created AppxODBC menu group.
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.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. | |||||||
Comments: |