| Author |
 Topic  |
|
Sandro
Starting Member
Belgium
26 Posts |
 Posted - 31 August 2002 : 10:14:48
|
on http://www.mastrosoft.com/forums/topic.asp?whichpage=-1&TOPIC_ID=4&REPLY_ID=4
i get this error:
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'rsReplies.Find'
/forums/topic.asp, line 262
it has to do with the whichpage being -1 but this link I clicked on on my default page. when I change it to 1 it works, is this a bug?
Edit: Appears to only happen in this Category: Support Forums (on my forum)
Edit2: Looks like i get the error because these forums have replies, the oter doesn't
Greetings,
Sandro |
Edited by - Davio on 07 March 2003 20:24:35 |
|
|
Deleted
deleted
4116 Posts |
Posted - 31 August 2002 : 10:59:23
|
Can you please try this:
Edit topic.asp, around lines 261-262, add the red line:
LastPostReplyID = cLng(Request.QueryString("REPLY_ID"))
rsReplies.MoveFirst
rsReplies.Find = "REPLY_ID=" & LastPostReplyID & ""
Please post the result here.
|
 Stop the WAR! |
Edited by - Deleted on 31 August 2002 11:00:06 |
 |
|
|
Sandro
Starting Member
Belgium
26 Posts |
Posted - 31 August 2002 : 11:09:45
|
doesn't help, just add's a number to the errorline  |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 31 August 2002 : 11:13:31
|
Can you post your strDBType and strConnString here (remove any PW/UN).
|
Stop the WAR! |
Edited by - Deleted on 31 August 2002 11:33:45 |
|
|
|
Sandro
Starting Member
Belgium
26 Posts |
Posted - 31 August 2002 : 11:43:52
|
strDBType = "access"
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=x:\xxx\xxx\xxx\...\xxx\snitz_forums_1997.mdb"
x = left out for security reasons |
Edited by - Deleted on 31 August 2002 11:56:24 |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 31 August 2002 : 12:07:03
|
This seems to be a driver specific problem.
Is you database Access 97 or Access 2000?
Can you check you server's OLE DB version from admin options (Server Information), under database Connection Properties?
DBMS Name
DBMS Version
Provider Name
OLE DB Version
Provider Version
|
Stop the WAR! |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 31 August 2002 : 12:13:03
|
To check this, I installed a fresh Access v3.4.01 database (Access 2000) on my server and it worked OK.
I converted the database to Access '97 and it worked also...
|
Stop the WAR! |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 31 August 2002 : 13:37:28
|
MDAC.... He may have an older MDAC installed on the server for some reason. Microsoft has a MDAC validation tool on thier web site.
Wes |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 31 August 2002 : 15:00:44
|
That's definitely an old MDAC problem. I've found, helping users with similar problems, that MDAC needs to be at least version 2.5 to support Find.
Sandro you need to ask your host to update the MDAC on the server. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 31 August 2002 15:34:59 |
|
|
|
Sandro
Starting Member
Belgium
26 Posts |
Posted - 31 August 2002 : 16:38:23
|
wow, lot's of activity here,
are you sure about the mdac thing? because, when i remove the - in the querystring value whichpage then it works perfectly, are you sure it has to do something with MDAC then?
I'll contact my hosting provider and ask them.
In case it would be MDAC, The server IIS4, could that cause the problem?
bozden, here are the values you asked for:
DBMS Name MS Jet
DBMS Version 04.00.0000
Provider Name MSJETOLEDB40.DLL
OLE DB Version 02.10
Provider Version 04.00.2927
Greetings,
Sandro
Edit: Some typo's  |
Edited by - Sandro on 31 August 2002 17:13:10 |
|
|
|
Sandro
Starting Member
Belgium
26 Posts |
Posted - 31 August 2002 : 16:44:21
|
default.asp has this line in it at line 1051
PageLink = "whichpage=-1&"
this is wat, as far as I know, causes the problem, but if I change it to 1 instead of -1 there might be other problems.
help please |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 31 August 2002 : 17:15:36
|
-1 indicates to topic.asp that it needs to find the last page, if you just specify 1 then it just displays page #1.
Why not just ask your host to update the MDAC on that server? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 31 August 2002 : 21:55:41
|
quote:
Originally posted by Sandro
wow, lot's of activity here,
are you sure about the mdac thing? because, when i remove the - in the querystring value whichpage then it works perfectly, are you sure it has to do something with MDAC then?
I'll contact my hosting provider and ask them.
In case it would be MDAC, The server IIS4, could that cause the problem?
Yes I'm sure about the MDAC, that's your problem. Of course, you can avoid the ocurrence of the problem altogether, if you disable the Jump Tp Last Post feature. However, if you want the feature active, you need the query string exactly as it is now, since when the jump to last post is made the page for that last post needs to be determined (this last post can be really the last or just another of the other posts that may have been edited, after the last post was made).
As Richard wrote, the easiest way out of this is just asking your provider to update the MDAC. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Sandro
Starting Member
Belgium
26 Posts |
Posted - 01 September 2002 : 06:21:42
|
yes, I could disable the function but I enabled it because it would be very easy to go to a last post. I'm waiting for my hostingprovider's reply.
Sandro |
|
|
|
Sandro
Starting Member
Belgium
26 Posts |
Posted - 02 September 2002 : 08:51:22
|
as i expected they don't want to update them, they say that it could make the webapplications of other clients on the server instable, i find this kinda nonsense ofcourse. They suggest a workaround on application level. Any Idea's?
Best Regards,
Sandro |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 September 2002 : 16:46:48
|
Frankly that's just plain stupid, IMHO. It's hard to understand how they won't change to an MDAC that will offer more functionality to their users.
AFAIK the only way to overcome that would be simply navigating the recorset, record to record, until the desired record is found. This is just so dumb that I think you'd better disable the function. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|
Topic Locked
