DB Design

 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me



Go Back   Tutorialized ForumsDatabasesDB Design

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old July 31st, 2005, 04:18 AM
Zoe-Alyssa Zoe-Alyssa is offline
Contributing User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Jul 2005
Posts: 2 Zoe-Alyssa New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: < 1 sec
Reputation Power: 0
Database password in an external file !!!

Hello,

I would like to know something about placing a password for a database in an external file, something like a global.asa file or a included file.

I'm using an access database and ASP.

So my question is how do I make this file and how do I attach it to my website. I thought this might be useful for extra database security, is this true?

The database is located in a folder that is protected by the hosting provider and you can only download the database using a login name and password and you can change data trough webpages (update, delete and insert).

This has all about database security, I want to make my database as secure as possible, I'm already using SSL certificates. I don't know much about this security so some help could be useful.

I hope someone can help me out here.
Thanks
Zoe-Alyssa

Reply With Quote
  #2  
Old August 2nd, 2005, 03:58 PM
dekron dekron is offline
Contributing User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Aug 2005
Posts: 1 dekron New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: < 1 sec
Reputation Power: 0
If you are using ASP with VBScript you can use code similar to this. Type in the adovbs.inc in google to download the info. This is needed for mdbs.




<% Dim oConn, oRS, oCmd, strConnectionString, strDriver %>
<% strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("databasename.mdb") & ";Jet OLEDBatabase Password=yourdbpassword;"
Set oConn = Server.CreateObject("ADODB.Connection")
Set oRS = Server.CreateObject("ADODB.Recordset")
Set oCmd = Server.CreateObject("ADODB.Command")
%>

Then name this file something like connection.inc. Here is a sample of what it would look like:

<@% Language=VBScript %>
<%Option Explicit %> ' for making sure variables are defined

<%
your code here
%>
<html>
<head>
<title>My Database Page</title>
</head>
<body>

</body>
</html>

Very basic, but hope it helps.

Reply With Quote
Reply

Viewing: Tutorialized ForumsDatabasesDB Design > Database password in an external file !!!


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap