Database Access
- From: "EvanK" <EvanK@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 2 Jun 2005 13:42:07 -0700
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) ;
.
- Follow-Ups:
- Re: Database Access
- From: Bob Barrows [MVP]
- Re: Database Access
- From: Fabrice Canel [MSFT]
- Re: Database Access
- Prev by Date: Re: Sending an SMTP Email
- Next by Date: Re: Sending an SMTP Email
- Previous by thread: Re: How to hide script code from user?
- Next by thread: Re: Database Access
- Index(es):