Can you try hand-jobbing the DSN as a test, format should be something like:

$dsn = "Provider=MSDASQL;Driver={SQL Server};Server=myServerName; Database=myDatabaseName;Uid=myUsername;Pwd=myPassword"

Something like that - your mileage will vary.

-Shawn