| Author |
 Topic  |
|
|
micnikberlin
Starting Member
Germany
2 Posts |
 Posted - 06 April 2001 : 05:29:36
|
database:access
i´ve changed the database from office 97 to 2000 on windows nt.
when i open in the navigation the title "members" there is the following errormessage:
ADODB.Recordset-Fehler '800a0bb9'
.....wrong arguments.....
/dasforum/members.asp, Zeile 139
an it seems that the whole forums is not represented correctly on the sreen: some icons and text are missing there is no possibility to log in etc.
so i do think there is a problem with the access database, that i changed into a newer version.
anyone an idea ?
|
|
|
RaiderUK
Average Member
United Kingdom
577 Posts |
Posted - 06 April 2001 : 19:50:11
|
what does line 139 read?
|
 |
|
|
GaryDale
Starting Member
3 Posts |
Posted - 10 April 2001 : 15:03:32
|
I'm getting the same error:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forum.asp, line 184
This is happening on two previously working forums. The difference is I upgraded my server from NT 4/SP6a to Windows 2000. To be more specific, I did a fresh install of W2K Advanced Server and recreated the IIS entries for the two web sites. I also rebuilt the ODBC entries pointing to the two copies of the snizt database. There seems to be a difference in the drivers between the 2000 version of Access and the 97/NT version.
The code around line 184 is:
<%
if rsCStatus.EOF = true OR rsFStatus.EOF = true then
Response.Redirect("default.asp")
end if
%>
I believe the actual line is the IF statement, but Notepad doesn't show the line count...
|
|
|
|
GaryDale
Starting Member
3 Posts |
Posted - 10 April 2001 : 15:17:30
|
And having done some more searching on the site, I've uncovered the cause of the problem. I needed to re-run the setup.asp. I did that and everything is working again.
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 10 April 2001 : 17:11:24
|
quote:
There seems to be a difference in the drivers between the 2000 version of Access and the 97/NT version.
The drivers are dependent on the version of MDAC that is installed on the server, not the OS version. NT4 IIS4 installs MDAC 2.1, but you can (and should) download newer MDAC and install it, MDAC 2.6 is current.
W2K has MDAC 2.5 installed out of the box.
======
Doug G
====== |
|
|
|
micnikberlin
Starting Member
Germany
2 Posts |
Posted - 19 April 2001 : 17:24:34
|
quote:
what does line 139 read?
i don´t know because now the forum works, probably restarting the maschine was enough to solve the problem
|
|
|
| |
Topic |
|
Topic Locked
