Send Batch Of Sql Statements To Sql Server

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.

exec myProc @param1 = 'A'
exec myProc @param1 = 'B'
exec myProc @param1 = 'C'
exec myProc @param1 = 'D'
exec myProc @param1 = 'E'
exec myProc @param1 = 'F'

View Replies


ADVERTISEMENT

Running Bat (batch) Files On Windows Server 2003 With Asp

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:

View Replies View Related

Haw Can I Send A Parametre To SQL Server

How can i pass a parameter SQL stored Procedure from ASP pages

View Replies View Related

Send Data From To C++ Server

Suppose I have a C++ server that listens to a port (WinSock API). Is it possible to send a data to that server from ASP page? If yes, how?

View Replies View Related

Use CDOSYS To Send Email On Different Server

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?

View Replies View Related

How To Send Mail Using ASP Through Proxy Server

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:

Set objCDOMail = Server.CreateObject("CDONTS.NewMail")
objCDOMail.From = frommail
objCDOMail.To = tomail
objCDOMail.Subject = mailsubject
objCDOMail.BodyFormat = 0
objCDOMail.MailFormat = 0
objCDOMail.Body = mailbody
objCDOMail.Send
Set objCDOMail = Nothing

View Replies View Related

Send Email Using ASP At Linux Server

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....

View Replies View Related

How To Send UDT From A ATL Server Implemented In VC++ To ASP Client

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.

View Replies View Related

Send HTML Email From External Server

how to send an HTMl email from an external server. I am trying to Send email using CDOSYS
this i what i have tried but cant get it to work.

View Replies View Related

Declare Smtp Server When Send Email

My question is do ASP need to declare smtp server when send email using CDonts function?

View Replies View Related

Send Form Submission Data To Another Server

A website has a form with the first line as written below:

<form METHOD="POST" action="submission_form.asp" name="FrontPage_Form1" webbot-action="--WEBBOT-SELF--">

Can I, if I match the field names used, submit my form and have it sent to their server as if the submission had come from their server?

Could I use:
<form METHOD="POST" action="http://www.example.com/submission_form.asp" name="FrontPage_Form1" webbot-action="--WEBBOT-SELF--">

and I match all of the field names? Would that work?

Could I harm their "database", or whatever they are doing with the form submission?

Since you are going to ask "why". My reasons are noble enough. It would just make things much easier.

View Replies View Related

How To Send A Form With Binary Data To Another Server?

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:

View Replies View Related

How To Send Request To IIS Server After The Page Displayed

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.

View Replies View Related

Send Mail Using Lotus Notes Server

I’m using ASP with VBScript…and I need to send mails using Lotus Notes Mail Server (IBM).
How to communicate to the Lotus Notes Server and send mails?

View Replies View Related

Problem When Send Email With Attachment From Diff. Server.

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.

View Replies View Related

Email Send Failed: The Server Rejected One Or More Recipient Addresses

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:

referers = Array("www.endlessenergysystems.com", "endlessenergysystems.com")
mailComp = "CDOSYS"
smtpServer = "smtp.readyhosting.com"
fromAddr = "info@endlessenergysystems.com"

View Replies View Related

Batch Print Several PDF

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.

View Replies View Related

Batch File

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>

View Replies View Related

Batch Printing?

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.

View Replies View Related

Batch Process

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.

View Replies View Related

Batch Files

How do I statically change my ip address to specific IP via a DOS batch file and back to DHCP via another DOS batch file?

View Replies View Related

Batch Email

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?

View Replies View Related

ASP Batch Emailing

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.

View Replies View Related

Batch Files

How do I statically change my ip address to specific IP via a DOS batch file and back to DHCP via another DOS batch file?

View Replies View Related

Batch Update?

How do people go about batch updates. I can do batch deletes no prob.
In ref to bacth updates such as One to Many.

Lets say i want to move everyone from one group to another
thats where i'm stuck.

Tbl1 : Category
Tbl2 : Users

If for instance i need to change 45 (id=25) users from
Tbl1.field3 to Tbl1.field3 to (id=18)

In Tbl2

View Replies View Related

Executing A Batch File From Asp?

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?

View Replies View Related

How To Call A Batch (.bat) File

how to call a batch (.bat) file from an asp file

View Replies View Related

Sending Batch E-mail

I would like to send batch e-mail from fields in multiple records.

View Replies View Related

Batch Form Processing

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.

View Replies View Related

Running A Batch File

Was wondering if anyone had any suggestions on how to execute a local batch file by simply pressing a button on an ASP page?

View Replies View Related

Running A Batch File

how to run a local Batch file from an asp page by simply pressing a button on the page?

View Replies View Related

Vbscript To Run A Batch File

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?

View Replies View Related

Batch Image Upload In ASP

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?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved