|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: SYSTEM DSN and ASP |
|
From: |
Pete |
|
Date: |
2/22/1999 7:24:23 AM |
|
IP: |
193.133.140.50 |
I use the ODBC to connect to my DB's so this is how my code would look :
Set DataConn = Server.CreateObject("ADODB.Connection")
Set AccidentRS = Server.CreateObject("ADODB.Recordset")
'Open DB
DataConn.Open "DSN=security"
'get data from send.asp form
Username = Request("Username")
Password = Request("Password")
SQL = "SELECT * FROM users where username = user and password = pass "
'Submit SQL statement
LoginRS.Open SQL, DataConn
If LoginRS.BOF and LoginRS.EOF Then
...
To stop users downloading your database, just store it off your webserver, either in a directory higher then the webservers, another drive or server on a network. Just change your ODBC entry to point to the databases new location.
Pete |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
