How would I be able to simply read an MS Exchange Server 2000 mail and transfer it to a SQL Server 2000 database programmatically. I need reference for this an has been unsuccessful in looking for any for the past week already.
I have no idea how to get started, really, but I am looking for a way to have an email sent via an ASP page via our Exchange 2000 server.
I have a fairly simple asp page that displays data from a SQL 2000 database in the form of web links. A part of this page allows people to post links to the database for display. When someone posts a link, I would like an email sent to me with the data (link) that they posted through the ASP page.
This page is on our internal web server only and only our domain users can access this web server. We have a single exchange 2000 mail server.
I did look at ASPFAQ 2026 on using CDO for sending e-mail but this doesn't help me much because it doesn't say anything about connecting to the exchange server or anything about proper authentication with the exchange server.
I have one 3 tier architecture application running on Windows 2000 Server.
I have created replica of same machine on another machine where OS is Windows 2000 Advance Server.
But when I port same running application on new machine i.e. Machine with OS as Windows 2000 Advance Server, my middle tier (Active-X Dll, COM+ application) fails.
It throws common error Invalid Procedure Call or argument
What could be the problem? Do I need to change any settings for running application on Windows 2000 advance Server.
I am planning to design a database (destined for the web) that will have between 20000 and 45000 records in it and will receive a lot of reads but very very few writes (just from me).
Now the question is should I use:
1) The combination of Access 2000 (accessible through ASP or ASP.NET) using OLEDB Jet
or
2) SQL Server 2000 ?
Of course I know that the SQL Server option is a better one, especially since it's said that an Access DB can have about 9 users or so accessing it at the same time. But is that a general rule or is it about many people writing to the DB? In other words, if an Access DB has hardly any writes and 99.9% reads can it be used as efficiently as it would be used on SQL Server 2000?
I have created a form that sends email thru my local server. What I want to do is send the email thru our corporate Exchange server. Does anyone know how I can accomplish this task? Please advise. Thanks.
I require an Asp script that will enable me to get all sizes of mailboxes held on Exchange Server v5.5. What I want to achieve is to list all users with a mailbox over a certain Kb size.
I am an intermediate with ASP and i'm not sure if this is possible but i'll give it a shot. I am creating a Listserv (newsgroup) and I want them able to reply to messages in there email. Right now I have sign up form online which connectes to an access db which stores the emails. The admin uses a web based form to send letters and if the subscribers want to send a message or reply they have to use another web form. How can I use exchange server to eliminate the web based forms?
So basicly I want them to reply in like outlook, but the emails are all in access. So when they reply to the list email (list@home.com), somewhere in the exchange server the server will read the db and send the message to the subscribed emails.
I'm sending email from a networked computer that uses an exchange server on yet a different computer. With the two different types of code posted below, the email will only send successfully on my computer. When I step into a colleague's office (using the same exchange server), no email is ever sent....
I have a form with a input text box where a user has to enter a work email address.Is there anyway that he or she can click a link which will open Microsoft Outlook and list all the work email addresses, thereby selecting an email address which will be automatically inoutted into the input text box?
I have developed a fairly simple CMS for my intranet at work - I would like to have a "Request a photographer form" that e-mails me the posted data by utilizing our intranet exchange server, if possible.
I'm not really looking to code this but I will if I absolutely have to =) Anyone know how to do it or where I can find a simple form script that does? I have found lots that work with sendmail and other types of servers but none for exchange.
I have no knowledge of Exchange server, and have always used CDO to send emails from ASP in the past. the server in question doesn't have SMTP installed alongside IIS, it has Exchange installed which apparantly does have SMTP capabilities but not like the default ones normally accessbile via IIS.
Has anyone ever used this approach to sending emails? I'm hoping that I dont need a component or anything else, just some changes to my existing email code.
I use the method below to send emails from an asp page that's part of a web application:
<!--METADATA TYPE="typelib" UUID="CD000000-8B95-11D1-82DB-00C04FB1625D" NAME="CDO for Windows 2000 Library" --> <% On error Resume Next Dim cdoConfig, cdoMessage
Set cdoConfig = Server.CreateObject("CDO.Configuration") With cdoConfig.Fields .Item(cdoSendUsingMethod) = 2 .Item(cdoSMTPServer) = "MailServer.Name.com" .Item(cdoSMTPServerPort) = 25 .Update End With Set cdoMessage = Server.CreateObject("CDO.Message") With cdoMessage Set .Configuration = cdoConfig .From = "Me<mailsender@mymail.com>" .To = "You<mailrecipient@somemail.com>" .Subject = "Surprise!" .TextBody = "Helloooo..." .Send
If err.number Then Response.Write("Houston! We have a problem...") End If End With Set cdoMessage = Nothing Set cdoConfig = Nothing %>
On the production server (Windows 2003 Server) everything works fine and I don't have a problem sending the mails from the application. However, I recently upgraded my development box to Windows XP Pro SP2 and the code fails with with the following error:
CDO.Message.1 (0x80040213) The transport failed to connect to the server.
The from and to email addresses that I'm using are valid and part of my domain (not a Hotmail or other freemail address).
The SMTP service is up and running on the dev box.
I also tried replacing the mail server name with the IP address of the mail server, but again it's failing.
We are running Exchange Server for email and if I change the cdoSendUsingMethod to 3 (for cdoSendUsingExchange) the mail is sent correctly without errors.
Will I not able to use the cdoSendUsingPort method to send the email if I'm on Exchange? Am I forced to use cdoSendUsingExchange?
I am having a problem here to send my asp form to my email! I am using CDONTS under w2k and IIS! when i submit the form, all of the message (that suppose to go to my email), went to the queue folder under wwwroot!! nothing appear to my yahoo email also... that means that my script is working...but only the configuration is need to be adjust here!
the thing is that i dont know how to configure, setup or setting the configuration for Exchange server! since my organization uses exchange server instead of the SMTP!
Im trying to create an application that when sent an email, retrieves the email, and uses its content to create an MS Outlook/Exchange task request.
I have everything else in place, but when I try to connect to CDO's MAPI interface, I get [Collaboration Data Objects - [MAPI_E_LOGON_FAILED(80040111)]] error messages. I've tried numerous examples from books and the internet to no avail.
Could anyone shed some light as to why this is so? I've also exhaustively searched the archives on this site for examples and used some of them but I keep getting the same errors. Code:
I have the following code, that retrieves the emails from a designated inbox, stores the message and subject content in a SQL database and then deletes them from the exchange server. Now I need to take the attachments for each email and save them on a different server.
I've researched this all day, and I keep finding references stating that I can download the file using, X-MS-ENUMATTS. I'm using it currently to retrieve a list of attached files, however I fail to see how I can download the attachment to my webserver using this.
The red code below is a request to the actual file. So I know the http path to the file, how do I go about saving it to my server? If I can't downlaod it without any user interaction, is there at least a way that I could allow the user to download the file via a link, without them being prompted for a username or password? Code:
HTTP 500.100 - Internal Server Error - ASP error Internet Information Services
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'IUSR_MOHD'. /sql1/data.asp, line 16
when i try to add data to my sql server 2000 database throw asp?!? so whatz the problem , i try to connect it to access on the same lginuser and it works well
We are not using Active directory and as such do not have access to Kerberos authentication methods. What I need to do is connect to an SQL (2000) database using ASP 3.0 - I have setup an account on SQL Server with read access to two tables (and no password). Just to complicate the issue even further, the IIS server and the SQL server reside on different machines on the network. Code:
Is it possible to create an ASP page that can notify the user that they have an email on our Exchange server? And that will list the number of unread emails they have waiting in their inbox.
I'm just after installing windows 2000 server. It seems to be running fine. I can log onto sites stored within etc. However I'm having major problems trying to sending email forms. I am using an asp form to send the details however I never receive them. After completing the form and submitting the user is brought to a confirmation window which displays all the form details. There are no errors howver the email is never recieved.
With the errors I cannot say if the email was sent or not. So i do not know if it is the server settings or the asp file.
Do I need to preform additional installation of configuration to get the smtp server up and running as I am only using the default settings.
I just started learning ASP.NET and i need to learn to use the database for SQL Server 2000 quickly. First, (forgive me for my ignorance) what is a database? Do you guys know any good sites that teach you how to access the database for SQL Server 2000? and have tutorials, and sample code?
I've noticed a few times yesterday I recived this error on my web server:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
I know for sure the server is running and at the time was under a load of about 2,900 page views for the hour. By far not my largest audience. What could cause this? Is ODBC having some issues? FYI, the database server isn't on the web server, they are physically two different machines connected via LAN.
I am creating a small program for my workplace in asp. It runs fine o my laptop using XP Pro through IIS. I set IIS up on the server runnin Windows 2000 Server Standard, have IIS set up identically, and i doesn't recognize the session variables. Even trying to run i directly on the server, not through the network, it doesn't work.
Will CDO work under Windows Server 2000? I'm guessing it will. The problem is that I wrote a nice little ASP app under Windows Server 2003 which works REALLY well. Sends out the email with NO problem. 'Course, it uses an external SMTP server, but I'm assuming this shouldn't matter, right?.
Because when I port it over to Windows Server 2000, it blows right past it. Is there a particular setup procedure that needs to be done for Windows Server 2000 to enable CDO to work properly?
I've not used Index Server since I set it up about 4 years ago on a Windows NT 4 machine.
I now have to move the site to a Windows 2000 machine. I've hunted high and low and have yet to find anything on the subject. Anyone point me in the right direction?
Am having a bit of trouble with the @@identity field - I probably just have that friday feeling and am missing off something obvious, but the below code brings back am empty identity value ("sid" appears empty). I've definitely set up an identity field in the tblSurvey:
My client had someone modify their home page of their commerce site. Howerver when then did they removed the include for store/template/menu.asp and created a hard coded menu on the default.asp (home page). Now the client wants this static menu to replace all of the dynamic menu's throughout the site. I found the area in menu.asp that pulls the data from the commerce server and if i delete this section the old menu item go away. I need to know how to insert the static HTML menu items in its place.
Our site is down, because of our hosting company applied sql server 2000 sp4 on windows 2000 server.
right after it applied the service pack, our sql server database is down and no conn etc. When one technical support restart the server,
the obejcts like tables in database cannot be recognized from our asp pages anymore, data cannot be inserted into any database table and data cannot be pulled out correctly from database table through asp program, but I can run query and look at data through sql analyzer.
what is the problem, is it because of connection string? before this service pack 4, everything runs fine and we never had this kind of disaster.
I'm using sql server 2000 database and trying to access it using asp. when i installed sql server, i selected the mixed mode of authentication(windows and sql server). Code: