|
| 
| Submitted on: 3/18/2001 8:19:51 PM
By: Daniel Barnes
Level: Intermediate
User Rating:
By 38 Users
Compatibility:ASP (Active Server Pages), HTML, VbScript (browser/client side)
Users have accessed this code 45059 times.
|
(About the author) |
| | | This code runs a FREE, fully functional intranet/internet database application complete with chat, message boards, email, contacts lists, project management, monthly planner with full administration capabilities on any standards-compliant browser including Opera, IE4+, and NN4+.
This is my first ASP project.
The current zip file has taken care of every problem I've heard about and includes an Access97 version of the database.
| |
|
| |
|
Download code
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzipto decompress it.
Virus note:All files are scanned once-a-day by Planet Source Code for viruses,but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1)Re-scan downloaded files using your personal virus checker before using it.
2)NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com
|
Terms of Agreement:
By using this code, you agree to the following terms...
1) You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description. |
| |
| Report Bad Submission |
|
| |
| Your Vote! |
|
See Voting Log |
| |
| Other User Comments |
3/21/2001 3:41:11 PM:xao
Try editing "connections.inc" change
line 12 to objConn.Open
"DSN=dbPostOutlook" and make an ODBC
System DNS entry "dbPostOutlook"
pointing to the database (.mdb).
|
3/22/2001 4:27:19 PM:Daniel Barnes
<b>FIX for database and DSN
errors:</b><br>
Most people have found
that taking out the DSN=<i>blah</i>
substring from the connection string
has fixed all their problems, and I'll
just add here what Xao said fixed his
problems:
Try editing
|
3/26/2001 5:48:52 PM:Daniel Barnes
I've emailed everyone who requested
Access97 format, and I've added
outlook97.mdb to the zip file, as well
as adding the entire JMail install
file, just in case people would like
example files and documentation for the
JMail components.
|
4/3/2001 1:30:02 PM:Tianna
This application is excellent so far
(aside from a few minor issues
w/installation)...the one thing it
doesn't appear to do is let you add
contacts that aren't employees...an
"address book" functionality is
necessary for any intranet! It's what
I came here looking for...
|
4/4/2001 1:24:52 PM:Ian Ippolito
Daniel,
The reason so many people
are having problems with the .dll is
that Planet Source Code removes them
from your submission (due to too many
people uploading viruses). If you
email me the complete .zip file at
webmaster@planet-source-code.com, I'll
post it up with all of the files
intact.
Ian
PSC Admin
|
4/5/2001 2:07:24 AM:sam
Can you include a document that
explains fully about the installation
process (apart from the todo.txt file
which looks like a last minute changes
file)?
keep up the good work. I got
all the dll's and full version.
|
4/10/2001 3:05:02 AM:Sam Moses
Pretty impressive stuff. Congrats on
the award.
|
5/5/2001 3:55:12 PM:anon
Nice Job !
You might want to
consider a name change
though...
Outlook is trademarked by
M$ which means you cannot use any form
of the word...
Just thought I would
pass that along...
|
5/9/2001 4:51:36 PM:Richard
Did anybody ever compile a complete
installation guide. I'm new to ASP and
I can't it to run on my server past the
login screen. How do I get the JMail
portion.
|
5/17/2001 3:51:38 PM:Mike Falcon
Impressive stuff. Saved me days of
coding! Thanks a lot Daniel and keep up
the excellent work!
|
5/22/2001 11:16:11 AM:MQ
I downloaded your ZIP file and tried to
install it and having a whale of a time
trying to install it. Cant get past the
logon screen. Is there better
documentation on how to install this.
|
5/22/2001 5:46:14 PM:Daniel Barnes
If you ever written or installed an ASP
application, this should be no
different. Just change the connection
string so that it doesn't have the DSN=
line and points to wherever you put the
fups.mdb file. If that doesn't work,
email me with more information on the
specific error messages.
|
5/25/2001 8:10:02 PM:Jay
This is the error I recieve I tried the
few sugestion above please help
thanks
Error Type:
Microsoft OLE DB
Provider for ODBC Drivers
(0x80004005)
[Microsoft][ODBC Driver
Manager] Driver's SQLSetConnectAttr
failed
/connections.inc, line 12
|
5/26/2001 4:35:16 AM:Daniel Barnes
All right, this seems like a very
specific problem with your particular
ODBC configuration. Back to
defaults:
objConn.Open "DSN=MS Access
Database;DRIVER=(Microsoft Access
Driver (*.mdb));DBQ=C:\fups.mdb"
Check
your ODBC Data Sources to make sure
that "MS Access Database" exists under
the User DSN tab. If it doesn't, add
it. The DRIVER= statement should also
correspond to the driver given for that
data source. If that doesn't help, I
don't know what to tell you.
|
6/6/2001 10:09:24 AM:Bart
It seems like this is a really common
problem with this script. i have
created teh User and System DSN. I
have pointed it to the proper database.
i still get this error.
Error
Type:
Microsoft OLE DB Provider for
ODBC Drivers
(0x80004005)
[Microsoft][ODBC Driver
Manager] Data source name not found and
no default driver
specified
/Outlook/connections.inc,
line 12
|
6/6/2001 3:52:31 PM:Daniel Barnes
It's not common, but it is the only
error I hear of. Out of the 8000
people who've downloaded the code, only
10 or so have had this error; that's a
pretty good record. All I can suggest
is delete the System DSN from
connections.inc and ODBC and make sure
the names of your User DSN and Driver
match the names in
connections.inc
If all else fails,
just change the connection string to
one you KNOW works with ASP, something
you've used before!
|
6/8/2001 6:27:29 AM:JohnO
Seems to be mostly working (or least as
much as I can on my intranet).
I
would like to make the calendar
|
6/8/2001 6:29:28 AM:JohnO
Last post didn't seem to work....
I
would like to have a public calendar so
that everyone can see what my group is
up to but only members of the group can
edit it.
Any easy way to do this?
|
6/9/2001 8:38:27 PM:Daniel Barnes
I d/l a zip file for using Exchange to
create a public calendar for a project
I was working on. It's pretty crude,
but it's fully coded and has great
explanation pages. I'll email it to
you.
|
6/17/2001 8:30:22 AM:Ayman
I downloaded the ZIP file, but JMail
installer was not in it.
Can you
kindly advise where it maybe
found?
Thanks.
|
6/18/2001 12:01:33 AM:impressed
Hell, I haven't even downloaded it yet
but it looks freaking awesome! I'll be
back for the code once I get my server
up and running. Rock on!
|
6/18/2001 2:05:57 AM:Daniel Barnes
Sometimes the .dll files are stripped
from the .zip when uploaded. Try
http://www.dimac.net for the JMail.dll
file and example source code for your
future email endeavors.
|
7/11/2001 4:21:58 PM:budeen@bluehyppo.com
i can't send mail correctly. error
message display...please help me
|
7/12/2001 11:38:03 AM:Kristopher E.J.
Hrmm, I'm getting the Driver's
SQLSetConnectAttr failed
error:
Microsoft OLE DB Provider for
ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager]
Driver's SQLSetConnectAttr failed
/outlook/connections.inc, line 12
The only ideas I have heard is
that it may be something to do with the
adodb.connection But unfortunatly I
havn't had enough experience with
databases :( The program looks
awesome, hope I can get it to work!
|
7/13/2001 11:22:15 PM:Daniel Barnes
About the email problem. If you didn't
get the jmail.dll file or the w3JMail
install file, go to
http://www.dimac.net and download
w3JMail. Install it, register it using
regsvr32
|
7/13/2001 11:23:23 PM:Daniel Barnes
<cut off>
and try again. About the
connection strings: go to
http://www.able-consulting.com/ADO_Conn.
htm for excellent examples of
connection strings.
Hope that helps.
|
8/14/2001 10:29:21 AM:Eliza
It's a very good program, but i have
this problem here.
I can view my
messages in the inbox, but when i click
|
9/6/2001 12:21:35 PM:Spyros
I cannot find JMail installer mentioned
in the ToDo txt file. What can I do to
get it?
|
9/6/2001 12:22:47 PM:Spyros
I cannot find the JMail installer
mentioned in the ToDo txt file. What
should I do?
|
9/6/2001 4:19:32 PM:Roberto
Error Type:
Microsoft OLE DB Provider
for ODBC Drivers
(0x80040E14)
[Microsoft][ODBC
Microsoft Access Driver] Syntax error
(missing operator) in query expression
'UserID='.
/main.asp, line
13
Everything was done correctly in
terms of installation, and user's
registration goes through
Any
suggestions?
and, yeah, did i
mention
GREAT JOB!!!
|
9/7/2001 6:19:15 PM:Daniel Barnes
Go to http://www.dimac.net to get the
newest version of Jmail.
|
9/7/2001 6:20:16 PM:Daniel Barnes
Roberto,
sometimes the session expires
and the Session("UserID") variable is
set to an empty string. This could
account for the error.
And thanks for
the compliment!
|
9/13/2001 11:54:47 AM:Pooh
I used objConn.Open "Driver={Microsoft
Access Driver
(*.mdb)};Dbq=c:\fups.mdb;Uid=Admin;Pwd=;
" to get it to work appropriately on my
Windows 2000 Server system..
I hate
DSNs 8*)
|
9/20/2001 8:11:59 PM:Bart
I have gotten everything to work but
the email. this is my
error.
jmail.POP3
(0x8000FFFF)
POP3: -ERR Permission
denied
/outlook/bin/inbox_headers.asp, line
36
I have Jmail w3Jmail4 Personal
installed and registered. What am i
doing wrong? Can anyone help? THanks
|
9/23/2001 1:55:01 PM:Daniel Barnes
You're using an incorrect
username/password with the POP3 server
you specified.
|
9/23/2001 4:41:46 PM:Ryan
I get errors with registering on a
windows 2000 advanced server edition
using objConn.Open
|
9/23/2001 5:03:29 PM:Ryan
Error Type:
Microsoft OLE DB Provider
for ODBC Drivers
(0x80040E14)
[Microsoft][ODBC
Microsoft Access Driver] Syntax error
(missing operator) in query expression
''O'Keeffe','','','','','','','')'.
/ou
tlook/register.asp, line 111
|
9/23/2001 5:05:13 PM:Ryan
e-mail me @ xtremesupport@aol.com
|
9/23/2001 5:09:02 PM:Ryan
<cut off 2 messages up>
when using
objConn.Open "Driver={Microsoft
Access Driver
(*.mdb)};Dbq=c:\fups.mdb;Uid=Admin;Pwd
=;"
|
9/25/2001 12:44:19 AM:Daniel Barnes
The reason you're getting the syntax
error is because O'Keefe has an
apostrophe in it, which causes the
server some problems trying to figure
out where the strings start and
stop.
Try using the " symbol (i.e.,
SHIFT + apostrophe) to bound your
strings.
|
10/19/2001 3:32:51 AM:Kool Pal
Is there any documentation apart from
the todo.txt for this code?? I would
appreciate a response from anybody!!
|
10/25/2001 9:43:07 AM:Blade1413
All I can say is WOW. How long did this
thing take you to make? just curious.
GREAT PROGRAM. Very amazing. Good Job!
|
11/16/2001 3:11:58 AM:Segun
I am quite new to VBscript, this is the
error i got after the logon
screen:
Active Server Pages error
'ASP 0137'
Invalid Global Script
/intranet3/outlook/global.asa, line
83
Script blocks must be one of the
allowed Global.asa procedures. Script
directives within <% ... %> are not
allowed within the global.asa file. The
allowed procedure names are
Application_OnStart, Application_OnEnd,
Session_OnStart, or Session_OnEnd.
|
11/26/2001 2:54:38 PM:palle
I get errors with registering
please
help
thanks
Microsoft OLE DB
Provider for ODBC Drivers
(0x80004005)
[Microsoft][ODBC
Microsoft Access Driver] Operation must
use an updateable
query.
/Outlook/register.asp, line
111
|
12/24/2001 4:44:10 AM:Brad
This code looks great!
I just wish I
could be clued in on this
error...
Error Type:
Microsoft
OLE DB Provider for ODBC Drivers
(0x80004005)
[Microsoft][ODBC
Microsoft Access Driver] Operation must
use an updateable
query.
/outlook/register.asp, line
111
Please help I really want to
see this thing work.
|
1/4/2002 11:59:28 PM:Gökhan
i wont tell you these lame things :)
'cos there is nothing wrong with the
code. First, Congratulations. Second,
an advice, if you dont want to write an
chat script, there are many out there,
use one instead of this java one.
because maybe some intranet users dont
have an internet access, that makes
them not reach anyone to chat... See
what i mean. The rest is really cool.
And a last thing, you should improve
your html coding :))) Thanx for sharing
this awesome project with us.
|
3/8/2002 8:40:22 PM:maria
hey daniel
this application is real
neat i wud like to have a full version
of it i mean the .dll's and
installation guide offcourse
keep up
the good work:P
|
3/14/2002 12:19:26 AM:doctor
Hey...this is grt stuff....keep the
good work going.....and ya u too look
grt. Thanx.
|
4/9/2002 12:31:01 AM:Sekhar
Dear Mr.Darne,
This application
is very gooooood. But why don't you
help me out to get that jmail
installer. I couldn't find a place on
dimac.net for downloading the same.
When I tried to download there's no
response in the site. Please let me
have that.....
Regards,
Sekhar
|
5/20/2002 12:05:16 PM:Yogi
I am quite new to VBscript, this is the
error i got after the logon
screen:
Active Server Pages error
'ASP 0137'
Invalid Global Script
/intranet3/outlook/global.asa,
line
83
Script blocks must be one
of the
allowed Global.asa procedures.
Script
directives within <% ... %>
are not
allowed within the global.asa
file. The
allowed procedure names are
Application_OnStart,
Application_OnEnd,
Session_OnStart,
or Session_OnEnd.
|
6/6/2002 12:32:33 PM:Jody
I setup the files, and made the
configuration changes you mention in
todo.txt. When I try to log in, I get a
page not found error. Any ideas?
|
6/7/2002 11:30:07 PM:Gary T
is there a main
Admin page of your
program Good hob so far i just cant get
the inbox page viewable it give me a
error The page cannot be displayed
There is a problem with the page you
are trying to reach and it cannot be
displayed.
|
6/24/2002 3:13:04 PM:SNOWDAZE
Any idea why I am getting this
error???
Error Type:
Microsoft OLE
DB Provider for ODBC Drivers
(0x80004005)
[Microsoft][ODBC Driver
Manager] Driver's SQLSetConnectAttr
failed
/outlook/connections.inc, line
12
|
6/25/2002 12:30:01 PM:SNOWDAZE
FYI, regarding the error above, you can
only have a SYSTEM DSN set up, if you
have a user DSN and SYSTEM DSN setup
you will get this error.....you also
have to remove both DSN's and then set
up a system DSN, hope this helps!
|
6/26/2002 6:32:17 AM:faraz
Plz mail me which version of JMail you
use in your program and also give the
url from where JMail component is
downloaded
|
6/26/2002 7:01:45 AM:Ahmad Faraz
I have download the JMail component
from www.dimac.net and registered it .
but when I use it I got the message
that this version of JMail 4.3 does not
support the given function
call.
Please do something for me
........
|
7/3/2002 6:11:38 AM:chandra
very nice useful stuff, i was looking
for not reinventing the wheel and this
served my purpose.
|
7/30/2002 8:44:48 PM:NuToASP
I keep getting the error below, tried
everything User DSN and System DSN but
still fails.
Error Type:
Microsoft
OLE DB Provider for ODBC Drivers
(0x80004005)
[Microsoft][ODBC Driver
Manager] Driver's SQLSetConnectAttr
failed
/outlook/connections.inc, line
12
|
8/1/2002 2:24:57 PM:MP
Hello Daniel
Excellent program..
But
after I install Jmail it is
saying
jmail.POP3 error '8000ffff'
This function is not included in
this version of jmail.
/Outlook/bin/inbox_headers.asp,
line 36
what is the
problem.
Regards
|
8/22/2002 1:12:41 PM:Carol
Hi.... Looks like you worked you bu**
off!!! I have a question. This
program does not seem to be working on
the Internet. I uploaded it to our
server and configured connections.inc
to read from a DSN connection. But it
won't even allow registration. I get
error pages and such. Has it run
successfully on the Internet? Is there
a working example somewhere? Thanks
again.
|
9/12/2002 5:51:27 AM:
Nice asp-coding but i've 1 little
problem.
I've installed the latest
JMail but i've got an error:
Error
Type:
jmail.POP3 (0x8000FFFF)
This
function is not included in this
version of
jmail.
/roswell/outlook/Inetpub/wwwroot
/Outlook/bin/ inbox_headers.asp, line
36
Browser Type:
Mozilla/4.0
(compatible; MSIE 5.0; Windows 2000)
Opera 6.0 ¤ [e¤ [en]
Page:
GET
/roswell/outlook/Inetpub/wwwroot/Outlook
/bin/
inbox_headers.asp
Time:
donderdag 12
september 2002, 11:50:45
More
information:
Microsoft Support
How
can i solve this?
Sincerely
Pieter
|
10/11/2002 12:45:03 PM:
Daniel,
Great program, but I've
noticed that the dates on the advanced
view of the planner don't match the
proper days when using the previous
month button. Any planned fixes for
this.
Thanks
|
|
| Add Your Feedback! |
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.
NOTICE: The author of this code has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular code, please click here.
|
|
