kieranbarnes these are the things i learnt today

[Snippet] Installation of MS SQL Libraries on Ubuntu

Posted on February 9, 2010

Can't find php-mssql? Nah, its gone. Use php-sybase which contains both libraries now. Remember, make sure FreeTDS is installed aswell.

Filed under: Linux, MS SQL No Comments

FreeTDS installation directory is not a FreeTDS installation directory

Posted on December 3, 2009

I recently discovered an error whilst trying to (re)install an older PHP version on a client's server. My client required PHP recompiling with MS SQL support. This in turn requires FreeTDS. Installing FreeTDS is very simple, but PHP wasn't.

Filed under: Linux, MS SQL, PHP Continue reading

Upgrading from SQL 2000 to 2005 Error -1

Posted on November 25, 2009

Ever had your Upgrade Advisor return an error while upgrading an instance of SQL Server 2000 to SQL Server 2005?

UpgradeAdvisor returned  -1 .

I have, in two different circumstances,

  • While choosing an instance from the installed instances and choosing one of them to upgrade.
  • While running upgrade advisor exclusively.