Reading POP3 And Writing To SQL Server+uploading Attachements
I am looking for a system that will:
1. Read a message from a POP3 mailbox
2. Parse the message into its parts
3. Create a record in an SQL server table with selected fields of the message
4. Upload the attachements to the filesystem
5. Write the path of the attachements to the SQL server record
For security reasons, I want the process to be initiated and approved
by a user.
- a form that updates a text file. - for example, in the form I have two fields, title and story. then, this write to a textfile (i.e. theinfo.asp). the update.asp file looks like this:
- so, essentially it is creating an asp file with two variables. - this works fine, it updates the file and i can call these variables in other pages. however, when i call these variables into a form : old versions of the variables populate the form: Code:
i had a vbscript that will read the text file from the bottom to the top, and after reading the file, it will be displayed in the screen, and the code look like this: PHP Code: Code:
We have stored user registration information in an Access database, and we wish to develop an email with attachments like words document and pictures in jpeg/gif format and import mailing list from the Access database and to send this to the user .
i am working on a page which calls an asp page on another server with some xml and then gets some xml back. the page calls and returns the xml fine but trying to display that xml properly is the problem.
here is the code:
Code: set req = Server.CreateObject("Msxml2.XMLHTTP") req.Open "POST","http://www.domain.com/xmldata.asp", false
What I need it to do is, after the user fills out the form, attaches their document and clicks submit it sends an email to a specific person.
I did this one time with PHP and followed a baby steps type of tutorial (Minus the attachment) so if anyone has something similar it would be greatly appreciated.
The backend is ASP website running on IIS6.0 on Windows Server 2003.
I would like to create a file on the hosting server (if it doesn't exist yet), then I would like to write some error information into it. Finnaly I would like to retreive that information later.
I had to disable Script Blocking, afterwards it worked just fine. HTH Norton Script Blocking cause this problem. the 9o days testing product are finished earlier.
strPath=Server.MapPath("ADList1.txt") Set objFSO=Server.CreateObject("SCRIPTING.FILESYSTEMOBJECT") Set objOpenFile=objFSO.OpenTextFile(strPath,1) Do While Not objOpenFile.AtEndOfStream Response.Write(objOpenFile.ReadLine() & "<br>") Loop objOpenFile.Close Set objOpenFile=Nothing Set objFSO=Nothing %>
When I try to execute the above code, the code never gets executed. Neither am I shown a script timeout error. After a lot of investigations, I concluded that the code is not getting executed due to the presence of
Set objOpenFile=objFSO.OpenTextFile(strPath,1)
If I comment line nos. 3 to 8, then the code gets executed but as expected without any output. Is this happening because of some permission which has not been given to IIS 5.0? If so, what is it? I am working on Windows 2000 Professional.
I need to read a simple txt file where there are some variables. I've done this a lot of times but in this case I have something different: the text file is located at an ftp server.
I have an application which was successfully writing data from submitted forms to a text file in a directory - in this case:
/data/findata.txt
This was fine because the forms lived at the root level with this directory.
Since then I have added enabled the forms to be used on subdirectories :
/subdirectory/myform.asp
I've used the same code for server.mapparth("data") etc - but instead of locating the directory at the root of the server called "data" it looks to the current directory- doesn't find it and creates another! eek!
What I need is a way to say "right, it doesnt matter what level you are at at the moment, always look at the root level /data directory"...
This has to be fairly dynamic - on the development server here its got a different file structure than on the live server (ie, it lives another level down again on the physical drive)...
Anyone got a good idea on how to look back up?
I do have one way to test which level they are at - but I feel that its a bit 'weak' - I have an ID that tells me if they are working on the upper or lower levels (ie, anything other than 1 is a lower level) - whilst I realise I could use this in the test I'm not sure if its going to be 100% fool proof to base this criteria on this ID.
Therefore I was hoping for a better way using the server.mappath etc...
I need to know the codes to upload my csv file (*csv) generated from Excel to SQL Server. I aso need to have the codes for uploading my CSV file to my access database..
i need to know the codes to upload my csv file (*csv) generated from Excel to SQL Server. I aso need to have the codes for uploading my CSV file to my access database.
I've got a stored procedure which returns a select query on a linked server. This works fine if i call within SQL and Query Analyser but if i try and execue to return data to a ASP recordset i get the ridiculous
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].
Am i missing something really basic like a simple setting or is it just not possible.
Other than creating a custom component or purchasing one, isn't there any other way by which users can upload images/files from their local machines/hard disks to a remote server? Doesn't ASP have any in-built component to do so?
If that's indeed the case, can someone suggest any free components (not trial ones) which can be used to upload images/files from users' local machines/hard disks to a server?
I have a directory (folder) in ISS 6.0 Web server. I need to upload to a secure server over an HTTPS connection. What is the best method to upload from this directory to a secure sever.
To access the server via a browser i have to type a password and username. The file are Cxml files and need to be uploaded on a secure connection.(HTTPS) I would need to run a schedule task every 2 minutes to check the directory for any files that are there.
What script or method should i use. Is there any particular sample script such as (ASP) i could use. I am sure this can be done in ASP...but does anyone know how.
I was wondering if there are any known problems when using an apple macintosh to upload files and put text in a database via an ASP page that could cause either database error pages or simply some data not being written to the database. I have had this problem on a couple of sites now, and not been able to recreate the errors on my PC.
I've been trying to create a test site - The site uses ASP with VBscript and talks to SQL Server 2000. I was able to complete and test it on my locally on my computer using Microsoft’s IIS 5.1. The website communicated fine with the database on the webserver/network server
However, when I tried to save the site from my local computer to the wwwroot folder in the server’s IIS hoping to make the internal site available to everyone here the resulting error comes up when we try to open a page with a recordset connected to the database: -
Our Error: - Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'AUMBSDDSSIUSR_AUMBCOMP'. /mysite/htm/test2.asp, line 8