Accessing MSDE from Unix and OS X

--Apple-Mail-6--827868926
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
delsp=yes;
format=flowed

Hi, I'm new in this list...
I'm looking for the simplest way to read data stored in MSDE tables
from Perl scripts running on Unix Tru64 (production machine) and -
possibly- OS X (development machine). Any idea?
DBIx::MSSQLReporter seems to be a good candidate, but its
installation requires DBD::ADO, which is only for Win32 machines.
TIA. Stefano
--
Dott. Stefano Bargioni
Pontificia Universita' della Santa Croce - Roma
Vicedirettore della Biblioteca
--Apple-Mail-6--827868926--

Re: Accessing MSDE from Unix and OS X

Hello

The easiest would be to run DBI::Proxy on the windows box. The
ActiveState perl for windows includes a .bat file for starting in daemon
mode.

Next option is a ODBC connection from the Unix box using DBD::Sybase and
FreeTDS.

Peter

> Hi, I'm new in this list...
> I'm looking for the simplest way to read data stored in MSDE tables
> from Perl scripts running on Unix Tru64 (production machine) and -
> possibly- OS X (development machine). Any idea?
> DBIx::MSSQLReporter seems to be a good candidate, but its
> installation requires DBD::ADO, which is only for Win32 machines.
> TIA. Stefano
> --
> Dott. Stefano Bargioni
> Pontificia Universita' della Santa Croce - Roma
> Vicedirettore della Biblioteca

Re: Accessing MSDE from Unix and OS X

Hi Steffano

> DBIx::MSSQLReporter seems to be a good candidate, but its
> installation requires DBD::ADO, which is only for Win32 machines.

Besides Peter's suggestion to run DBI::Proxy, or ODBC, note that my module
(DBIx::MSSQLReporter) simply reports information about your schema, using
an MS-specific interface. It would be useless helping you with Unix
connectivity.

However, you are to be commended for searching CPAN to even find such a
module. Well done!

--
Ron Savage
ron@savage.net.au
http://savage.net.au/index.html