Author |
Topic |
|
stewy
Starting Member
7 Posts |
Posted - 11 July 2001 : 06:18:25
|
Maybe i'm just not trying or looking hard enough... but i keep getting;
<I>"Error Type: Microsoft JET Database Engine (0x80040E37) The Microsoft Jet database engine cannot find the input table or query 'FORUM_ONLINE'. Make sure it exists and that its name is spelled correctly. /forum/buddy.asp, line 96"</i>
when trying to access buddy.asp. Any ideas?
Stewy
|
|
bjlt
Senior Member
1144 Posts |
Posted - 11 July 2001 : 06:51:13
|
have you installed active users mod? btw, a newer version of the active user is coming, but not sure when it will be done.
|
|
|
SalmanKhana
Average Member
USA
961 Posts |
Posted - 11 July 2001 : 08:35:33
|
you get the errror because of the folllowing reason :-
your database does not have the column .
So now go and run mod_dbsetup.asp and chose the buddy mod and update it .... you may also do that by MOD commander if you have one.
Take it easy
sal.
|
|
|
stewy
Starting Member
7 Posts |
Posted - 11 July 2001 : 09:06:46
|
Tried running mod_dbsetup.asp again, but tells me that the table was already created.
I didn't think you needed the active users mod, should i wait for it?
|
|
|
bjlt
Senior Member
1144 Posts |
Posted - 11 July 2001 : 09:27:20
|
quote:
Tried running mod_dbsetup.asp again, but tells me that the table was already created.
I didn't think you needed the active users mod, should i wait for it?
there's an existing active user mod with minor bugs (nothing actually affect your site)
yes you need it. buddy is something like an add on for active users. i got the same error at first.
|
|
|
Ez4arab
Junior Member
479 Posts |
Posted - 11 July 2001 : 10:51:46
|
i have problme with mod_dbsetup.asp i am using 97 database i can not change it to 2000 for some resone. can anybody make for buddy mod fix with 97 database
|
|
|
stewy
Starting Member
7 Posts |
Posted - 11 July 2001 : 14:09:58
|
quote:
i have problme with mod_dbsetup.asp i am using 97 database i can not change it to 2000 for some resone. can anybody make for buddy mod fix with 97 database
I know the error.... just had to edit config.asp and comment available db's out except the Access 2000 one... worked like a charm... but now i have this problem. Hehe ;)
|
|
|
Ez4arab
Junior Member
479 Posts |
Posted - 11 July 2001 : 17:11:48
|
quote:
quote:
i have problme with mod_dbsetup.asp i am using 97 database i can not change it to 2000 for some resone. can anybody make for buddy mod fix with 97 database
I know the error.... just had to edit config.asp and comment available db's out except the Access 2000 one... worked like a charm... but now i have this problem. Hehe ;)
you said you Know the error if you fix it why do not give it to me> this file .......... plezzzzzzzzz if you donot mind
Edited by - aljish on 11 July 2001 17:13:26 |
|
|
stewy
Starting Member
7 Posts |
Posted - 11 July 2001 : 18:46:14
|
In config.asp, make sure below the db selection has a commented OUT line for
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=h:\inetpub\location_of_db\snitz_forums_2000.mdb;" '## MS Access 2000
Compare with this. http://stewy.dhs.org/filez/config.zip
|
|
|
stewy
Starting Member
7 Posts |
Posted - 11 July 2001 : 18:50:02
|
THANKSSSSS!!!!
People... you are GODS. Active users mode got the buddy mod going no prb.
Thought i was a master of web till i met asp.
Thanks everybody!!
Stewy
|
|
|
Ez4arab
Junior Member
479 Posts |
Posted - 12 July 2001 : 07:17:34
|
quote:
In config.asp, make sure below the db selection has a commented OUT line for
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=h:\inetpub\location_of_db\snitz_forums_2000.mdb;" '## MS Access 2000
Compare with this. http://stewy.dhs.org/filez/config.zip
are you sure if i change mine to this strConnString "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=h:\inetpub\location_of_db\snitz_forums_2000.mdb;" '## MS Access 2000
will be ok.
as i told you i am using MS Access 97 not MS Access 2000.
|
|
|
stewy
Starting Member
7 Posts |
Posted - 12 July 2001 : 10:02:47
|
quote:
i have problme with mod_dbsetup.asp i am using 97 database i can not change it to 2000 for some resone. can anybody make for buddy mod fix with 97 database
Thought you wanted to CHANGE it to Access 2000. If you're using the Access 97 db, leave only this line UNcommented;
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=h:\inetpub\wwwroot\cgi\snitz_forums_2000.mdb" '## MS Access 97
Comment out the rest. (') Something to try... And there's ALOT of mod_dbsetup.asp files out there... most will be included with the mods downloaded. Different versions may work also.
BTW.... if people feel like pitching in here, go nuts. Lord knows i'm no expert! Heh
Edited by - stewy on 12 July 2001 10:32:32 |
|
|
|
Topic |
|