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] -~----------~----~----~----~------~----~------~--~---
