access to MSSQL?

[Jonathan Stowe]

On Mon, 2008-04-07 at 11:43 +0300, Michael wrote:
> Anyone having an experience in fixing a program to be working in a linux
> platform and to be retrieving data from MSSQL at windows PC?

Yes. There are several ways:

  a) use DBD::ODBC (with either the unixodbc or iOdbc libraries) with
the FreeTDS drivers.

  b) use DBD::Sybase with either FreeTDS or Sybase libraries

  c) use DBD::Proxy with a proxy service running on the Windows machine
to do the real connection.

  d) for retrieval only, configure the XML SQL service on the Windows
server and do the queries over HTTP


You probably want to ask in a more "help oriented" forum if you want
more detail on any of the above.

/J\