Kathy
This is how you do it
ODBC OpenLink Installation
The installation of ODBC multi-tier software requires the following steps;
Download the following files from the OpenLink website;
1.) Data Source Administrator & Samples(taz)(recommended)Web-based Data Source
Administrator & JDBC Samples:
ftp://download.openlinksw.com/uda/open52/a5l5adzz.taz
2.) iODBC SDK(taz) (required):
ftp://download.openlinksw.com/uda/open52/a5kozzzz.taz
3.) ODBC Client only (taz)(required):
ftp://download.openlinksw.com/uda/open52/a5oczzzz.taz
4.) Request Broker (taz)(required):
ftp://download.openlinksw.com/uda/open52/a5brzzzz.taz
5.) SQLServer Database agent (taz)(required):
ftp://download.openlinksw.com/uda/open52/a5ammzzz.taz
6.) Unix Installation Shell Script (required):
ftp://download.openlinksw.com/uda/open52/install.sh
Once you have download and place these file in the installation
Directory, perform the following steps:
a) Run the command below to install the new components in this location:
sh install.sh
b) Run the following command to set the necessary OpenLink environment
variables for this installation:
. ./openlink.sh
c) Place the OpenLink oplrqb.lic license file in the bin directory of
the OpenLink directory.
d) Change directory to the 'bin' directory of your installation
and run the command:
./oplrqb -fd to run it in the debug mode on your terminal
or
./oplrqb -v to run it in detached mode
The -fd option should produce output of the following form:
OpenLink Request Broker
Version 2.41 as of Tue Feb 01 2005 (Release 5.2 cvsid 00076).
Compiled for AIX 3 (powerpc-ibm-aix4.3.3.0-32)
Copyright (C) OpenLink Software.
Registered to OpenLink Internal Use
with product serial number opl-internal
Issued by OpenLink Data Access Support (UK)
This license will expire on Wed Feb 01 18:00:00 2006 GMT
oplrqb: using rulebook
/dbs6/openlink/32bit/v52/tsuite/tmp/bin/oplrqb.ini
oplrqb: bound UDP protocol to 0.0.0.0.60001
oplrqb: bound TCP protocol to 0.0.0.0.5432
oplrqb: using UDP address 192.168.11.114.0 for IPC
oplrqb: request broker started by openlink
oplrqb: spawning
/dbs6/openlink/32bit/v52/tsuite/tmp/bin/w3config/www_sv www_sv
+debug
www_sv: started http://oplusaix2.usnet.private:8765
oplrqb: started persistent www_sv (pid=30068)
oplrqb: rendezvous thread started
oplrqb: rendezvous registration SQLServer (oplusaix2)
e) Assuming the www_sv persistence service is started successfully you should
then be able to access it on the URL specified in the Broker start log above.
d) You can then choose to configure a DSN to connection to SQLServer, either
via the Admin Assitant interface or manually using the connection parameters
oplrqb.ini and odbc.ini.
To configure the odbc.ini manually, set the following parameters to;
[OpenLink]
Driver = /opt/OPENLINK/lib/oplodbc.so
ServerType = SQLServer 2000
Username = tlogtest
Password = pa55word
Database = synopsys
Options = -S 172.16.0.34 -P 1434 -V 8.0
FetchBufferSize = 99
ReadOnly =
DeferLongFetch =
Host = localhost:5000
Description = ODBC sqlserver
UseSSL =
NoLoginBox =
SqlDbmsName =
To configure the oplrqb.ini manually, set the following parameters to;
[Environment SQLSERVER]
FREETDSCONF = /opt/OPENLINK/bin/freetds.conf
DSQUERY = SQLSERVER ; Load this section from freetds.conf
TDSHOST = sql2 ; Point this to your SQLServer machine
TDSPORT = 1434
TDSVER = 2000
CURSOR_SENSITIVITY = LOW ; Set to HIGH after loading oplrvc.sql
To run the admin assistance;
>From your browser run the following;
>http://travellog.exploreworldwide.com:9002/
To test the sqlserver manually, run;
/opt/OPENLINK/samples/ODBC/iodbctest
You will get the following prompt;
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0205.0201
Enter ODBC connect string (? shows list): ?
Then type OpenLink
You should get a SQL> prompt for a successful connection, and you've then
connected to the SQL server.
Bob
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Vance, Kathy
Sent: 18 October 2005 16:52
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database
Hi Bob, I hope I did not miss your reply. We have the problem to make
SQL 2000 communicate with Universe 10 or 11 with IBM Universe ODBC
driver. Based on its document, this driver seems do not support the SQL
server.
Could you share your experience on the way of using OpenLink ODBC driver
for SQL server?
Thanks,
Kathy
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Peter Gonzalez
Sent: Friday, October 14, 2005 12:25 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database
Hello Bob. I would like to see a sample of how you do that. You
don't
have to give away your source, but giving us an ideal of how it works.
thanks.
>
>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney
>Sent: Thursday, October 13, 2005 11:13 PM
>To: u2-users@listserver.u2ug.org
>Subject: RE: [U2] connection from UniBasic to a SQL database [was What
>are you using to develop your web pages...] {Unclassified}
>
>Wendy:
>
>We talk to ms sql all the time thru OpenLink ODBC drivers using the BCI
>
>It works fine and the only problems we had was with the ODBC driver
>
>Have routines that do it if you'd like to look
>
>Bob
>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] Behalf Of gerry-u2ug
>Sent: 14 October 2005 01:48
>To: u2-users@listserver.u2ug.org
>Subject: RE: [U2] connection from UniBasic to a SQL database [was What
>are you using to develop your web pages...] {Unclassified}
>
>
>things are not this simle on unix - 3rd party odbc drivers need to be
>purchased , installed & configured.
>I have never worked with a client who has gone this route, it never
>seems to be worth the bother & expense.
>
>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] Behalf Of HENDERSON MIKE,
>MR
>Sent: Thursday, October 13, 2005 06:11 PM
>To: u2-users@listserver.u2ug.org
>Subject: RE: [U2] connection from UniBasic to a SQL database [was What
>are you using to develop your web pages...] {Unclassified}
>
>
>Wendy
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] On Behalf Of Wendy Smoak
> > Sent: Friday, 14 October 2005 09:10
> > To: u2-users@listserver.u2ug.org
> > Subject: Re: [U2] [AD] What are you using to develop your web pages?
> > JavaScript? PHP? .Net?
> >
> > From: "Symeon Breen" <[EMAIL PROTECTED]>
> >
> > > it is easy to read/write mysql from your Unibasic.
> >
> > Really? So far we have not been successful getting a connection
from
> > UniBasic to a SQL database. What are you using? (My guess is that
> > you're on Windows.)
>
>I've written stuff to read from a SQL database into UniBasic using the
>BCI.
>There's no conceptual difference between reading & writing, it's just a
>matter of using a SQL INSERT or MODIFY instead of a SELECT in the
string
>passed to SQL. I do have some doubts about how to set up transactions
>to allow simultaneous SQL & UV updates, but that's functionality we
>don't need yet.
>
>The BCI documentation is sparse and the example code execrable, but it
>does work and performance is not too bad, either.
>
>UV 10.0.15 to MS SQL Server 2000, all on Windows, using the MS SQL
>Server driver.
>
>Mike
>
> >
> > We're on HP-UX. At the moment I'm reading from Sybase with their
JDBC
>
> > driver then using UniObjects for Java to write records into UniData.
> > It's working fine, but it would be
> > *really* nice to connect directly to Sybase from a UniBasic program.
> >
> > --
> > Wendy Smoak
> > -------
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> >
>The information contained in this Internet Email message is intended
for
>the addressee only and may contain privileged information, but not
>necessarily the official views or opinions of the New Zealand Defence
>Force.
>If you are not the intended recipient you must not use, disclose, copy
>or distribute this message or the information in it.
>
>If you have received this message in error, please Email or telephone
>the sender immediately.
>-------
>u2-users mailing list
>u2-users@listserver.u2ug.org
>To unsubscribe please visit http://listserver.u2ug.org/
>-------
>u2-users mailing list
>u2-users@listserver.u2ug.org
>To unsubscribe please visit http://listserver.u2ug.org/
>
>______________________________________________________________________
>This email has been scanned by the MessageLabs Email Security System.
>For more information please visit http://www.messagelabs.com/email
>______________________________________________________________________
>
>______________________________________________________________________
>This email has been scanned by the MessageLabs Email Security System.
>For more information please visit http://www.messagelabs.com/email
>______________________________________________________________________
>-------
>u2-users mailing list
>u2-users@listserver.u2ug.org
>To unsubscribe please visit http://listserver.u2ug.org/
>-------
>u2-users mailing list
>u2-users@listserver.u2ug.org
>To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
