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.
A problem recently cropped up that I have not seen before and I am wondering anyone has seen this one?
The 2 SQl Select statements on my ASP page differ by the addition of one column ("Description") but in the 2nd case, column content is dropped (blank). I can get somewhat different results by adding other columns to the Select. Code:
I've got a SQL Server database, and am pulling records from it via ASP.Everything works fine, apart from the field which is stored as 'text' data type in SQL Server.If I change this data type to 'varchar' it works fine, but I need more than 8000 characters, so really I need the data type to be 'text'.Can anyone suggest why this might be happening, and how it could be resolved?
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 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 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'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.
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. ../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page: GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
I have it at the moment that on the main default.asp there is a recordset that will display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:
I have sql server express at my PC-windows xp professional, I try to connect to a table via asp (queryString :"Driver={SQL Server};" &"Server=localhost;" & _ "Database=local;" & "Uid=nikos;" & "Pwd=nikos;" but there is an error Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][DBNETLIB]"The SQL server does not exist or there is no permission.
I can login with EMS lite both with sql server Auth. and windows auth.What is fault?
I'm trying to install a simple e-mail form to my webpage; which takes some info from user (like name, phone, e-mail,etc...) and when user pushes submit button e-mails them to me immediately. I've tried to do so with ASP Formmail but I couldn't succeed. . it gives me: Server object error " 'ASP 0177 : 800401f3' Server.CreateObject Failed " error. Can anyone please help me to install my form? Because I need to install it immediately;
I need to read a SQL Server table into a Web Page and within the Web Page to permit my users to make changes to the records, delete or add new records and then save the entire contents back to the SQL Server table back.
The functionality I am looking is almost the same as In the SQL Enterprise Manager whereby I can choose a table open the table and then return all rows and I can maintain the same and save it back to the SQL Server table. I want almost a similar web interface to such a functionality.
Even if not a generic functionality as the SQL Enterprise Manager table maintenance appreciate if somebody can share the code with a sample how I can do it in ASP pages + T-SQL if need be.
I have created a form that sends email thru my local server. What I want to do is send the email thru our corporate Exchange server. Does anyone know how I can accomplish this task? Please advise. Thanks.