I have a recordset connection in asp that I am using to search records.If I use the client side cursorlocation (rs.cursorlocation=3) then it takes really long to return back the records due to which a timeout occurs.If I change the cursorlocation to adUseNone(1) or adUseServer(2) then the search is faster and without any problems. But the sort on records cannot be done if I use adUseClient(3).
I need to have sort on these records. I am using dynamic server side cursor.Also my result set is not huge ..just 80 records.One more thing that is wierd is that the result set comes back instantly for the first search,but takes forever when searched again for the same criteria. Eveytime I logout and login and do the search for the 1st time the search is quick and takes forever for consequnt searches.
I have an error with Cursortype this is the error again ADODB.Recordset (0x800A0CB3) Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. /titans/Private/Edit_update.asp, line 20
Now after researching this error it says that access does not support cursortype = 3 is this statment true and if so, how do I go around this.
I have just uploaded my site and now when i connect i get this error:
"ADODB.Recordset error '800a0cb3'
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype. "
any ideas as to how i can fix this - surely i thought that my hosting company wouldn't habe a problem with the cursor i am using - i emailed them yesterday and they are - "working on it"
I have a logon field. When data is entered, the user is taken to a protected page. The problem/question is: Whe you click the back button and return to the logon page,the user data is still in the field. I want it cleared when the user returns to the logon page.How should I approach this problem. Java?
How would i have the first text area on a form have the text cursor alreay set in it, so that if a user is unable to see where the first box is or is only using their keyboard they are still able to fill the form in. I have the tabindex already set up, and i know you can set the cursor in a box when the page loads as i have seen it on loads of form pages and find it useful my self.
I have an ASP page that acts as a log-in page. THe user is instructed to input a password. I was wondering if anyone knows how to default the cursor to that input box. This way the user does not have to move the mouse and place the cursor in the input box, they can just start typing a password.
1. How do I set initial focus on a specific textbox? I dont want to tab to it. 2. How do I make a sepcific button the default that is submitted when I press enter? I dont want to click or tab to the button.
I have one of the most perplexing problems that I've ever seen! I have an application that simply wants to add a record to a recordset. My setup for this is as follows: (using MDAC 2.8)
set rsu=server.createobject("adodb.recordset") rsu.CursorType = 3 SQLString = "SELECT * FROM TASDISTRICTS ORDER BY TDID" rsu.open SQLString, cn, 1, 3
Here's the scoop - when this code is executed - the CursorType turns back to 0. I use this code for all of my hookups and have never had any problems. It is currently running fine against a different SQL database. So that is how I have funnelled this problem down to the differences in databases and permissions. However, I see no differences between the two.
I am just starting in asp and would like to get an image to follow the cursor (ie if the cursor was at x=100,y=100 then the image would be x=10,y=10) and would move as if locked to the cursor.
i m developing client server application but facing problem is that which lock and cursor i use if person in site A enter or updating record. That can person at site B cannot use record until lock or cursor is released.
I'm building a text file from a database table using the ASP Write Method and would like to position the cursor in a specific column position before writing the fields. As I loop through and write the fields into strings of rows, I want to be able to put field1 in row1/column position1, field2 in row1/column position10,.....etc.
I've included the basic code to write a string of text. I understand the process of how to write the fields and loop, etc. If you would be kind enough to just show me in there the syntax for positioning the cursor before the write I will then apply it to my code:
I am trying to expose a table from a packege in Oracle. I am using a Oledb Connection. I only know how to see the data using a Packege with only inputs parameters. When i use a output parameter it is do nothing..
i m developing client server application but facing problem is that which lock and cursor i use if person in site A enter or updating record .That can person at site B cannot use record until lock or cursor is released.
I'm using the following function, which uses a recursive call. every time when I get a conf it opens a record set. So increases the cusor count. Some times I'm getting the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC driver for Oracle][Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded.
We are receiving an error in our ASP website that used to run fine on our old servers but seems to be struggling on our new ones, I'm wondering if you've seen this error before?
Microsoft Cursor Engine error '8007000e'
Out of memory.
/oob/activities/default.asp, line 470
The last line that shows where the error happening is different on every page but it appears at the first database connection on each page.
The only way to get rid of the error and get the site working again is to recycle the application pool for the site (or restart IIS).
We have two servers, one running IIS and the other running MSSQL 2005. Both are the following specs:
Windows Server 2003 HP DL385 Single AMD Opteron / Dual Core 2214 4 GB DDR 146 GB SAS 146 GB SAS SCSI RAID controller
I'm completely lost on this one, as the code has not changed at all between old and new servers so there must be a config setting I've not migrated across somewhere.
The most bizarre thing is that other sites on the server are unaffected, once this out of memory error hits this site on the server all other sites still run and connect to the same database without any problems at all.
I have a client application that uses web services. When the client application an web services are in the same machine, they work fine. But when the application call the same web services hosted in other server, the server return: Code:
I am using frames in html. How can i redirect to an asp file in a new browser window.So that the redirected page opens in new window instead in a frame.. Code:
Is there a way to set the location where the input type="file" option gets its files from. I know you cannot set a default file, but is there a way to set where it starts looking.
tell me anything they know about locating WAP users. I assume that there must be some information on their current cell sent in the WAP request headers, but i'm not sure. I want to make a WAP site that appears differently depending on the users cell location.
This is a dumb question but i am just starting out with ASP. I am working in vbscript and i am trying to do a OpenTextFile the problem is that i am editing my page on a different computer from where the server is. I know that if i were trying to open the file from the server i would type:
I am use to the include file on classic asp for maintaining MS Access database location. On using Visual Web Developer Express, I can only use the MS Access database if it is located on the same folder with the web app. Is there a way that I can locate MS Access as my database but the location is not located on the web application?
We have special kind of service that covers just north on America (US and Canada), so we want to redirect users comming from another country to another page.
I am looking for a web service or similar thing that tells me the country and state/province of incomming IP address. I am sure it is possible but i don't know who sells that service.
Could anyone refer me to any resources related to that ?
Is it possible to get the filename, and more importantly the path, from inside an ASP file, when that file is included? I know it can be done for the base file using Server variables, but I can't figure out how to do that for an included file.
I need to write an application that uses include files, and that may be moved to another folder on the server...