Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old February 1st, 2004, 04:04 PM
Quest Quest is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2004
Posts: 6 Quest User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
password protected area

I need help with a small project. I am designing a site formyself amd my alumni where old class mates can log into a members area.

How can i do this with access and asp or jsp?

thanks

quest

Reply With Quote
  #2  
Old February 2nd, 2004, 02:09 AM
stumpy's Avatar
stumpy stumpy is offline
May contain nuts.
Dev Articles Regular (2000 - 2499 posts)
 
Join Date: Aug 2002
Location: Sydney, AU
Posts: 2,058 stumpy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 8 m 57 sec
Reputation Power: 9
Send a message via ICQ to stumpy Send a message via MSN to stumpy
You can do this with ASP, running on a IIS. There are a few articles about it on this very site. Have a quick search...Here's what I found:
http://www.devarticles.com/c/a/ASP/...ervices-in-ASP/
http://www.devarticles.com/c/a/ASP/...-area-with-ASP/
__________________
DevArticles Moderator
BlueSix - Web Development and Consulting

Reply With Quote
  #3  
Old February 2nd, 2004, 04:55 PM
Quest Quest is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2004
Posts: 6 Quest User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thanks man!

I do appreciate you....thanks for the help..am digesting the stuff now....am not familiar with sql ,so i have to take a good look at it now.

i have a question on the code available on creating a database, do i have to create those fields myself? or does it do it itself?

tx.
Quote:
Originally Posted by stumpy
You can do this with ASP, running on a IIS. There are a few articles about it on this very site. Have a quick search...Here's what I found:
http://www.devarticles.com/c/a/ASP/...ervices-in-ASP/
http://www.devarticles.com/c/a/ASP/...-area-with-ASP/

Reply With Quote
  #4  
Old February 2nd, 2004, 05:28 PM
stumpy's Avatar
stumpy stumpy is offline
May contain nuts.
Dev Articles Regular (2000 - 2499 posts)
 
Join Date: Aug 2002
Location: Sydney, AU
Posts: 2,058 stumpy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 8 m 57 sec
Reputation Power: 9
Send a message via ICQ to stumpy Send a message via MSN to stumpy
Creating the DB isn't too hard - have a stab at it (i think they run through it in the articles? can't remember)... I'll give you a hand if u need one

Reply With Quote
  #5  
Old February 5th, 2004, 05:14 PM
Quest Quest is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2004
Posts: 6 Quest User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Hmmnnn..I need all the help i can get.I do appreciate your help.

Thanks

Quote:
Originally Posted by stumpy
Creating the DB isn't too hard - have a stab at it (i think they run through it in the articles? can't remember)... I'll give you a hand if u need one

Reply With Quote
  #6  
Old February 5th, 2004, 06:16 PM
stumpy's Avatar
stumpy stumpy is offline
May contain nuts.
Dev Articles Regular (2000 - 2499 posts)
 
Join Date: Aug 2002
Location: Sydney, AU
Posts: 2,058 stumpy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 8 m 57 sec
Reputation Power: 9
Send a message via ICQ to stumpy Send a message via MSN to stumpy
Since your using Access for your DB, it'll makes things much easier. It has wizards, and GUI's, you won't need to know much SQL. You can create the queries in Access then just call the name of that query in your ASP. But I can't do it all for you.

Reply With Quote
  #7  
Old February 9th, 2004, 12:30 PM
Quest Quest is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2004
Posts: 6 Quest User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Txtumpy, you've been of great help. will do that and let u know if i have any probs.

How can i prevent vistors from downloading my media file from my site?

I stream church sermons from my web and dont want visitors to download these files.

Tx
Quote:
Originally Posted by stumpy
Since your using Access for your DB, it'll makes things much easier. It has wizards, and GUI's, you won't need to know much SQL. You can create the queries in Access then just call the name of that query in your ASP. But I can't do it all for you.

Reply With Quote
  #8  
Old February 9th, 2004, 04:54 PM
stumpy's Avatar
stumpy stumpy is offline
May contain nuts.
Dev Articles Regular (2000 - 2499 posts)
 
Join Date: Aug 2002
Location: Sydney, AU
Posts: 2,058 stumpy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 8 m 57 sec
Reputation Power: 9
Send a message via ICQ to stumpy Send a message via MSN to stumpy
Protecting media is a little tricky. You place the media in a non-web user accessible area, which the ASP script can access, then stream that binary data to the users browser, rather than linking directly to the media file. Here's the code:
Code:
Response.Buffer = False
'--- Check that the user is a member

'---Create a stream object 
Dim objStream
Set objStream = Server.CreateObject("ADODB.Stream") 

objStream.Type = adTypeBinary 
objStream.Open 
objStream.LoadFromFile(your physical file location here)

'Output the contents of the stream object 
Response.ContentType = strContentType
Response.AddHeader "Content-Disposition", "inline; filename=" & he file name here
Response.AddHeader "Content-Size", objStream.Size
Response.BinaryWrite objStream.Read

'Clean up.... 
objStream.Close
Set objStream = Nothing

Reply With Quote
  #9  
Old February 16th, 2004, 06:25 AM
Quest Quest is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2004
Posts: 6 Quest User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Chmod

Hi Pal,

how do i chmod a file? I need to set some parameters for a file before i can read and write to it on my server.


Quote:
Originally Posted by stumpy
Protecting media is a little tricky. You place the media in a non-web user accessible area, which the ASP script can access, then stream that binary data to the users browser, rather than linking directly to the media file. Here's the code:
Code:
Response.Buffer = False
'--- Check that the user is a member

'---Create a stream object 
Dim objStream
Set objStream = Server.CreateObject("ADODB.Stream") 

objStream.Type = adTypeBinary 
objStream.Open 
objStream.LoadFromFile(your physical file location here)

'Output the contents of the stream object 
Response.ContentType = strContentType
Response.AddHeader "Content-Disposition", "inline; filename=" & he file name here
Response.AddHeader "Content-Size", objStream.Size
Response.BinaryWrite objStream.Read

'Clean up.... 
objStream.Close
Set objStream = Nothing

Reply With Quote
  #10  
Old March 4th, 2004, 12:54 AM
Quest Quest is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2004
Posts: 6 Quest User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
buffering....loading...

Pls can anyone see to my problem with my videofile buffering and wasting precious time! Can i possibly preload the video files so that it comes up as soon as it is needed?

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > password protected area


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 | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway
Stay green...Green IT