[ale] Linux connecting to MS SQL

[Christopher Fowler]

On Mon, Sep 13, 2004 at 06:01:03PM -0500, Jeb Barger wrote:
> 
> 
> 
> I am converting a webapp to Mandrake 10 using php, however, it still 
> needs to connect to the microsoft sql server.  Is there an easy way to 
> do this?  Articles I have read, suggest using a piece that converts the 
> odbc connection to xml, and using php to connect that way.  I am new to 
> linux, and I know there has to be a better way.  Any suggestions?
> 


That is one way.  If PHP does not have a MS SQL driver then you need to find
something that does.  Maybe Perl's DBI does?  If so you have 2 approaches.

1.  Create a server written in perl that does the following:

XML -> perl -> ODBC
ODBC -> perl -> XML

2.  Create an engine program that simply grabs stuff based on command
line arguments and spits out an XML conversion.