|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
SYSTEM DSN and ASP |
|
From: |
Rich |
|
Date: |
2/22/1999 3:35:57 AM |
|
IP: |
205.163.7.57 |
Help. New to ASP and can't figure out how to substitute the following code to secure my Access database (logins.mdb) utilizing a System DSN instead of .mdb. It works just like it is, however the database is not secure. How do I reference the SystemDSN I created called "security" I don't want people to download the .mdb file from the server and retrieve the ID's and passwords. Any help would be appreciated.
Here's the code:
dbname="logins.mdb"
myname=request.form("username")
mypassword=request.form("userpassword")
set conntemp=server.createobject("adodb.connection")
cnpath="DBQ=" & server.mappath(dbname)
conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath
sqltemp="select * from users where user='"
sqltemp=sqltemp & myname & "'"
set rstemp=conntemp.execute(SQLTemp)
If rstemp.eof then%>
Thanks in advance for your assistance.
Regards,
Rich |
Follow Up - Re: SYSTEM DSN and ASP - Pete 2/22/1999 7:24:23 AM
Follow Up - Re: SYSTEM DSN and ASP - Chris Williams 2/22/1999 9:18:38 AM
Follow Up - Re: SYSTEM DSN and ASP - Rich 2/22/1999 1:42:07 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
