Re: [cobalt-developers] ODBC to Win98 MS Access .MDB on RAQ2 for PHP4

["Sigurd Magnusson" <phobo@xxxxxxxxxxxxxxx>]

Ok, this is what i did:

mkdir /usr/local/openlink,
put in the two Openlink .taz files (forgot names - one was the Cobalt SDK,
the other the Linux MIPS sourcecode file which had oplcfg and odbctest etc
in it).

I ran "sh install.sh"; it worked fine; (i did all the defaults) - and
brought up the oplcfg menu.

When I tried to browse to the AdminAssistant website (to port 8000 etc)
nothing happended. I restarted the broker (from oplcfg) and now the
AdminAssistant site worked but I couldn't enter a new DSN because "odbc.ini"
was not found. I then realised I needed to set up that and a few other ENV
variables -- and manually "export"ed them. How do I make it automatically do
this when the server is started? there is no file I could see called
.profile on the raq.

I thought all was fine, I set up a DSN but when I did a odbctest it
complained:
"RPC Program Not Available".

---
Question: where does iODBC fit in to all of this ?! I saw something about
needing to make a new user for openlink, put the homepage to your iODBC libs
etc - I was not sure how to do this.
---

Then I decompressed apache/php4 and configured, make'd etc them
(php was :  --with-openlink=/usr/local/openlink ) etc etc, which all
appeared to work fine (ie, odbc calls could be made from PHP, they just
didn't work).

--
Question: If i make an access DSN on the Win98, can't i make the Openlink
program look at that, instead of installing Openlink on the Win98 pc ??


One last thing - what causes "rm -d <dirname>" to produce "operation not
permitted" ? I have all these blank dirs sitting around coz I can't del them
!


Siggy


----- Original Message -----
From: "Wim Aarts" <w.aarts@xxxxxxxxxxx>
To: "Sigurd Magnusson" <phobo@xxxxxxxxxxxxxxx>
Sent: Thursday, October 26, 2000 7:39 PM
Subject: Re: [cobalt-developers] ODBC to Win98 MS Access .MDB on RAQ2 for
PHP4


>
> ----- Oorspronkelijk bericht -----
> Van: Sigurd Magnusson <phobo@xxxxxxxxxxxxxxx>
> Aan: <cobalt-developers@xxxxxxxxxxxxxxx>
> Verzonden: woensdag 25 oktober 2000 16:37
> Onderwerp: [cobalt-developers] ODBC to Win98 MS Access .MDB on RAQ2 for
PHP4
>
>
> > ODBC to Win98 MS Access .MDB on Cobalt RAQ2 for PHP4
> >
> > Today I tried for hours to work out the different functions of iODBC
> > (www.iodbc.org) and Openlink (www.openlinksw.com) in an attempt to
connect
> > to a Microsoft Access (.MDB) Database from PHP Scripts on a Raq2, except
> the
> > documentation is vague and scattered all over the place and the whole
> thing
> > has baffeled me.
> >
> > Has anyone out there suceeded in doing this ?
> Yup (not on a raq though but on Redhat 6.1 on Intel)
> >
> > I have no absolutely no problems in recompiling the new PHP and Apache
> > sourcecode (I needed to do this for session support), but if i try to
link
> > in the iODBC to php the web server will not startup again with the new
> .conf
> > file.
> >
> > (i took the .taz file and ran "sh install.sh", then continued with
> > php/apache installation).
> >
> > As for the DSN's im all confused - do I _NEED_ openlink on the Raq if I
am
> > connecting to a DSN on a Win32 machine ? Do I need it on the Raq, even ?
> > Can't I create an Access .MDB DSN which I connect to from the Raq??!
> Yup on both machines you have to install openlink.... they provide a
> "proprieaty gateway" of their own. You need the libs on the raq and the
> Openlink "server" on the win 98 machine. Open link provides some software
to
> check the DNS before compiling it into php.
> >
> > Is there some easier way -- I remember reading about something called
> 'TDS'
> > which claimed to be easier than OpenLink but I can not find it anywhere.
> Don't know
> >
> > Please reply to phobo@xxxxxxxxxxxxxxx - I am not on this list.
> >
> > Siggy
> >
> > ps: any helpful replies get a chocolate fish ;)
> >
> > _______________________________________________
> > cobalt-developers mailing list
> > cobalt-developers@xxxxxxxxxxxxxxx
> > http://list.cobalt.com/mailman/listinfo/cobalt-developers
> >
>
>