When some of the SQL Server stored procedures I have written are called via my Classic ASP page I have written I get the following error in the cell that is supposed to be retrieving a single result:
"ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/Default.asp, line 130"
I have no idea why this could be occuring. Some of the other stored procedures work just fine. Any one have any ideas?
My web site HTML comes from a database via querystring e.g. page.asp?pid=55. I have a separate asp search page, search.asp. Its output is retrieved by an ajax call from page.asp and its HTML is then neatly wrapped and styled by page.asp.
I want search.asp to recognise if it is not being called via ajax frompage.asp, but directly e.g. via the address bar (and if so, redirect to page.asp). Do I need to put something into the posted string, or (better) is there an asp method that can do this?
The ajax call is function GetSearchPage(st) { var poststr = "searchterm=" + encodeURI(st); makePOSTRequest('/search/search.asp', poststr,'divFullSearchDisplay'); }
Is there a way to detect when this function has finished execution as i want to page a page loader on the page until all the HTML is build and ready for rendering? I have the page loader in a div so when the above function finishes i would like to disable or hide it via Javascript. That bit is fine it's just the how to send a call to the Javascript so the DIV can be hidden is the problem.
I have a logout button for my admin system. I really need on logout, to go back to the login page. This is fine but I also need the session set to false. I could do this via using a secondry page called logout.asp, and place inside that something like session.abandon and a response.redirect. But I do not wish to have a secondry page.
my web application has user name and password, whenever user logged in i set his status in database as 1 so that only one user can logged at one time with same login and i write a code to set status to 0 on logout menu, but if session expired then status will remain 1.
i have written code to set staus to 0 in onSession_End sub but it not work all the time. Sometimes it works and sometimes not. So i m looking for an alternative way of doing it
I have tried and tried to "include" this in the blogger template, so that I can update the menu dynamically, without fiddling with a cumbersome blogger template all of the time.
The question is, does anyone know how I can "call" this file in to the template successfully?
I don't know if this is a truly esoteric question, or not, but I'm wondering how (or even if) you handle a timeout on a transaction within a stored procedure executed in a Stored Procedure?
A theoretical example of the stored procedure (sadly, I'm not allowed to post the actual code):
Create proc sp_testproc @myval int, @outval int OUTPUT as
begin tran
select top 1 @outval= myname from mytable where recid = @myval
update mytable set myname='xxxx' where recid = @myval ...
This is a mix of technologies so I hope I've put this in the right place.
I have a system where people can sign up to a data feed. They place a single line of Javascript on their web page and a formatted banner of products is displayed based on the options they have chosen in their affiliate account.
The original system was built by our developer 3 or 4 years ago, and worked fine. However, he built the system using two ASP files - feed.asp which looks like this:
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp. /CoxAxis/adminEditPage.asp, line 6
My code:
<% dim self, pid, i, c self = Request.ServerVariables("URL") pid = Request.Querystring("pid") set Session("pageContent") = Server.CreateObject("Scripting.Dictionary") Set custObj = Server.CreateObject("NFIFunctions.ValidateField") Line 6 set psi = Session("pageContent") set errDict = Server.CreateObject("Scripting.Dictionary") i = 1
Let me start by saying I'm fairly new to Asp coding. That said...
My ISP only uses AspSmartMail. I've created an online form that uses fill out, which is then e-mailed to the collector of the information and CC-ed to the person who submitted the information.
The error I'm receiving is this: aspSmartMail.SendMail : Error 28 error '8004001a' 504 Invalid Username or Password
In my script, I've Dimensioned several items, as you'll see below, passing the authenticating username/password to the smtp server, but it's not working. I tried not passing the information by entering in the actual info without it being passed by the diminsioned items. This didn't work either. I of course verified that the username/password I'm usine is correct.
Can someone plase tell me why I can't authenicate? I would really appreciate any help that might be out there.
Relavant Asp code below: ----------------------------------------- Dim smtpserver,youremail,yourpassword,yourusername,rem oteemail
I have a database driven (ms access) website which runs fine on my computer (win 2000 iis6). However, on uploading, some pages am receiving the following error
"An Unknown script error occured while processing your request."
I am testing a new website I built on the actual server. My section for uploading documents seems to be giving me problems. Can someone help me please? This is the error I am getting:
Microsoft JET Database Engine error '80004005'
'c:logindatairb.mdb' 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.
This New Company I'm with Sets their Default WebSite to a local Directory on "D" Yea I've been down the whole route reinstalling XP Pro,,, IIS 5.1 The .NET framework everything. Now I'm just frustrated.
What the Heck !! Theres a web project (C# ASP.net) in the solution containing many many some odd 19 or so projects. MSVSS is additionally in the picture to make things a little more complex. (I.E. the non web projects go elsewhere on the D drive) All I'm asking for here are the BASIC Settings to get my DEV environment and my IE to "SEE" this D:Web folder as Localhost. It worked for a sec. A very brief second. Then it was Gone. Specific ERROR:
Could not load type 'appname.web.Global'. Parser Error Server Error in '/' Application.
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.
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).
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.
I had developed a messageboard in asp which allows users to post new messages,reply to existing messages.I am using textarea (Html tag) for a messagebox in my asp page .When the user enters any characters in messagebox except a single quote ('),the message gets inserted in oracle database without any problem.But if message contains single quotes (') , while inserting in a database it gives the following error
"Microsoft OLE DB Provider for Oracle error '80040e14' ORA-00917: missing comma ".
Is there any solution to insert messages containing single quotes in a database?
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'.
I tried to display an error detail on my webpage when I got an "HTTP 500 Internal Server Error" of my .asp page, but I was failed I did setup in IIS so it will display debug error on my asp page as well as setting up my browser internet option.
Can you help me how to set it up so I am able to see the error detail on my browser when I get "HTTP 500 Internal Server Error" ( Currently, I just got a blank page with "HTTP 500 Internal Server Error" in the web page title)I run IIS 5.0 and window professional xp browser.
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:
