Hi, I've used mssql extension on Windows as well a number of times, it works fine, but I found a couple of annoying gotchas over time - always seems to pool your connections, no matter what - Can't use blob > 406 bytes, but can use text. I have a site where I base64encode blob data because of this - Can't sort by any multibyte column (nvarchar etc), hence need to cast it all the time. - can't get the fractions of a second from a datetime, hence need to cast it to string
I know no way to "link" it with MySQL, I've always needed instant access to the data, not synchronised data. Let us know if you have any specific problems. Jochen 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] -~----------~----~----~----~------~----~------~--~---
