mkdir /opt/openlink
cd /opt/openlink
.taz
archive, and an optional administrator
.taz
file. Download these documents using
binary-preserving methods (e.g., ftp in BIN mode, or scp), and
place them in your installation folder.sh install.sh
http://broker-host.example.com:8000/
admin
." This is the username you will use when
working with the OpenLink Request Broker's HTTP-based Admin
Assistant. (You can set up other usernames later; consider this one
similar to "root
.")admin
." This is the password associated with the
username you just set.[generic_ora{{version}}]
. For Example, the Oracle 12
parameters are located in:[generic_ora12]
.Connect Options = -H {{host}} -P {{port
number}}
.<OPENLINK_INSTALL>/bin/odbc.ini
with a suitable
text editor such as vi.[mysql] Driver = <OPENLINK_INSTALL>/lib/mys5_mt_lt.so ServerType = MySQL 5.x Options = -H mysql5.hostname Database = database UserName = mysql Password = ********** FetchBufferSize = 99 ReadOnly = no DeferLongFetch = no JetFix = no Description = Sample MySQL 5.x Lite Connection
iodbctest
tool which is packaged with the
HTTP-based OpenLink ODBC Administrator as follows:
# cd <OPENLINK_INSTALL> # . ./openLink.sh # iodbctest mysql
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0507.0105
Driver: 06.02.1217 OpenLink Generic ODBC Driver (oplodbc.so)
SQL>
Additional Information:
The bitness of the ODBC Driver for MySQL is determined by the
bitness of your ODBC client application.
That is, if your ODBC client application is 32-bit then the Generic
ODBC Driver component MUST also be 32-bit.
$OPENLINK_INSTALL/bin/odbc.ini
with
a suitable text editor such as vi
.[OpenLink] Driver = /OPENLINK_INSTALL/lib/oplodbc.so Host = localhost:5000 ServerType = Oracle 8.1.x Database = Options = Username = Password = FetchBufferSize = 99 ReadOnly = no DeferLongFetch = no JetFix = no Description = Sample DSN
[mysql5] Driver = /OPENLINK_INSTALL/lib/oplodbc.so Host = requestbroker_hostname:5000 ServerType = MySQL 5.x Database = test Options = -H mysql_hostname -P 3306 Username = root Password = ********** FetchBufferSize = 99 ReadOnly = no DeferLongFetch = no JetFix = no Description = Sample MySQL 5.x Connection
iodbctest
tool, which is packaged with the
HTTP-based OpenLink ODBC Administrator, as follows:
# cd OPENLINK_INSTALL # . ./openlink.sh # iodbctest mysql5 iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0507.0105 Driver: 06.02.1217 OpenLink Generic ODBC Driver (oplodbc.so) SQL>You should now be able to issue SQL statements directly against the target database.
mkdir /opt/openlink
cd /opt/openlink
cd /opt/openlink
Download these documents
using
binary-preserving methods (e.g., ftp in BIN mode, or scp), and
place them in your installation folder.
export JAVA_HOME=/path/to/your/JAVA/installation
sh install.sh
opljdbc3.jar,
megathin3.jar
openlink.jdbc3.Driver
jdbc:openlink://<Hostname>:[portnumber] [/UID] [/PWD]
[/READONLY] [/SVT] [/APPLICATION] [/FBS|FETCHBUFFERSIZE]
[/ENCRYPTED] [/CHARSET] [/UNICODE] [/DLF] [/DATABASE] [/OPTIONS]
[/DRIVER]
/ENCRYPTED
may pass '1', '0', 'Y',
'N', 'y', or 'n'. (This feature is disabled by default.)System.getProperty("file.encoding")
./DLF
may be set to '1', '0',
'Y', 'N', 'y', or 'n'. (This feature is disabled by default.)jdbc:openlink://localhost:5000/SVT=Ingres
II/DATABASE=iidbdb/UID=ingres/PWD=ingres
jdbc:openlink://192.128.13.119:5000/SVT=Oracle
8.1.x/DATABASE=ORCL/UID=scott/PWD=tiger
jdbc:openlink://saturn:5000/SVT=Progress
91D/DATABASE=isports/OPTIONS=-S isports -N tcp -H
saturn
jdbc:openlink://localhost:5000/SVT=SQLServer
2000/DATABASE=Northwind/UID=sa/OPTIONS=-S SATURN
Need Assistance?
Contact Sales