I thought sendspace just let you download it from the link. Anyways... i'm new to doing some of this stuff ...The SQL server that is on a windows server 2003 OS... is using Mixed authentication. It was easy to connect when it was 2 computers both using windows.
Now that i'm using ubuntu server to connect to server 2003... I'm having to manually enter in on the ubuntu side lots of values and specifying the location of drivers inside several different config files. I was specifically dealing with ODBC and freetds.
I found an alternative to using mssql connect function for php/apache, and it was something called PDO. I used these two links to get started on using PDO to connect to our companies mssql db.
https://secure.kitserve.org.uk/conte...bc-and-freetds
http://net.tutsplus.com/tutorials/ph...tabase-access/
I still wouldn't mind learning to create a connection using mssql_connect(), but because of pressure from the company to get it done ASAP i used PDO. Which seems to work just fine... HOWEVER... i realized if i had some really heavy SQL queries with lots of joins... it would freak out(they were valid queries because they would return records in SQL EXPRESS). The way I got around that was doing several small queries and opening and closing connections with all kinds of different arrays storing the values and it looks messy and was a pain. It was ugly but it got the job done.
Anyways... if you have any good resources on setting up a linux apache web server connecting to a mssql db i would certainly take a look at it and try it out. I already feel like a scoured the internet looking for good resources on it. I really feel like I was close but because i'm novice in dealing with linux I was doing something wrong in the config files that wasn't allowing everything to work properly.