Database Access

Tech-Archive recommends: Fix windows errors by optimizing your registry



I am trying to connect to a SQL database from a client script to validate a
user login and password. I don't want to embed a username and password in
the script and I also don't want to use an ODBC data source because I don't
want to need to create it on individual workstations. I used the code below
for the connection but to no avail. I also get the error message that tells
me that there is no datasource found and no default driver specified.

var oCN = new ActiveXObject("ADODB.Connection") ;
var oRS = new ActiveXObject("ADODB.Recordset") ;

oCN.open ("Server=MyServer;Database=MyDB;User=Me;Pwd=MyPwd'") ;
oRS.open ("Select * from MyTable",oCN) ;

.