[solved]Setting php+apache on kubuntu to be friendly with mssql server ?

[Gediminas2]

We have a MSSQL 2000 (MSDE) server running on one windows machine(Access via LAN). It is used by an archaic accounting program (with huge limitations).

I need to get a portion of data from that database, but my attempts to set it up were unsuccessful (installed apache2 + php5 + php5_sybase[or something like that])...

Does anyone of you had experience with such things?

P.S. Don't offer setting up MySQL, unless you know a way to copy the database from MSSQL.

Thank you in advance

EDIT: After some unsuccessful attempt with, I remembered that M$ has it's own server-side web solution called asp. So after 6 hours of installation, 5 computer restart and two evenings of web search it works. Sort of.

[doctordruidphd]

Re: Setting php+apache on kubuntu to be friendly with mssql server ?

I have not done this, but here is a link from people who apparently have:

http://php.net/manual/en/function.mssql-connect.php

suggests several different ways of doing it.

P.S. Don't offer setting up MySQL, unless you know a way to copy the database from MSSQL.

I would NEVER do that, but I might suggest:

http://wiki.postgresql.org/wiki/Micr...xtension_Links

At least for the part of the data you need to access.

Hope these are of some help.