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.[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
Example Progress SQL-89/4GL Data Source:
[progress100sql89] Driver = /OPENLINK_INSTALL/lib/oplodbc.so Host = requestbroker_hostname:5000 ServerType = Progress 100A Database = /dbs/progress/wrk10b/sports2000.db Options = -H hostname -S servicename -N tcp Username = Password = FetchBufferSize = 99 ReadOnly = no DeferLongFetch = no JetFix = no Description = Sample Progress SQL-89 Connection
Example Progress SQL-92 Data Source:
[progress100sql92] Driver = /OPENLINK_INSTALL/lib/oplodbc.so Host = requestbroker_hostname:5000 ServerType = Progress 100SQL Database = /dbs/progress/wrk10b/sports2000.db Options = -H hostname -S servicename -N tcp Username = sysprogress Password = FetchBufferSize = 99 ReadOnly = no DeferLongFetch = no JetFix = no Description = Sample Progress SQL-92 Connection
NOTE: The "-H hostname -S servicename -N
tcp
" parameters represent a socket-based connection to the
database. Presuming the OpenLink Request Broker is already running
on the target machine, you are now ready to test the
connection.
Use the iodbctest tool which is packaged with the HTTP-based OpenLink ODBC Administrator as follows:
# cd OPENLINK_INSTALL # . ./openlink.sh # iodbctest progress100sql92
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.
Additional Information
The bitness of the Generic ODBC Driver 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.
oplrqb.ini
).vim
, vi
).[Environment PROGRESS110SQL]
DLC = {Full path to the Progress dlc directory}
PROCFG = {Full path and filename to the progress.cfg file}
Save these changes and exit the file.
Run "oplrqb stop" to stop the request broker.
Run "oplrqb start" to start the request broker with your new rulebook settings.
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