I used some example code from MS site (http://support.microsoft.com/kb/285176/en-us) to create an ASP page that executes a mail merge in word from a web page. For some reason when it attempts to run the getdata.asp part I always get theerror ..."The connection cannot be used to perform this operation. It is either closed or invalid in this context.
I have tried numerous ways to connecto to the database and form the record set but still get the same error.
Does anyone know whether it is possible to effect a mail merge to MSWord
using VBScript in an asp file? I know it is possible to produce a doc
file and force a download using
Response.ContentType = "application/msword"
Response.AddHeader content-disposition","attachment;filename=myfile.doc"
but can I interate through a bunch of records and produce, say, a
separate invoice for each one by merging? I know how to iterate through
the records and write them out
I have an ASP intranet application that is required to produce Word documents merged with data from a database.I originally looked at automating Word's mail merge capabilities, but nixed that idea since I learned it's not a good idea to try to automate Word on the server
decided to have the Word templates saved as RTF files and to write a parser/merger myself.since Word produces such complicated RTF code,until we decided that we were going to combine multiple templates into one final Word document with, potentiall, different header and footers for each section/template doc.
I'm having a problem figuring out how to get sections inserted into the combined RTF doc, so I'm thinking perhaps I should rethink my solution.how to produce database merged documents from templates created by users on a Web server? We may have some budget, sothird-party tools would be welcome, as well.
HOW can asp open a *.doc and read it and extract mail merge tags and their definitions/values?
View Replies View RelatedI have a document. Top right is a logo, there is a space for an address, space for content and space for extra details (3 sections). This can be seen as a normal word template.
I pull in information from a DB so have values: Address, Content, Details. I need to insert these values into their relevant places and produce the word document from the template so user can open/save it.
I've done some research on how to do a MS Word merge with data I read
in an ASP application (using a SQL Server database).
I understand the concept since I've done it in a couple other
programming languages.
Can someone tell me if it is possible to perform merge operations on a pdf file.
My client wants a user to fill in an on screen form and then have the results merged into a pdf template?
Granting that I have 2 recordsets with the same columns, is it possible to merge these two recordsets?
rs3 = rs1 + rs2 ???
Can someone show me how?
i have to merge 2 different images and save them as one individual image. I manage to overlap both images together in the same position but i'm having problem in saving the images as a single image. i hope anyone can help me with the problem.
View Replies View RelatedI have two tables:
customermaster (id,name,email,mailinglists)
example: 1,john doe, Join Bytes!, NULL
emailmaster (email,listid)
example:
Join Bytes! 1
Join Bytes! 8
I want to get rid of the emailmaster table and merge the listids, into the mailinglists field inside customermaster so that I will have something like 1,8,14,25,99 in the mailinglists field for the email address Join Bytes. How can I accomplish this for MS SQL database?
I have a single table.
ID Code Description Colour Qty
1 0001 T-Shirt Black 5
2 0002 Soccer Ball Red 1
3 0001 T-Shirt Black 2
4 0001 T-Shirt Navy 6
What I need to do using ASP is take record 1 and merge it with record 3. By this I mean I need to show only a singular qty for the product code 0001.
i.e.
ID Code Description Colour Qty
1 0001 T-Shirt Black 7
2 0002 Soccer Ball Red 1
4 0001 T-Shirt Navy 6
I would like to sort my XML output and still be able to manipulate/alter/modify the XML data by use of some simple ASP code. (I’m going to slice it afterwards, and bake it in to a cornbread. But that’s a story for the cocking forum I’m a member off.)
I’ve no idea if this is ever going to work, but here is what I did.
- I’ve got an XML file; data.xml.
- I’ve got an XSL file; xmlxsl.xsl
The only reason I’m using a XSL file is because (I think) it will enable me to sort the XML data ascending. And of naturally a ASP script to merge al those files together and then to slightly modify the XML output. Code:
I want to merge a word document in the server to display in the client side. The merge code is in a dll. In the asp server script, I invoke the dll to merge.
It raise an error when I use the default IIS user. When I change the IIS user to administrator,It work well. how I should do to resolve this problem?
I need to take a bunch of PDFs that I have made using Appligent's FDFMerge and append them together. I know I could use Appligent's AppendPDF. But I was wondering if there were any free toolkits that I could use with a bit more work out there?
I cannot tell what on the Adobe site would be a candidate for me to even look at. The Acrobat SDK seems to be for Acrobat Reader plugins. Not what I am going for. The PDF library seems a candidate, but what *is* it? A C library? I cannot use a C library unless it has a COM wrapper.
I am working with an old line-feed printer text file. There are characters in the first position of each line that tell the printer what to do, i.e. print this line and advance paper, print and do not advance. when processing this text file for conversion to another text file I can't seem to work out the code for merging two lines. For example,
Type: Location: Quantity:
+ 123 London 45000
After processing the line should look like this:
Type: 123 Location: London Quantity: 45000
I understand the concept but have no idea how to actually merge the two lines with code.
I need some help: with cdosys i'm able to send e-mail from asp using the local exchange
server. Now I also have to save the sent mail into the user's mailbox for future reference: how to?
I'm using:....
I'm using CDO to send mail to the site owner from ASP pages with forms.
Recently one of my forms is occasionally sending email with what seems
to be an insertion which is replacing the plain text part of the email
with something else. Looking at the server sent email source, the
hacked emails have the following:
Here's the scenario. I'm currently using cdosys/asp to send mail to
our SMTP server. We use a product called MailFilter to check for SPAM.
It doesn't work very well. If MailFilter isn't working cdosys also has
problems and emails don't get sent. As these email are confirmations
for customer's bookings this means lots of customers calling to see
where their confirmation emails have gone. The root of the problem is
MailFilter but that here to stay. So I had this thought of sending the
message to a queue of some sort so at least they will get to the
customer eventually rather than being lost for good. So here's the
question:
Can I/How do I send messages to a mailbox on our exchange server using
cdo.message?
I'm using CDO from my vb component to fire email. The problem is
whenever one of the email addresses in to, or cc is wrong then none of
the mails are fired even to the correct addresses. It gives an error
like
The server rejected one or more recipient addresses. The server
response was: 550 Relaying denied for <xfd@wre.com>
My code goes like this. Why is the mail server trying to look for the
validation of email ids??I want that atleast the mail should be fired
to the correct email addresses rather than no email fire. Can i
achieve that.
Dim iMsg As New CDO.Message
Dim iConf As New CDO.Configuration
With iConf
.Fields.Item(cdoSendUsingMethod) = cdoSendUsingPort
.Fields.Item(cdoSMTPConnectionTimeout) = 10 ' quick timeout
.Fields.Item(cdoSMTPAuthenticate) = cdoBasic
.Fields.Item(cdoSendUserName) = "username"
.Fields.Item(cdoSendPassword) = "password"
.Fields.Item(cdoURLProxyServer) = "server:80"
.Fields.Item(cdoURLProxyBypass) = "<local>"
.Fields.Item(cdoURLGetLatestVersion) = True
.Fields.Update
End With
Set iMsg.Configuration = iConf
With iMsg
.To = strToEmail
.From = strFromEmail
.CC = strCCEmail
.BCC = strBCCEmail
.Subject = strMailSubject
If strMailFormat = "TEXT" Then
.TextBody = strMailBody
Else
.HTMLBody = strMailBody
End If
If strAttachment <> "" Then
.AddAttachment strAttachment
End If
If intPriority = 2 Then
.Fields.Item("urn:schemas:mailheader:X-Priority") =
cdoHigh
.Fields.Update
End If
.Send
End With
I'm building a website using the oracle database engine. i'm conneting
to the database using the odbc. the database is created on a webserver.
when i'm using the odbc on my local workstation the connection works.
but when i'm trying to publish the site i receive the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specified driver could not be loaded due to system error 5 (Oracle in
OraHome92).
/arabic/news_index.asp, line 46
line 46 is when i'm opening the connection.
Note: what i mean with "my local workstation" is when i call the
website using the localhost. and i mean by "publish the site" is by
giving the website a dns name.
When I place a record set on an asp page designed in dreamweaver. I get the following error when i try to run d page.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Specified driver could not be loaded due to system error 127
I am connected to the database i can see my tables i was able to make a record set but when i place it on the pace and try to prview the page in internet explorer i get the above error. I have used oracle 10g to create the database.
i would like to ask what is the best and easiest way to connect an ASP application to an ORacle database? i will be accessing the database server from our network. do i still need to install anything in my local pc?
View Replies View RelatedI know how to connect with Access.How can we connect ASP with oracle without mentioning the Data Source Name?
View Replies View RelatedI written a procedure in oracle which returns a value. What all I want to do is to hold the value in a ASP vairable. The Oracle procedure,
create or replace procedure tat
(j out number,i in nnumber,k in number)
is
begin
j:=i+1;
end tat;
I need to get the value of j in a variable & how to pass more parameters. i need this to be handled in asp i will pass through request form and call the procedure, and the procedure will return a value that also has to be hold.
My asp application is connect to oracle database. However, when i try to open the default page, an error occurs and i receive this message:
- Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'MoveFirst'
The code that is causing this error is following:
Code:
<%
Dim objConn
Dim rsForums
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "dsn=ORCL9; uid=toy; pwd=yes;"
Set rsForums = Server.CreateObject("ADODB.Recordset")
rsForums = objConn.Execute ("SELECT * FROM Forums ORDER BY Forum ASC")
rsForums.MoveFirst
%>
<table width="100%" align="center" cellspacing="0" cellpadding="6" border="1">
<tr>
<td width="60%">
<p><b>Forums</b>
</tr>
<%
While Not rsForums.EOF
%>
<tr>
<td><a href="forum.asp?ForumID=<%= rsForums("ForumID") %>"><B><%= rsForums("Forum") %></B></a>
<BR>
<BLOCKQUOTE>
<%= rsForums ("Description")%><BR>
<SMALL>[Total Posts: <%= rsForums("Posts") %>] [Last Post on <%= rsForums("LastPost") %>]</SMALL>
</BLOCKQUOTE>
</tr>
<%
rsForums.MoveNext
Wend
rsForums.Close
The forums table in the oracle database has 2 lines of records, and it should not occur this error. Do you have any idea what is happenning?
Can I connect oracle using asp?Is it possible?I have done it with msaccess and sql server 2000 before. Can you guide me to create a connection with rdbms oracle with asp.(with dsn or without dsn)
View Replies View RelatedI am trying to write a simple SQL statement which will take a string
(startdate) in the format DDMMYYYY and compare it to a date stored in
an Oracle database. My SQL is as follows:
<%
"select * from tblhistory where datechanged = '" & startdate & "'"
%>
The field datechanged in the Oracle database is set up using the
Sysdate variable, on a previous occasion.
I have a big problem here ....i have an oracle pakage and i need to call this package in ASP , when i use "microsoft odbc for oracle" it work fine .
But now we need to change the odbc to "Oracle in OraHome92" ...so evrything in the package call must be change. any one can help me ?? how can i call this package via this odbc driver and how i can retrun a record set from the package?.
i searched the web for a code to connect an 8i oracle database with the ASP and i didn't find anything useful untill now . So if any one can help me in this i will be so greatful , also i wanna know if it is possible for the PWS or is it only working with the IIS
View Replies View RelatedOn User Logout,I Close my Asp Application Browser Window,
and attempt to shut down oracle database.
The window closes, but Oracle Shutdown displays
"Stop Active Connections".
Can i avoid this window ? I am not using global.asa.
The following is my logout code :
<%Session.Abandon()%>
<script language="JavaScript">
parent.window.close();
</script><%dim Executor
Set Executor = Server.CreateObject("ASPExec.Execute")
Executor.Application = """E:ORAWIN95BINOSTOP73.EXE""/screen"
Executor.ShowWindow = false
Executor.ExecuteWinApp
set Executor=nothing%>
I am trying to connect to Oracle 9i Database Installed on Win 2000 Server using a DSN and i am getting the foll error :
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC driver for Oracle][Oracle]
/test/includes/openconn.asp, line 7
No error description
The line 7 is where I am opening the connection using
objConn.open "Dsn=test;uid=xxx;pwd=xxx;"
I am able to connect to the Oracle 9i Database using my SQL Plus and also thru Oracle Management Server
Does anyone know how to return data from an Oracle pakage using Oracle driver?
View Replies View RelatedAnyone have any good links on accessing the paging methods in the Microsoft ADO when dealing with Oracle? I've tried just about everything I know, and I can't get those methods to work worth a diddly. Code:
View Replies View Related