Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
Added: | ||||||||
> > |
APPX 4.2.9, MySQL, and UnixODBC on 64-bit Debian 5 | |||||||
Added: | ||||||||
> > | APPX, MySQL, and UnixODBC will all work under 64-bit Debian, but because the OS is 64-bit and APPX is 32-bit, it will require two sets of drivers and some additional 32-bit libraries. Isql will only work with the 64-bit MySQL UnixODBC connector drivers, and APPX will only work with the 32-bit ones.
Installing the ODBC ConnectorsThe 64-bit ODBC connectors can be downloaded here. Untar the bundle and copy the drivers from the lib directory within it to /usr/lib/odbc/. The 32-bit ODBC connectors can be downloaded here. Untar that bundle as well and copy the contents of the lib directory within it to /emul/ia32-linux/lib/.Configuring odbc.ini and odbcinst.iniConfigured like this, the system will be able to make use of UnixODBC, but you will need to point APPX specifically to the 32-bit driver. debian-64:/usr/local/appx.429# cat /etc/odbcinst.ini#[MySQL ODBC 5.1 Driver] [mysql] #Driver = /usr/lib/libmyodbc5.so Driver = /usr/lib/odbc/libmyodbc5.so UsageCount = 1 debian-64:/usr/local/appx.429# cat /etc/odbc.ini [mysql] Description = mysql Driver = mysql Server = localhost Database = test Port = Socket = Option = Stmt = Pointing APPX to the 32-bit DriverOpen appx.env and configure it so that APPX is pointed to the driver located in /emul/ia32-linux/lib debian-64:/usr/local/appx.429# head /usr/local/appx.429/data/appx.envAPPX_ODBC_LIB=/emul/ia32-linux/lib/libmyodbc5.so #APPX_SQL_CMD=/usr/local/appx.429/appx_sql_cmd.txt #APPX_DBG_CODE=0xFFFFFFFF ############################################################################### # # APPX Configuration File # ----------------------- # # This file can be used to configure your APPX environment. Upon startup, debian-64:/usr/local/appx.429# Additional 32-bit LibrariesNow, APPX will need some additional libraries that aren't found in 64-bit Debian 5 by default. They can be copied from the /lib and /usr/lib directories from a 32-bit installation of Debian 5. Here is a list of the libraries you will need. Copy them into your /emul/ia32-linux/lib/ directory.
Comments:Read what other users have said about this page or add your own comments. |