ADOdb help

[cbrknight]

I have to connect to a mssql 2000 database

I have never used mssql before...

I downloaded and installed ADOdb package

I used the following connection string

$conn =& ADONewConnection('mssql');
$conn->Execute('servername','username','password');
if(!$conn)
die("Connection Failed");
else
print("Connection Good");
$sql = ('SELECT * FROM deals');

output:
Connection Good

I have tried several ways to get output from the table. Can anyone tell me how to get some kind of output from the table to be sure i am connecting properly to the database?

[tomhath]

Do you need to select a database?

Did you actually run what's in variable $sql?