|
|
|
|
|
| | |
| |
Active Server Pages asp search engine active server page asp application components tutorial 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
