|
|
Comments and Discussions
|
|
 |

|
i just could not connect it to ms sql 2000..
i always got a message that says login failed to user CDIwmuser
and of course i tried to change some seting in data_asses.asp file
like the server name ...(i use the server name of the SQL server)
so am i right or not...
here is what i used
'strServer="SQLCDI\CDI"
strServer="(local)" .......the name of SQl server
strUser="CDIWMUser"
strDatabase="CDIWM"
strPWD="user"
but it is not working what shall i do plus i am using IIS so is this wrong
it usually work for me if the database is Access .mdb
help!
|
|
|
|

|
it looks right, as long as you have granted the user dbo rights to the database, you should be good.
CDIDave
|
|
|
|

|
[id] [int] IDENTITY (1, 1) NOT NULL ,
[recip] [varchar] (50) NULL ,
[msg_id] [int] NULL ,
[active_flg_recip] [int] NULL ,
[msg_read] [int] NULL How to fill this field any thechnique,
[reply_id] [int] NULL ,
[foward_id] [int] NULL ,
[read_time] [datetime] NULL ,
[folder_id] [int] NULL ,
[reply_date] [datetime] NULL
Janifer
|
|
|
|

|
[id] [int] IDENTITY (1, 1) NOT NULL ,
[recip] [varchar] (50) NULL ,
[msg_id] [int] NULL ,
[active_flg_recip] [int] NULL ,
[msg_read] [int] NULL How to fill this field any thechnique,
[reply_id] [int] NULL ,
[foward_id] [int] NULL ,
[read_time] [datetime] NULL ,
[folder_id] [int] NULL ,
[reply_date] [datetime] NULL
|
|
|
|

|
[id] [int] IDENTITY (1, 1) NOT NULL ,
[recip] [varchar] (50) NULL ,
[msg_id] [int] NULL ,
[active_flg_recip] [int] NULL ,
[msg_read] [int] NULL How to fill this field.
[reply_id] [int] NULL ,
[foward_id] [int] NULL ,
[read_time] [datetime] NULL ,
[folder_id] [int] NULL ,
[reply_date] [datetime] NULL
|
|
|
|

|
I just want a simple mail sender as below:,
I am using the three files below to be able to "send mail" .
When I go to http://www.aanning.com/input.htm and put in the e-mails and msg I get":
Error Type:
Active Server Pages, ASP 0134 (0x80004005)
The object has an invalid ProgID of 'MSWC.MyInfo'.
//global.asa, line 1
I know I'm REAL close.......and this USED to work!! please advise.
Thanks much
James.
---------------------------------------
files used below global.asa, input.htm and sendthemail1.asp
GLOBAL.ASA file:--------------------------------
<OBJECT runat="server" SCOPE=Session ID=MyInfo PROGID="MSWC.MyInfo">
</OBJECT>
INPUT.HTM file:---------------------------------
<html>
<head><title>Mail Input Page</title></head>
<body>
<form method="post" action="sendthemail1.asp" name="input">
| From |
<input type="text" name="From" size="20"> |
| To | <input type="text" name="to" size="20"> |
| Subject | <input type="text" name="subject" size="20"> |
| Body | <input type="text" name="body" size="220"> |
| <input type="submit" value="Send" name="B1"><input type="reset"value="Reset" name="B2"> |
|
</form>
</body>
</html>
SENDTHEMAIL1.ASP file:-------------------------------
<%
Response.Buffer = True
Dim strFrom
Dim strTo
Dim strSubject
Dim strBody
Dim objCDOMail
strFrom = Request.Form("From")
strTo = Request.Form("to")
strSubject = Request.Form("subject")
strBody = Request.Form("body")
Set objCDOMail = Server.CreateObject("CDONTS.NewMail")
objCDOMail.From = strFrom
objCDOMail.To = strTo
objCDOMail.Subject = strSubject
objCDOMail.Body = strBody
objCDOMail.Importance = 1
objCDOMail.Send
Set objCDOMail = Nothing
%>
<html>
<head><title>Sent Mail</title></head>
<body>
Your mail was sent to:<% = request("to") %>
The time that is was sent was: <% = Now %>
</body>
</html>
|
|
|
|

|
Please copy your replies to Janning197@aol.com
|
|
|
|

|
i just want to know how to create web sms using asp code and do you have any demo or example for this solution?
-bOb-
|
|
|
|

|
HEY CDIDAVE
could u give me a better explaination of your database Structure.
thanks
I@n
|
|
|
|

|
I need to develop a web-based message system that application users can utilize to send and respond to messages back and forth to each other. I love the example that you provided here and was hoping that you could assist me in providing a solution. It would not use SMTP or CDNTS but instead use a SQL Server database and nothing else. It would act like and look like email but would only be a messaging system. Users can message each other back and forth basically and thats it.
I have some something already but it is not very realistic. I'd like to take what you have demonstrated just stripped of the SMTP stuff.
Can you help?
Thanks!
Don
dquillan@hotmail.com
|
|
|
|

|
This is not a place to sell your code. Go somewhere else if you want to do that.
|
|
|
|

|
Hi,
When I open up to view a message I keep getting the following error....
Microsoft OLE DB Provider for ODBC Driver error '80040e07'
[Microsot][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string.
email/include/data_access.asp, line 23
Any help on this would be great.
Cheers
|
|
|
|

|
Hi,
When I open up to view a message I keep getting the following error....
Microsoft OLE DB Provider for ODBC Driver error '80040e07'
[Microsot][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string.
email/include/data_access.asp, line 23
Any help on this would be great.
Cheers
|
|
|
|

|
Hi,
i'am reading Your article. It's fine. I want upgrade this project to the ASP.NET. Any suggestion/ideas welcome.
Andrew.
|
|
|
|

|
HI I am also looking for ASP.NET solution of this project, any ideas?
|
|
|
|
|

|
Do you have an example using CDOSYS as this example will not run on Windows XP since XP no longer supports CDONTS?
|
|
|
|

|
This application does not use CDONTS, it is native SMTP. It creates a text file using SMTP file format and simply places it into the SMTP mail folder on the server. If you have sMTP enabled, it will pick up the file and send it as email...
CDIDave
|
|
|
|

|
Perhaps I am mistaken as I'm still very new to this stuff... I was looking at the SendMail.asp file. It creates a CDNTS.NewMail object and sends it further down in the file.
|
|
|
|

|
I am not using a file called sendmail.asp. Look at the make_email.asp...I do not create a cdonts object..I use the filesystem object
CDIDave
|
|
|
|
 |
|
|
General News Suggestion Question Bug Answer Joke Rant Admin
|
A simple email-like system to handle messages posted from an HTML form.
| Type | Article |
| Licence | |
| First Posted | 15 Nov 2003 |
| Views | 103,267 |
| Bookmarked | 50 times |
|
|