Is there any way to check that database connection has been established or not ( ASP connection with oracle)
am using this connection
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=MSDASQL;DRIVER={Microsoft ODBC for ORACLE};UID=nnn;PWD=nnn;Server=yyy"
Anyone got much of a clue how best to send emails to selected people from a database table and to be able to track them, maybe as much as a read receipt, or perhaps just checking that they don't bounce, or end up in the bad mail folder.
Is this best/possible to try and code or is there a free/cheap component that does this simply.
Anyone over here ever Migrated WebWizForum from Access to MSSQL?
View Replies View RelatedI use an asp page to upload a word document to the web
server (with Soft Artisans SA file-up), but sometimes it
doesn't respond, seems to return with a zero sized answer.
I use IIS 6 on Windows 2003 Server and I use this machine
as a client too. The communication goes throught ssl
channel, HTTPS by certificates. If I use Windows 2000 as a
client from another place (that case there is a firewall
between the client and the server) sometimes the same
incident happens, but the Internet Explorer shows
the "Cannot find server or DNS error" message instead of
the blank
response. The problem happens independly of the parameters
which I fill in the form and independly of the file what I
choose. Sometimes the document uploads and sometimes not
with the same parameters. I cannot define the cause
exactly .
I have an Intranet-based app at work, and I have it in two places there: a
dev machine and a production box. In both cases, the ASP files and SQL
Server 2000 database are on the same box. I have it running smoothly in both
places at work.
However, I've been trying to set it up at home, and cannot make the SQL
Server connection work for some reason. I've been working on this off and on
for weeks, and I just don't get what I am missing. Code:
error '80004005'
Unspecified error
when sending an attachment, how do i debug this?
i found out that by default, ASP apps can only access files that are on the computerthat the server runs on. how can i change this so the IIS will take the files off the client's computer?
With the following code snippet:
<%="complexid =" & rsComplex("ComplexID")%>
<% rsPhoto.filter = "complexID =" & rsComplex("ComplexID") %>
<%response.Write("<br>ID: " & rsPhoto("complexID"))%>
I get an 80020009 error on the last line.
The first line appears in the HTML output as complex=589, so I know
that there is a valid value available for the filter.
This worked once and hasn't worked since.
The rsPhoto recordset is viewable in a seperate page. The complexID in
the associated table has a value of 561 in the complexID column.
I am trying to do a very simple piece of asp on a w2k3 server on the company intranet where i work (using IIS 6) the code is simply trying to get an xml stream via a ServerHTTPRequest.
The code I have works absolutely fine, I have tested it on a free asp friendly server on the net and it does exactly what i want it to! however when I run the code on the company intranet I get hit with the following problem.... Code:
I've create a custom com object and I use it as follow:
set test = Server.CreateObject(myObject.classID)
' --> all OK the istance of the object is correctly created
retval = test.function1(par1, par2 ...)
' --> as soon as I call every function of my com object the system returns
the following error: 0x8000FFFF: catastrophic failure.
I do not know why
to some mail accounts, I can't send mails to them?Whoes fault is this?
the part of code is as follows.
<%
set mail=server.CreateObject("cdonts.newmail")
mail.To=aaa@aaa.com
mail.From="system@aaa.com"
mail.Subject=today & " New Messages"
mail.Body="<html><body><a href='http://admin_main.asp'>go message
board</a></body></html>"
mail.MailFormat=0
mail.BodyFormat=0
mail.Send
set mail=nothing
%>
i have a variable called newvalue1 which contains a date such as
newvalue1 = request.form("tf1")
where tf1 is the date sent from the previous page in the format 4/5/2005
now when i give the following statement it gives an error
objrs.find ("date") < newvalue1
"Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."
also if i give:
objrs.find ("date") = newvalue1
i get a " type Mismatch" error
any thing wrong?
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'm having a bit of trouble with an ASP form that I'm maintaining. Someone else wrote it and I'm new to CDO objects. I have a CDO.Message and a CDO.Configuration.
I set up the configuraton fields for the port and smtp server's ip address to be used. The configuration property of the message is set to be the new configuration object.
Then there's a ton of stuff appending bits and pieces to the text body.
Finally we have the message's Send method being called. That's where it breaks.
It seemed to just stop working one day. When I submit the form, the message returned is simply:
error '8004020f'
I know from the MSDN website that this error code means 'Failure in obtaining user token.' What I don't know is how to fix it!
I have this table that has two columns Department and RecId. what I am doing is I need to give access to different people in different departments. So if I am in billing I say billing 76 which is my rec id and than if I also need acess to accounting I say Accounting 76.
So now in my asp page I open this records set to check and see who has access to what departments and give them the access Code:
I want to check whether the value in recordset is "=> 3 ".
I try "If rs => '3' then...".
But it doesn't seems working. Can I can't check the condition by using the recordset like how i written above?
Or do I need get the value in recordset and assign to a variable in order to check the condition. Please advice.
Let say my rs now stores a value of "2". Can I check with the following code.
[code]
set rs = server.createobject("...")
rs.open "Select...", objconn
if rs >=3 then 'THIS LINE DOESN"T SEEMS WORKING
....
[code]
I want to do some error checking using on resume next to determine whether to commit an ADO transaction. However we have a custom 500 error page which we use through out the rest of the site. Can I remove the on error resume next after I have rolled back the transaction and raise a normal error.
View Replies View RelatedI'm trying to qualify email addresses. Is there any reason why the following line would not catch an email address beginning with "www." ?
ElseIf Left(Session("em"),4) = "www." Then
I put in a dummy email address: www.mydomain@aol.com and it goes through....
<%=Left(Session("em"),4)%> does reflect "www."
why?
Is it possible to have an ASP page which checks if a user is in a certain group in Active Directory (AD). For example jbloggs is logged in and belongs to the group "project_allowed". When jbloggs goes to project.asp it will allow him access
However when jsmith is logged in and belongs to no groups and tries to access project.asp it will deny him access.
The script is designed as a form validator which checks fields for various criteria and then sends a mail with the form contents. Since 40 different forms will be plugged into this script, there needed to be complete seperation between the two.
I've managed it so far by checking for required fields by putting the word 'required' into the name of the field. The script then sources out any fields which has this text and checks them to see if they are filled out.
The problem I've come across now is that I need to check for field length. My idea was to put the amount of characters needed into the name of the field in the form and then have the script check with a Reg Exp. However, Im not too sure of the regular expression needed to check for this.
Can someone suggest one? The one I have at the moment is [1-14] but say I had a field like this: <input type="text" name="passwordrequired12"> That would match bout for 1 and 12. Any ideas?
How can I check whether a variable is set as a value, integer, etc .. ??? (So that when a user submits a value via a web form and its a letter, i can give them an error note.)
View Replies View RelatedI am writing a script that lets me brows the contents of a web server. The problem is the account that is running ASP does not have permissions to every folder. Don't ask me why ... I have no idea but it can't be changed.
What I would like to do is perform a check for:
Microsoft VBScript runtime error '800a0046':Permission denied
And if this happens display an error message saying they do not have permission to view this directory. Code:
How can I write an asp page, say, CHECKIP.asp that checks the incomin
requesting IP address and returns a protected page, based on th
checking result? That is, if the IP is a permitted address, the
presents a page, say, OK.asp. If the IP is not allowed, then send
REJECT.asp. Both OK.asp and REJECT.asp cannot be directly accesse
without going through the CHECKIP.asp.
I am a somewhat beginner in ASP. I would like 2 know how do I check whether a recordset, that was fetched from an MS-ACCESS database through a 'SELECT' query, is empty or not??
The scenario is that I m making a form where users can register for my message board. The form will take in all the details and pass on to another asp file which checks whether the username is already in use or not. If its in use then it says that Username in use else the page is displaying error.
I m using the following sql.
"select * from members where user='" & username & "'"
The error is something like record cannot be found. Either EOF or BOF or the record was deleted.
win 2k pro
sql server 2k
asp - vbscript
I got the below code from somewhere ages ago. I have a list of links on my site that link to other sites but I want to check if the link is a valid link automatically and if it fails after x checks (checks every 7 days) then to mark the link as a possible broken link
the below seems to take ages to process and was wondering if there is a better way to do the below. Code:
How to re-write this so it can error check for each individual field. Username, email, password etc.
This is written and validates if the user already has an account in the Database. then it returns the messaage below. But I would like to indentify if it is the username that exist or the email or password. Code:
i wanted some help in the bewlo subject i tried in different code but some time it is showing wrong error.is anybody give me the example or site linke where i can donwload the the password checking script from database.
I have pulled data from database and shown those user name in suer tab ( drop dwon box) user need to select the his name and to type password.once user type the password it should check with database . if it exists then it should capture that user name and move on to next page.
I have a simple question. Can you check if a number has been passed through a form? For example I making a website for a property letting company and they upload the property themselves. But if you you put in text into the rent field, it throws up an error when adding to database obviously.I do validate the in put before adding it to the database so was thinking about another IF statement checking that a number was entered before they get as far as adding to the database and throwing up errors
View Replies View RelatedI have a value in a field. The field name is Advice.
The value in this field is "abcdef"
I want to to add the value "ef" to that field only if "ef" is not already in the sequence.
If "ef" is already in the sequence it won't add it.
If i change the value manually to "abcd" when i run the code it will see "ef" is not there then add it so the field now lists "abcdef"
This is the the pseudo code:
A member logs on and enters a record, if one already exists for that date, then they get a message saying so. If not the record is added and some text is displayed. But it still allows me to enter records even if one already exists! is it because I am storing my dates as strings? Code:
View Replies View RelatedHow do i check the format of the field I am reading from a Excel table. I'm using a adodb connection to query an EXCEL/ACCESS table and display it on browser. Is there any way to check the format of a particular field that is bieng read.
For example how do i check whether a field that is read is in date format...?
I just want to check that i'm not going crazy.. I want to check
whether or not a cookie has already been set and so I am using the
following code.
cookieValue = Request.Cookies("CartID")
'if cookie hasn't already been set, then set it!
If cookieValue = "" Then
Response.Cookies("CartID") = "3"
Response.Cookies("CartID").Expires = "Jan 1, 2005"
End if
I have also used IsNull yet both just don't seem to work.... am I
missing something here?
I have a url containing query strings, e.g.
http://domain/page.asp?one=VARIABLE
I would like to be able to check what the variable is, for arguments sake,
the letter 'a' or the letter 'z'.I have sent the query string to this,
stringone = Resquest.Querystring("one")
Then later on, I wanted to write different things depending on what the
query string returned.
IF ---the stringone IS the letter 'a' THEN
DO THIS
ELSEIF -- the stringone IS the letter 'z' THEN
DO THIS
END IF
but i dont know how to check whether the string is = to the letter 'z' or
the letter 'a'.
We need to spell check Text Areas in our ASP pages. We don't want to use MS Word. We are looking for an cost-effective, easy to configure and use, well-known COM-based Spell Checker component.
View Replies View Related