[cobalt-developers] Fw: iODBC and Openlink on Cobalt RAQ2 - some questions

["Sigurd Magnusson" <phobo@xxxxxxxxxxxxxxx>]

Does anyone here have some ideas on this problem ?
("OpenLink: unable to start the requested database agent")....

Siggy


----- Original Message -----
From: "Siggy" <antiphobo@xxxxxxxxxxxxxxx>
Newsgroups: openlink.public.multi-tier.odbc-agent
Sent: Friday, October 27, 2000 11:28 AM
Subject: Re: iODBC and Openlink on Cobalt RAQ2 - some questions


> (intro: PHP4/Apache Redhat Linux Machine (Colbalt Raq2) to communicate
with
> a .MDB on a networked Win98 machine. I have PHP4/Apache installed ok with
> openlink, but recieve errors when i try to connect to any DSN )
>
> ok, i installed openlink using ONLY these files:
>
> lmkozzzz.taz
> lmbrzzzz.taz
> install.sh
>
> is that ---all--- i need for Openlink on the Raq???
>
> The error is:
>
> OpenLink: RPC: Program unavailable
> [OpenLink][ODBC]RPC: Program unavailable, SQLSTATE=08004
> [OpenLink][ODBC]Connection rejected by data source, SQLSTATE=08004
>
> If I tried 'starting' it from oplcfg I got
> Unable to contact the request broker on localhost (RPC: Program
unavailable)
>
> After some fiddling around (i think it chanaged coz i export'd the needed
> things such as a the odbc.ini location etc); like this:
>
> SHLIB_PATH=$SHLIB_PATH:/usr/local/openlink/lib
> PATH=$PATH:/usr/local/openlink/bin:/usr/local/openlink/samples/
> ODBCINSTINI=/usr/local/openlink/bin/odbcinst.ini
> PATH=$PATH:/usr/local/openlink/bin:/usr/local/openlink/samples/
> export UDBCINI ODBCINI ODBCINSTINI PATH LD_LIBRARY_PATH LIBPATH
>
> i now get
>
> OpenLink: unable to start the requested database agent
> [OpenLink][ODBC]unable to start the requested database agent,
SQLSTATE=08004
> [OpenLink][ODBC]Connection rejected by data source, SQLSTATE=08004
>
> I am confused when you say the 'request broker' ? Is that what is residing
> on the Linux machine, the 'oplcfg' executable etc ?"
>
> Thanks,
> Siggy
>
>
>
>
> Netrista Khatam" <nkhatam@xxxxxxxxxxxxxx> wrote in message
> news:39f86387.0@xxxxxxxxxxxxxxxxxxxxx
> > Hello Siggy,
> >
> >      First, you need to debug your basic connectivity. If odbctest does
> not
> > work, you will never be able to connect with PHP. That said, there are
two
> > errors which produce messages similar to the one which you have posted.
> > First, you are probably receiving "Program Unavailable" messages. If
this
> is
> > so, please do the following:
> >
> >
> > 1. Pass the IP address of the machine with the Request Broker in your
DSN
> > Hostname fields.
> >
> > 2. Insure that the Request Broker is started on the server. In order to
> > start it, please descend
> > into the server's ~/openlink/bin directory and type the following
command:
> >
> > oplrqb +loglevel 7 + logfile oplrqb.log - Windows
> > ./oplrqb +loglevel 7 +logfile oplrqb.log - UNIX
> >
> > 3. Insure that odbc_sv exists in your server's ~/openlink/bin directory.
> >
> > 4. Let us know, if you have firewalls or multiple network cards in your
> > server. Make your that you can ping your server, as well.
> >
> > Second, your server's ~/openlink/bin/oplrqb.ini file may not be set up
> > properly. Open this file and locate [generic_odbc]. Here, make sure that
> > Program=odbc_sv is set.
> >
> > Finally, if you continue to have problems, please open an online support
> > case. In order to open this case, click on the Technical Support Form
link
> > at the following address: http://www.openlinksw.com/support/online.htm.
> >
> >
> > Best regards,
> > Netrista Khatam
> >
> >
> >
> >
> >
> >
> > "Siggy" <antiphobo@xxxxxxxxxxxxxxx> wrote in message
> > news:39f7fc62.0@xxxxxxxxxxxxxxxxxxxxx
> > > Do I -need- iODBC at all ? Openlink seems to say it includes iODBC as
> well
> > ?
> > > Do I -need- to create a user for openlink? I'm confused with how to
set
> up
> > > the ENV vars (like the path to Odbc.ini etc) each time the server
> starts.
> > >
> > > To set up a connection from PHP on a Linux machine to a .MDB what do i
> > need
> > > to do ?
> > >
> > > I tried this but I got errors when I tried got php to make a
> > odbc_connect()
> > > call:
> > > ("
> > >
> > > download/configure/make iODBC sourcecode
> > >
> > > mkdir /usr/local/openlink
> > > install Openlink (get two .TAZ files, run install.sh)
> > >
> > > ---
> > >
> > > download/configure/make PHP and Apache
> > > (using --open-link=/usr/local/openlink)
> > >
> > > (this bit worked fine).
> > >
> > > ----
> > >
> > > when i run odbctest, it does not work; i get message from
> > > [OpenLink][ODBC]RPC: saying 'Program not found' (or something very
> > similar)
> > >
> > >
> > > ( if i try the DSN with out the "DSN=" bit (ie, using an invalid
> syntax),
> > i
> > > get :
> > > the [OpenLink][ODBC]RPC: Dialog failed error )
> > >
> > >
> > > Any assistance ?
> > >
> > >
> >
> >
>
>