Difference: SandboxTestPage (8 vs. 9)

Revision 92011-07-08 - ChrisBrower

Line: 1 to 1
 

APPX 4.2.9, MySQL, and UnixODBC on RHEL 6/Scientific Linux 6/Oracle Linux 6

Line: 9 to 9
 

64-Bit Red Hat/Scientific Linux/Oracle Linux 6

APPX can connect to 64-bit MySQL using 32-bit ODBC connector drivers and some 32-bit libraries that can be installed through the package manager.

Added:
>
>

Installing MySQL

MySQL can be installed with yum by installing the following packages: 

mysql.i686 : MySQL client programs and shared libraries
mysql-server.i686 : The MySQL server and related files

Installing unixODBC

UnixODBC can also be installed using yum by installing the following packages: 

unixODBC.i686 : A complete ODBC driver manager for Linux
mysql-connector-odbc.i686 : ODBC driver for MySQL
 

Installing the ODBC Connectors

The 32-bit connectors might not be included in the repository. If they are, you would find them under a name like

Line: 71 to 83
 
[root@localhost ~]# file /usr/bin/isql
/usr/bin/isql: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.18, stripped
Added:
>
>		A positive test using ISQL should result in something like this: 
[root@localhost ~]# isql mysql
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>
 

Comments:

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

View topic | History: r26 < r25 < r24 < r23 | More topic actions...
 
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