PHP a výběr dat z MS SQL 2005

[pajkus]

if you get a "Unicode data in Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier" error you can use this kind of code (in an MS environment, of course):
<?
$db = new COM("ADODB.Connection");
$dsn = "DRIVER={SQL Server}; SERVER={SERVER};UID={USER};PWD={PASS}; DATABASE={DB}";
$db->Open($dsn);
$rs = $db->Execute("SELECT * FROM table");

while (!$rs->EOF)
{
   echo $rs->Fields['column']->Value."<BR>";
   $rs->MoveNext();
}
?>

nebo zkus vymenit ntwdblib.dll vice zde