Re: SQL-NET & Lotus for Mac

In article <kelly-150295141054_at_holstein.ecn.uoknor.edu>, kelly_at_mailhost.ecn.uoknor.edu (Kelly Deaver) wrote:

> I was told by Oracle staff that Lotus on my Mac could "talk" to Oracle 7 on
> our Unix server via SQL-NET. I've gotten SQL-NET installed and it connects
> to our Oracle thru importer/exporter. Now, does anyone have a clue what I
> need to do under Lotus to get it to connect? It seems that I need to edit
> the DAL file in my 123 folder but I've yet to find the magic phrase. I've
> been trying to call Lotus Tech support for a week but all I get is that
> wonderful busy signal.
>
> If you don't know about Lotus but do know about another software that would
> work, I'll accept that as an alternative. I just don't want my users to
> have to write SQL code to use their databases.

I think Lotus123 only speaks DAL. Do you have a DAL "server" on the Oracle side? This is a product from ITI, starting at about $1000.

Alternatives include:
 an ODBC driver from Intersolv or one of the other vendors + Excel,  Oracle Data Browser (especially since you have SQL*Net running),  DataEdit from Brio,
 GQL from Andyne, etc.

Paul Dorsey will post a summary from his ad-hoc query tool shoot-out soon. This will include several products available for the Mac.

You might also send mail to Liam Breck <breck_at_external.umass.edu> and ask for his Mac Client/Server Database Summary.

Mike Kranzdorf                   mikek_at_krt.com