[UPHPU] Help with Database Connection

[Mike Mackrory]

Thanks Dave!

Good advice.  I have pretty much zero control over either server.  I do
however have a .Net hosting account that can hit both SQL Server and MySQL.
I think I may end up building some kind of loading functionality in here to
pull and then push the data - Not elegant, but I don't think it will take
much to setup, and sounds impressive when it turns out to be a PHP app with
AJAX, and an ASP loading function - probably a bunch of other acronyms I
could throw in there as well.

Mike

-----Original Message-----
From: David Boucha [mailto:boucha at gmail.com] 
Sent: Tuesday, April 03, 2007 11:49 PM
To: mike at echovue.com
Cc: uphpu at uphpu.org
Subject: Re: [UPHPU] Help with Database Connection

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