jscript will not connect to database

Basically I am just trying to check if a client exists in a database table. I found that I was able to get it to connect succesfully usng DSN connection, but I do not want to have to use that.



function checkDatabase(client) {

var connectionString = "Data Source=<sql server>; Provider=SQLOLEDB; uid=<username>; pwd=<password>; database=<databasename>";

var dbconn = new ActiveXObject("ADODB.Connection");

try {

dbconn.Open(connectionString);

var queryStr = "SELECT ClientName FROM Clients WHERE ClientName = "+client;

var results = dbconn.Execute(queryStr);

}

finally {

dbconn.Close;

}

return results;

}