Trapping Odbc Error
I have a data-driven website that allows users to enter records for sales leads. It all works perfectly. The only thing I want to do right now is prohibit users from entering the same lead twice.
I have a PK field in the MS Access database that, obviously, disallows duplicate records. However, when such an attempt is made, the browser
redirects to some generic ODBC error page with some cryptic numbers and other information that will stymie the users. "It doesn't work", they will say. The text of that error indicates that they tried to add a record that violates the PK rule of disallowing duplicate records. But they probably won't read it and it's truly ugly anyway.
How can I redirect to a custom error page or trap the error before the ODBC error page is displayed and just display a msgbox or something telling the user they attempted to add a record that already exists?
View Replies
ADVERTISEMENT
Need help with some basic error trapping. This code traps the error and successfully redirects to the error handling page.
If Err.Number <> 0 Then
Response.Redirect("../main/ErrorHandler.asp?error=noconnection")
End If
On Error GoTo 0
I meant to use this code to send myself an email with error details but it is not working. I get my nicely formatted email but instead of error values there is nothing. Why would all Err. be empty?
I suspect that the problem is with the error occuring on one page but actual handling of the error is meant to be on some other page but I am not sure here. Code:
View Replies
View Related
I'm using the MSXML2.ServerXMLHTTP object.
I am pulling documents (PDF, to be exact) from a remote server, and it all seems to work fine. However, I cannot control that particular database in which the documents are stored.
Currently, the DB where the documents are stored is down, and when I use the object above, naturally, I get the 500 error(my error log states that it's a timeout). How can I write a custom error message to display in a browser, instead of the usual HTTP 500 Internal server error page?
The code I have is below ...
View Replies
View Related
i want to perform error trapping on the connection to a server,so if the SQL server is inaccessible the site does not crash.I'm using javascript and hoped the try.catch might work.this is want I've tried in an existing piece of ASP script:
%>
try
{ "<%strTRSConnect.Open App_TRSConnectionString%>";}
catch(e)
{ alert("Error occurred ::::" + e.description) }
<%
where App_TRSConnectionString is declared elsewhere. It still attempts to connect and because i'm testing with an inappropriate connection string the page crashes.
View Replies
View Related
how to get IE to report the line number of the error in the source file, when an error occurs? at the moment it just gives me the error number '500'.
View Replies
View Related
i need the best way to catch any error on a specific page.
i have a page that connects to a database on an AS/400 and there is a possibility that a certain condition might exist on the 400 that causes my page to bomb. i have no real way of specifically testing for this condition (not easily anyway) so i just want to write out a general error message if ANY error occurs on the page since it will be very rare.
View Replies
View Related
Is it possible with "classic" ASP to set up a process where anytime someone encounters a server-side error, it will e-mail the error message to me? I know I've done this with .NET, just can't remember exactly how.
View Replies
View Related
I have a mail script but don't know how to catch any errors so that it will display email address that failed to send. Here is my code...
Dim mail
Set mail = Server.CreateObject("CDO.Message")
mail.From = "from@mail.com"
mail.Bcc = "bcc@mail.com, bcc2@mail.com"
mail.To = "to@mail.com"
mail.Subject = "This is the subject of the email"
mail.HTMLBody = "I am the message that will be displayed in the body"
mail.Send()
Set mail = Nothing
How can I display a message that says that there's an error with sending the mail?
View Replies
View Related
My problem basically is as follows:
1) User enters their details to create a new account in my db.
2) They press the submit, the system successfully creates their new account
and then displays a page saying 'well done you've created your new account'.
3) The doofus (or clever clogs) clicks the Refresh button, which in turn
submits the details back to the db and creates a duplicate entry in my db.
I don't have a duplicate account num, as the system takes the max last one
and adds one to it so really no errors are generated, but it does mean that
they have 2 accounts now.
As mentioned above, this scenario crops up when doing a New Account page and
when they've just posted their order via the shopping cart final page (shall
we say). The latter worries me because duplicate orders would cause a lot
more hassle.
View Replies
View Related
how to trap the error if the cause is the concurrent user. from iis server my 500-100.asp page is coded to trap errors that came from crytal report. below is the code that has been used.
if instr(lcase(objASPError.file), "rdcrptserver11.asp") <= 0 then
SendEmailNotification objAspError
end if
this piece of codes means if theres a error from rdcrptserver11.asp it would send a notification to me right? what if i dont want to get email notification if ther error is exceeding the concurrent user. what would i do stop the sending of notification when that happens.
View Replies
View Related
My text file, dsn file, and asp page are all in the same directory on the web server.My problem is that I want the text file to be on drive U: (which is each users drive)When I do this I get the following error (even if I copy the dsn file to the U: drive):-
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Text Driver] '(unknown)' is not a valid path.Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
View Replies
View Related
I'm getting the following error on one of the servers I maintain:code:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL server has gone away
Always occurs when the MySQL server it connects to restarts, which is hosted on another box. Nothing but an IIS restart fixes it.Is there anything I can do to get ASP to automatically pick-up the connection, or force a reconnect? I'm not an ASP coder, so a little hand-holding would be nice (don't worry, I won't kiss you).
View Replies
View Related
I am getting this error after uploading an asp search page and attempting to search an MS ACCESS database.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x7d0 Thread 0x340 DBC 0x2870cd9c Jet'.
I've researched the error code online,and it seems to be server-side,but a lot of the server talk is pretty much Greek to me.
View Replies
View Related
I have designed my database so that u cannot insert duplicate keys. So when this happens, I get the following error:Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'pk_QuoteItem'. Cannot insert duplicate key in object 'QuoteItem'.
How do I catch this error and print a more user friendly error message?
View Replies
View Related
My asp run smoothly before. But, now, I found the ASP page is not smoothly recently.
Sometime if the ASP is requested to connect to Access, the page will prompt
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0xdd8 Thread 0xae0
DBC 0x3a85074 Jet'.
What's going on?
View Replies
View Related
I need help figuring out this Microsoft OLE DB Provider for ODBC Drivers error '80004005' error.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
register.asp, line 115
I created a simple registration form. It works for me but when i uploaded to a remote server...it doesn't work any more. The host said he made a System DSN connection to the registration.mdb database. Code:
View Replies
View Related
I keep getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
This error occurs at line 51, I have checked the line:
rsGlobalWeb.Open SqlJunk, dbGlobalWeb, 3, 3
There are 2 parameters already. So, I do not understand why the error keeps stating that I have too few parameters, and they expect 2, which I already have.
View Replies
View Related
This is the stubborn error I'm getting in my ASP code:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Function sequence error
It points to the line: lrsQuery.MoveFirst, as below Code:
View Replies
View Related
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Got error 127 from storage engine
/koun/MA_Report.asp, line 67
i have this error when i run my coding.......
View Replies
View Related
What is the meaning of this error?
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Incentive ODBC Driver]Incentive ODBC driver operation terminated. An error occurred Security Administration initialization. Code:
View Replies
View Related
I'm trying to update data to a mysql db, and this is the error that I get
Microsoft OLE DB Provider for ODBC Driverserror '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. /systemnotes/updatenota.asp, line 116
I don't know if in this part of the code is te problem
objNotas.Open SQL, DBConn, 1, 3
View Replies
View Related
I am struck with an error , please visit this url and lemme know what might be the cause of this error.
I am basically connecting to a remote mysql server via asp.
Code:
http://mcatva.com/testing/conn2.asp
View Replies
View Related
We have an asp script on an NT system that is trying to access a
database on an XP server. When it gets to setting up odbc, it gives an
error on that line in a particular function but doesn't give details.
I can map the network drive by providing username, but I can't use the
odbc to access the info. Any ideas? I set up security to make sure
that I can access it.
View Replies
View Related
I am using a piece of code to check for the existence of a username - password combination
within an Access DB, for a LogIn feature on my web page. Although this code appears to work fine on Windows 98, i keep getting the 'Too Few Paramaters' Error when i try running it on Windows XP.
Will Show you the code:
View Replies
View Related
I recieve the following error
Microsoft[odbc driver manager] data source name not found and no default driver specified
my code is as follows and works fine in excel . I have a user dsn set up called Sage and a system dsn called sage so don't think thats the problem
any help will be well appreciated
Dim sSQL
dim conn,rst
Set Conn = Server.CreateObject("ADODB.Connection")
Set rst = Server.CreateObject("ADODB.RecordSet")
//get error on next line
Conn.Open dsn="Sage", "TestUser", "correctpassword"
View Replies
View Related
Getting this strange error all of a sudden.
Microsoft OLE DB Provider for ODBC Drivers. error 80040e21
ODBC driver doesn't support the requested properties.
and the line is:
tRST.Open "SELECT id FROM " & sTable & " WHERE " & sField & " = '" & vValue
& "'", oConn, adOpenKeyset, adLockReadOnly
I'm using vbscript and this was working before I changed some tables and relationships, which should not affect the above line though.
View Replies
View Related
I recieve the following error
Microsoft[odbc driver manager] data source name not found and no default driver specified
my code is as follows and works fine in excel . I have a user dsn set up called Sage and a system dsn called sage so don't think thats the problem
Dim sSQL
dim conn,rst
Set Conn = Server.CreateObject("ADODB.Connection")
Set rst = Server.CreateObject("ADODB.RecordSet")
//get error on next line
Conn.Open dsn="Sage", "TestUser", "correctpassword"
View Replies
View Related
My server was JUST upgraded to 2003, the system had been running fine under 2000, but after the system crash I was convinced to upgrade - that's when it all fell apart. I'm not doing anything fancy with asp, just passing a couple of fields and obtaining the record from the database.
I can disable IUSR_computername and when it prompts me to log in, using the Administrator's password, the ODBC driver fires and connects to the database just fine.
Re-enable the IUSR_ and it goes back to giving the can't load error.It has to be a permissions deal, I just don't know for what directory. Any help would be greatly appreciated, server has been down now for 81 hours.
You can see the error (when server comes back online) at:
FinalFinancing.com/stnick/ebook.html
View Replies
View Related
I have this insert statement where instruction field in the DB is a memo field.
SQL="INSERT INTO int ([instruction]) VALUES " & _
"('"&Request.Form("myTextarea")&"')"
objConn.Execute(SQL)
Its giving me error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
View Replies
View Related
I get an email from an organization I developed a template web site for. They are offering the site to their clients. The site has two features, one of which is an FAQ page and another is a make an appointment page. Both use ASP, the FAQ sends a cdont email and makes an entry to an Access database. The appt. form just sends an email. Anyway, one member of the organization sent an email to say that when ever he submits an faq, he (and his friends???) get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
General error Unable to open registry key 'Temporary(volatile) Jet DSN for process 9x11c8 Thread 0x192c DBC 0x1796a9bc Jet
I went to the site and submitted an FAQ entry and it worked perfectly. Then, like a good little web master I Googled that error message and got this page -
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306518
This is where I need your help. There is something about a registry key but I haven't a clue what is to be done about it. The members at the organization can also submit the FAQ form, or so I understand they can, but the web site owner in Missouri gets the error. Can anyone shed some light?
View Replies
View Related
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[210.00]'.
bidProc.asp, line 100
strSQL="INSERT INTO bids(bid_amount,user_id,bid_item_id)"
strSQL=strSQL&"SELECT """& iBidPrice &""" AS Expr1, """& iUserID &""" AS Expr2, """& iBidItemID &""" AS Expr3;"
con1.execute strSQL'here is line 100
This code worked when I tested in on my own computer with iis on windows 2k. Then I uploaded it to the website and it returned this error. Any idea how to correct it?
View Replies
View Related
I have a dynamically generated update statement which has a rathe large IN clause making comparisions on an indexed and keyed integer field. Here's the code below: ....
View Replies
View Related
I'm running IIS 6.0 on my server 2003 machine and i'm hosting a simple website that reads off a database. I keep on getting the same error tho. I'm using a dsn connection (because i understand that a bit more) and the error message is as follows:
Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
[Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified
The thing is, i've made the system dsn for my database and assigned it the .mdb driver (I'm using Access). I'm losing my mind and a lot of sleep because of deadlines. Has anyone seen this problem before and does anybody know how to fix it?
View Replies
View Related