| Author |
 Topic  |
|
|
nexx
Starting Member
18 Posts |
 Posted - 16 May 2002 : 03:07:58
|
Well... another one... when i try to add an avatar...
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_AVATAR'.
/forum/admin_add_avatar.asp, line 90
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 16 May 2002 : 03:45:31
|
that means that the FORUM_AVATAR table was not created when you ran the database setup.
The reason it wasn't setup is because you are using ODBC drivers instead of OLE Drivers for the Database.
You should be using one of the strConnStrings that start with this:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;
and NOT the ones that start with this:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)};
Try changing the strConnString in your config.asp file and then run the MOD Setup from the Admin Options again. |
 |
|
|
nexx
Starting Member
18 Posts |
Posted - 16 May 2002 : 05:56:38
|
Thanks! You're wonderful!
Edited by - nexx on 16 May 2002 05:57:43 |
|
|
|
nemesis
Starting Member
43 Posts |
Posted - 16 May 2002 : 06:28:26
|
Good Morning Richard,
Sorry for the cross Message Post but I really need your help.
The Mod works fine when there is only one message in the forum, but when there is a reply or a new post I get this message.
Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/Forum/topic.asp, line 388
Page:
GET /Forum/topic.asp
on that line (388) I have
<% if Trim(rsReplies("M_AVATAR_URL")) <> "" and lcase(rsReplies("M_AVATAR_URL")) <> "noavatar.gif" and (IsNull(rsReplies("M_AVATAR_URL")) = false) then %>
So why the message..?
Please help.. thank you
Nem
Depression is merely Anger without Enthusiasm. |
|
|
|
Um
Junior Member
222 Posts |
Posted - 16 May 2002 : 13:58:51
|
this line it have to look like this:
<br><% if Trim(rsReplies("M_AVATAR_URL")) <> "" and lcase(rsReplies("M_AVATAR_URL")) <> "noavatar.gif" and (IsNull(rsReplies("M_AVATAR_URL")) = false) then %>
are you sure that you have <br> on the start of line?
If you have that, then try to change the rsReplies to rsTopic...
IMPORTANT: Be sure, that you have backup file.
Edited by - Um on 16 May 2002 14:12:14 |
|
|
|
nemesis
Starting Member
43 Posts |
Posted - 17 May 2002 : 01:58:01
|
Thanks for the advice, but it doesn't work.
When I do that I get this error..
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'rsTopic'
/Forum/topic.asp, line 389
I think the first part of the code is for the Replies, and the second part is for the Topics.
When I publish a new topic I see the avatars, when someone replies to the topic i get the previous error.
Thanks for any help.
Nem
Depression is merely Anger without Enthusiasm. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 17 May 2002 : 02:19:07
|
| Most likely the problem lies in the strSql part where the replies are pulled from the database. Double check that you correctly added all of the code to topic.asp that is in the instructions. |
|
|
|
nemesis
Starting Member
43 Posts |
Posted - 17 May 2002 : 03:53:20
|
Me eyes got twisted so bad after going through all the code looking foe errors I thought the easiest thing would be to start again.
I kept the DB re-setup the forum and it now works fine.
Thank you all for all the help.
Nem
Depression is merely Anger without Enthusiasm. |
|
|
| |
Topic |
|
Topic Locked
