I never used DBCommand() but the code below using DBConnOpen(), DBGetRecordset() and DBConnClose() work fine for me

 Code:
$open = DBConnOpen("DRIVER={SQL Server};SERVER=SQLSERVERNAME;UID=USERNAME;PWD=PASSWORD;DATABASE=DATABASENAME")
$query = "SELECT Value FROM dbo.ListOptions where Type = 'Carrier' Order by Value"
$recordset = DBGetRecordset($open, $query)
$close = DBConnClose($open)


Do you get the same results with these functions?

Edited by Mart (2012-05-11 08:56 PM)
Edit Reason: Typo.
_________________________
Mart

- Chuck Norris once sold ebay to ebay on ebay.