how to go about sending a batch of sql statements from asp to sql server, and
having errors appropriately handled? for example,
i want to send the following stored procedure calls to sql server in a
single batch from my asp code, rather than using a loop in asp to execute
each procedure individiually. if one of these fails, they all should fail.
im trying to run a bat file on windows server 2003 and am running into nothing but problems.
i have IIS on my XP workstation that accesses the 2003 server. what im about to explain below works properly on the XP IIs.
i have two files: somefile.asp and somefile.bat. the asp file creates a wscript.shell and then tries to execute the run method for somefile.bat.
however, it isnt working. after an unexaggerated 7 hours of searching google/etc, i have found nothing but frustration and deep, seething anger regarding this problem. Code:
I've set up a website contact page which uses CDOSYS to send form details to an email address.
However, the domain is set up such as the client is using their own mail server, and using my server only to host the website.
Ordinarily I would set up hosting with email and change the nameservers of the domain to point to my server, but in this case the client is keeping the nameserver details the same, but just updating the A record to point to my server to display the website.
Trouble is, the CDOSYS email doesn't seem to work with this set-up. Do I need to hard code their mail server IP somewhere to get it to work?
My computer is at intranet,I want to use following code to realizing function of sending mail.But this program only can send mail between intranet.If I send mail in internet,I need to through proxy server,the proxy method is HTTP(proxy server:xx.yyyy.com,port:8080,username/password),I want to use this program to send from intranet to internet through proxy server.I want to know how to realize this function.My code is follows:
I need to send a email to my clients from my website using the email object. I developed my site in ASP, and the server is linux, thats why i cann't use CDONTS object to send emails bcz server is not IIS....
I want to know the possiblity and process of an ASP client, which needs to get some UDT from a ATL Server component implemented in VC++. The UDT is basically a C++ class consisting of a BSTR and a short. for eg.,
class CMyClass { BSTR myName; short myNum; };
and what actually i need is to pass a collection(vector) of this object to ASP client as well as to a VC++ client.
I'm trying to submit an image object, along with some other text fields to another web server from within an ASP page but am stuck on getting the image to be submitted with the form.
In a bit more detail:
1. When this particular page is executed, I want the server to pull an image from a db (stored as a BLOB) along with a few other text fields. This part is easy and I have no problems with it.
2. I want to submit the image, along with the text fields to a second webserver which typically accepts its input from a form (ie, the second webserver usually has a webpage where a user enters some information into form and browse for a file. When clicking submit, the form fields along with the file are submitted to the second server).
The reason for this is that I'm trying to migrate from one web based photo album to another which uses a data structure that is complicated and difficult to interface with, so I'm using the web based image upload functionality of the new album. Code:
Is that possible that I can send request to IIS Server after a .ASP page is displayed? My Requirement is:
Clinet will Fill the Details in one Request Form after the details are filled then the Request Files will be shown to the user as Link in Another page. (Currently before Sending the Link Page to Customer I am updating DB in Different Servers Located Different Palces - So It takes Time).
So What is My Requrement is After the user gives his details - I will directly display the Link Page and After the Link Page is Sent to Browser then I will Execute / Update the DB.
I want to send email with attachment. I have no problem if the file is located on the same server but i got error when attach file from different server. This is the code,
set mail=server.CreateObject("persits.mailsender") mail.host="smtp.mydomain.com" ..... 'mail.addattachment "c:attach est.txt" ' no problem with this mail.addattachment "websvrattach est.txt" ....... mail.send
I got this error, "Persits.MailSender.4 error '800a0007' Logon failure: unknown user name or bad password."
when i changed the servername to static ip address also got the same error. any idea? fyi, this user has an administrator rights to the server.
I am using ASP formmail from www.brainjar.com. I keep getting this error message: Form could not be processed due to the following errors:
Email send failed: The server rejected one or more recipient addresses. The server response was: 550 endlessenergysystems.com.
The email address in the form is correct and does work. I have changed the settings to different email address and SMTP servers to try to figure out the issue. However I still get the same error. Here are the basic settings:
We have LOADS of documents scanned to PDF format, stored in SQL tables.Allowing a client to browse our ASP driven site to select and view individual PDFs has been no problem. ("index" table is queried to show list of available PDFs, user clicks a link in the list, PDF reader shows the document in a new window.) Now, they would like a feature that would PRINT (at their location) batches of documents via the website, preferablely with a single click.
Security issues, warning messages, etc., aside, what MIME-type combination do I need for and ASP to write a BAT file to the response stream? e.g. Response.Clear Response.ContentType = "application/octet-stream" Response.AddHeader "Content-Disposition", "attachment;filename=message.bat" Response.Write("net send COMPUTER2 success") Response.End() This code does not work! Which is surprising because in my current config, the following html works fine, and executes on the shell: <A href="message.bat">test</A>
First, a little background. I'm developing an order management system for my company and I want to be able to print a batch of packing slips in one go without pulling each one up on the screen and clicking 'Print'.
How can I do this in ASP? The only way I can come up with is to loop through the records and concatenate a string with the HTML code and then send that string to the printer. But, I'm not exactly sure that's the best way or if it is even possible.
I want to basically click a button that says "Print All Packing Slips" and never see an output screen.
i have to start a batch process from a dll to transfer files created by this dll to remote ftp server. I created a batch file:
ftp -n -v -i -s:D:atchftpcmds.txt ftp-server
and a file containing the ftp commands:
user username password lcd D:atchmedia mput *.* quit
It works pefectly when i start it from the dosbox. But when i call it from the vb dll implemented in IIS (shell ("D:atch ransfer.bat")), it does not complete the transfer and hangs after 400-500 (small) files.
I have a web page that sends emails to groups of recipients. It uses CDONTS to send each email. While it works fine for sending a small amount of emails out, it chokes the page when sending to large amount of email addresses. Basically, it loops through each email address and sets the CDONTS object each time. I need to do this because each email is personalized.
Does anyone have any thoughts around how to optimize this code. Is there anyway in ASP to send the code to a background process for example?
I need to send batch html emails out from a db mailing list (anything up to 1000 in one go).I am using CDOSYS and standard ASP. My problem is that it will error if I try to do any more that 5 every 30 seconds - this is fine when I send them out myself (I have a script to do this) but now I need a program which will allow users to send out batches and I want it to appear seamless.
We're trying to write an application that will allow a user to enter an id field from an ASP intranet page and when they hit the enter button, fire off a print job. The problem is, Adobe must be open as the items being printed are PDFs.
We tried firing off a print command using MS SQL cmdShell() (not sure if that is the exact name of the command) and it works, but it never completes. The process hangs in the database because, we think, it hasn't closed Adobe, therefore never coming back to the query. We wrote the query into an ASP page.
Adobe must be open or the documents won't print properly.
Does anyone have any suggestions to how we can automate this?
I have a form that users enter details of a car (e.g make model , idnumber#) and then press save to save to the database they may want to order 10 cars with the same details exept the idnumber so to save the users entering in all 5 details I want to make it easier.
Should I have a list box and let the user add idnumber items from a text box and then pass this to my update asp and loop through + to save to the database or should I save one record and then return back to the same form Note : I am having problems with this method as only part of the fields show when I hit the back button I just wondered what is the best method of doing this I am spoilt for choice and I also get problems.
I have a batch file that needs to execute every day and I need to run it in a silent/invisible mode. I looked up on the Internet and found this command: shell("batchfilename.bat").
Upon failure, learned that it is a Visual Basic command and not VBScript command. I wonder if anyone knows how to run a batch file using vbscript that runs in invisible mode?
if anyone has experience in building the ability to upload/insert multiple images from one directory on the client machine to an Access database via asp. The process would be to click on the browse button for the correct images and you would be able to click on multiple images using ctrl or shift button and then insert the selected files into the database. Can this be done?
