Windows server, install the SQL Server Client tools and use the mssql extension.
Or odbc. M On Mon, Jan 19, 2009 at 8:09 PM, Jai Ivarsson <[email protected]> wrote: > > This is going most likely be a windows server, so makes freetds out of > the question unfortunately. > > Thanks for the responses. > > Thanks, > > Jai Ivarsson > > > On 19/01/2009, at 7:22 PM, Stig Manning wrote: > > > > > Hi Jai, > > > > I have experience doing this in linux, with freetds libraries ( allows > > PHP to access MSSQL server) and enables the mssql functions in PHP. > > Use them just as you would the MySQL functions... > > > > I would recommend using MySQL to store a copy of the data, and do a > > sync > > periodically (with a PHP cron job) between the two. > > > > Cheers, > > Stig > > > > Jai Ivarsson wrote: > >> Hey, does anyone have any experience calling data from SQL Server? I > >> have a PHP/MySQL web app that needs to pull some information from a > >> few table in mssql and store info in the MySql tables that refer to > >> id's in the mssql tables. > >> > >> Has anyone got any ideas on the best way to tackle this? Perhaps it > >> could be nice and easy and have MySql create a views of the mssql > >> tables? > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
