Recordcount Issue On Iis6
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.
View Replies
ADVERTISEMENT
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
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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)?
View Replies
View Related
SET objRds = Server.CreateObject("ADODB.Recordset")
objRds.CursorType = 1
objRds.LockType = 3 'adLockOptimistic
objRds.ActiveConnection = objConn
objRds.open strSql
objRds.Recordcount
when i run the srl in query anaylzer, i get records, more than 1 but record count gives me -1 .
View Replies
View Related
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.
View Replies
View Related
I have this:
intTotalNumNewsEntries = rsNews.RecordCount
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:
intTotalNumNewsEntries = rsNews.somedbfield.RecordCount
View Replies
View Related
I know for a fact that in my database, I have three records under the users
table. However when I execute this code:
View Replies
View Related
When I use the following, the RS.recordcount is -1. I also can't do a RS.moveprevious.
What have I overlooked? Code:
View Replies
View Related
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.
View Replies
View Related
can anyone tell me why this chunk of code returns "-1"
'dbcnx is database connection
sql = "SELECT * FROM articles"
Set rsArticles = dbcnx.Execute(sql)
rsNumRows = rsArticles.RecordCount
Response.Write("Viewing " & rsNumRows & " record(s).")
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..
View Replies
View Related
I have:
strSQL = "SELECT * FROM newarchive WHERE Program_Title LIKE '%" & program & "%' ORDER BY ID"
set objRS = objConn.Execute(strSQL)
Response.Write "There are " & objRS.RecordCount & " results."
I get -1 for the count on every search.
View Replies
View Related
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")
adoConn.Open "DSN=myodbc"
adoRS.ActiveConnection = adoConn
adoRS.Open "select * from students"
response.write(adoRS.RecordCount)
I do have an entry in the students table, so the RecordCount should be 1. BTW, I'm using the latest MyODBC 3.51 driver.
View Replies
View Related
recCount = rsFaq.RecordCount
Response.Write("Total number of records: " & recCount)
it outputs -1 even though there are 4 records, how come?
View Replies
View Related
i use this code;
Dim aCount
rsArchive.Open "SELECT * FROM qryArchive", db
aCount = rsArchive.RecordCount
but why aCount is still -1? the actual recordcount should be 4?
View Replies
View Related
I'm having a hell of a time with this...
From researching multiple websites, specifying the asOpenStatic cursor should return the correct RecordCount.
Here is my code:
sql = "SELECT UserID,UserName,Password,AccessLevelID,LockThreshold,Active FROM tbl_users WHERE UserName = '" & username & "' and Password = '" & password &"' "
set rs_login=Server.CreateObject("ADODB.Recordset")
rs_login.Open sql, conn, adOpenStatic', adLockReadOnly, adCmdTable
if rs_login.RecordCount <> 0 then
Response.Write("Login Successful" & "<br>")
Response.Write("Record Count: " & rs_login.RecordCount)
end if
I know I can use the select count(*) instead, but I've been researching this for quite some time now and I would like to know what's wrong.
View Replies
View Related
im having returning the recordcount of my recordset. i have already set the cursor to be adOpenStatic but it still returns -1.
View Replies
View Related
I have a recordset object generated by the command object
as in recordset object=command.execute
now recordset.recordcount gives me -1 !!!!
the actual record count is 7!!!
Any body who can tell em how to change the cursor type of the recordset
which is generated by a command object!!!
View Replies
View Related
when the recordcount of the recordset of a adocon is -1, how can I write the record count correctly? I once tried:
rs.movelast
response.Write(rs.AbsolutePosition)
it report the following message for the movelast method
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E24)
Rowset does not support fetching backward.
View Replies
View Related
I have this code and it keeps spitting out -1 when I know there are 9 records, please help me.
Randomize
DIM cat,random_number(), counter, check,count
cat = Request("category")
Set cnn1 = Server.CreateObject("ADODB.Connection")
openStr = "driver={Microsoft Access Driver (*.mdb)};" & _
"dbq=" & Server.MapPath("database/images.mdb")
cnn1.Open openStr,"",""
sql = "SELECT * FROM gallery WHERE category = '" & cat & "' Order by ID"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, cnn1, adOpenDynamic, adLockOptimistic, adCmdText
count = rs.RecordCount
redim random_number(9)
View Replies
View Related
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)
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
I'm getting errors when trying to access any Recordset properties and methods
"Object Doesn't support Property error" MoveNext
"Object Doesn't support Property error" EOF
"Object Doesn't support Property error" RecordCount
I'm using a DSN and ADO do I have to change to an OLE DB connection?
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
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
View Replies
View Related
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)
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
