[UPHPU] Help with Database Connection

[David Boucha]

On 4/3/07, Mike Mackrory <mike at echovue.com> wrote:
> Hi Everyone,

> I'm working on a site for a realtor, hosted in a shared Linux environment
> with MySQL as the backed database. It all works as it should, except that I
> need to be able to create a connection to a SQL Server database that holds
> all of the MLS Data. The problem is that the hosting service has not
> installed any of the libraries etc. to allow me to set up that connection -
> mssql_query and that kind of thing.
>
> Does any one know of a way whereby I can establish a connection without this
> library? All I need to be able to do is get a return from a couple of SELECT
> queries.

Mike, it is a pain in the behind to connect to a  Microsoft SQL Server
from a Linux machine. You have to install the FreeTDS library and
configure some stuff to get it to work. I'd say it's not going to
happen on a shared Linux host. I got it working on my own Linux
server, but it wasn't the easiest thing to do.

I'd recommend following Ray's advice and try to have the data pushed
out to your server. It's much easier to install the MyODBC drivers on
your Microsoft SQL server and have a DTS package push out the data to
your MySQL database. We're doing that right now and it works pretty
well.

Good luck!

Dave Boucha