My company is in the process of moving servers and I am one of the developers in charge of making sure it runs smoothly. Currently, we are on a Linux server that runs Chilisoft ASP. We are moving to a 2003 Server with IIS6.Several of our scripts use the recordcount property of recordsets.
On the new server, recordcount seems to be shaky. We have managed to get it working on one of our websites fine, but on another site on the same server it does not. Both sites are configured in the same manner. We did have to add "objConn.CursorLocation = adUseClient" before opening each connection, which made it work for the first site, but adding the same line of code on the other site seems to have no effect.
I'm simply trying to get a number of records returned in a recordset, and just get a -1. I have looke din a few books and other references, can't seem to find any answers. Anyone have any idea why I can't get a real number? For the record, the recordset is not empty. In fact, it has many records which I can see plainly on the screen. But when I do response.write rs.recordcount, it just shows -1
i tried using a few method from the forum and fail. So anyone can help me out with this, i wanted to count the total number of record in the on of the table Namecard, so tried this code but fail, anyone can help me out? Code:
Our application currently runs on aWindows 2000 Advance server with Oracle 8i and Microsoft IIS 6.0. We are changing servers and will now be running a Windows 2003 server with Oracle 8i and Microsoft IIS 6.0.
The .RecordCount property does not work on the server. It returns a -1. We have not changed any code.
Any idea why this would happen? Are there certain parameters that have to be set to get the .RecordCount to work?
I have an ASP page calling a VB COM calling an SQL Server stored procedure. What I would like is to return a recordset to ASP (works fine) and obtain the RecordCount (doesn't work). The problem seems to be the difference between adOpenForwardOnly and adOpenStatic of the recordset (adOpenForwardOnly is default and doesn't support RecordCount). Unfortunately, I'm unaware of how to specify adOpenStatic for the recordset. I've seen the "RS.Open SQL, Connection, adOpenStatic, adLockReadOnly" method, but my recordset is populated by a stored procedure "Set objRS = objCmd.Execute" ... any ideas how I can obtain the RecordCount (short of having the stored procedure return a count)? Also does it matter where I specify the adOpenStatic (ie, in VB COM or ASP)?
I've like to check whether the recordcount equals 0, 1 or greater than 1. I'm still getting to grips with ASP, but hope this isn't too hard. Coming from CF background - have sussed out conditional stuff in ASP, but need to do recordcounts for validation.
to count total records in rsnews table, how do i change this to count not all the records, but count the records that has a certain field with a value in it? ie:
I'm using multiple recordsets on a page, and they are all returning correct results and enough of them. My problem is when I try to access the recordcount property rs.recordcount, they all return a result of -1. This would usually mean that no records are returned. So why is showing my recordsets that are displaying records with recordcounts of -1. I can't seem to figure out.
even though the db has pulled at least 10 records... i cant figure it out... it has broken alot of my code.. and i've been forced to find different means of making the same code work in asp that i could write quickly in php. i'm trying to learn asp now, and i'm just having problems with this..
I searched the web for this, but couldn't find any reason as to why this was happening to me. I have a database set up with one record in the students table. I just issused a query "SELECT * FROM students" to test my DB. When I try to get the number of records with adoRS.RecordCount, it returns a -1.
Code:
set adoConn = Server.CreateObject("ADODB.Connection") set adoRS = Server.CreateObject("ADODB.Recordset")
Can someone explain this: ----------------------------------------- CQuantity = 8 if 4 < cQuantity then (works) -------------------------------------------
'Get Record Count of This Type of Property set rsProp1 = server.createobject("adodb.recordset") rsProp1.pagesize = 1 mysql = "select * from Property where PropTypeID="&cAccomID rsProp1.open mysql,cn,3,3
response.write(rsProp1.recordcount) >> = 4
if rsProp1.recordcount < cQuantity then (DOES NOT WORK!!!! QUANTITY IS STILL 8)
why a ADO recordset.recordcount would return a -1? I have confirmed that it has records in it by writing some values to the screen. Why can't I count the number of records returned though?
i am trying to count the records in an access database, and i cant seem to figure out the syntax to count the records and output a response.write with the number.
I'm opening a recordset with a SQL statement and then trying to use the .RecordCount property to count the number of rows in the recordset. For some reason, it is always returning -1. Code:
I'm currently testing a version of Win2003 to evaluate a migration of our NT4 server, but I got some troubles with Office Web Component 9 (office 2000), it seems it doesn't work anymore, and I can't find the issue.
When I make a Set objSpreadsheet = Server.CreateObject("OWC.Spreadsheet"), I got an error : Server object error 'ASP 0177 : 800401f3' Server.CreateObject Failed /test/include/./include_asp/excel-class.asp, line 10 800401f3
So I thought it was a "Web service extension" problem, prohibited por default by IIS6, I authorized MSOWC.dll but nothing changed...
Then I decided to setup OWC11 and it seems to works fine.... even if I don't authorized it... (is it a normal behaviour ?, shouldn't I be supposed to autorized it ? )
I can't understand my problem with OWC9 is there some incompatibility with IIS6 ? Code:
Ive got a ASP site on a server with a old iis and it works perfect on but ive got a new server with IIS 6 with exactly the same site and the session variables wont stick they just dissaper any idea.
I have a custom File management ASP application that handles Large File uploads and download from a database (30 - 40 MB files) The application works fine on IIS5 but when I relocate it to IIS6 i get an error when I file not found error when i attempt to download out of the Database. IS there a reg setting or metabase setting that i need to change to handle large blob outputs.? Sorry I can't be more specific about the error msg but that is all it give's me a File not found error. it does however work fine with small files less then 2mb in size
I used to be able to run ASP scripts on IIS and then I installed MS SQL server 2000, and EVERY page I go to that has an .asp extension (even if the code inside is BLANK) will return a error labeled "The requested resource is in use. ". I've tried many things like re-installing IIS 6, allot of things. PLEASE help me, this is on a production box and HAS to be UP AND WORKING before 1:00 AM CST (5 Hours from the time I posted this)
I migrated an application from NT4 (IIS4) to 2003 (IIS6).
The application only works when the components are registered with regsvr32.
One of the webpages doesn't work-- when I fill the form out and hit submit I get "compx error '800af10a' Insufficient memory to perform operation. /submit.asp, line 283"
I've tried going through and changing permissions but haven't had any luck. I also tried setting the Web Site to use an Application Pool that I created to run as System Mode but that didn't make any difference.
Everything works when I select "IIS5 Isolation Mode".
Knowing that it works under IIS5 Isolation mode how can I determine what is causing the message so I can run it under IIS6?
I migrated a VID6 application from Windows NT 4 to Windows 2003 Server (IIS4 to IIS6) which was developed using ASP and VBScript and I now I am getting an error message as follows: Microsoft OLE DB Provider for Visual FoxPro error '80004005' There is not enough memory to complete this operation. /hinojosa-web/iPD2.asp, line 377 The line mentioned above refers to the execution of a query to generate a recordset which will be displayed to the user who is requesting data. This issue does not always happens, it does only after accesing the web site several times.
I just have installed Windows 2003 Server Enterprise Ed.Where the IIS ver.6 came with it. I installed the IIS6 with all its subcomponents. The problem is that ASP pages are not processed by the IIS whereis HTML pages are. I have allowed asp extensions.
