| Author |
 Topic  |
|
|
zod411
Starting Member
24 Posts |
 Posted - 15 August 2005 : 19:45:27
|
I recently put in the avatar mod, but now as I try to mass add I get the following error:
Adding :AFI
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_AVATAR'.
/FTR/admin_avatar_mass_add.asp, line 111
The code around 111 is:
'#### Inster into database
strSql = "INSERT INTO " & strTablePrefix & "AVATAR ("
strSql = strSql & "A_URL"
strSql = strSql & ", A_NAME"
strSql = strSql & ", A_MEMBER_ID"
strSql = strSql & ") VALUES ("
strSql = strSql & "'" & strFinalLocation & avatarImageName & "'"
strSql = strSql & ", '" & avatarDisplayName(0) & "'"
strSql = strSql & ", " & 0
strSql = strSql & ")"
'response.write(strSql & "<BR>")
my_Conn.Execute (strSql)
Next
With my_Conn.Execute (strSql) being line 111
I am using version 3.4.05. Any Ideas?
Thanks.
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
zod411
Starting Member
24 Posts |
Posted - 15 August 2005 : 22:53:18
|
| i did. |
 |
|
|
zod411
Starting Member
24 Posts |
Posted - 15 August 2005 : 23:35:37
|
I just tried to update the database again and this is what i have, dont know if it will help or not:
Creating table(s)...
CREATE TABLE FORUM_AVATAR( A_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , A_URL text (255) NULL , A_NAME text (50) NULL , A_MEMBER_ID int NULL )
Table already exists
--------------------------------------------------------------------------------
Adding Column M_AVATAR_URL...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_AVATAR_URL text (255) NULL
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_AVATAR_URL text (255) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'M_AVATAR_URL' already exists in table 'FORUM_MEMBERS'.
--------------------------------------------------------------------------------
Adding Column M_AVATAR_URL...
ALTER TABLE FORUM_MEMBERS_PENDING ADD COLUMN M_AVATAR_URL text (255) NULL
ALTER TABLE FORUM_MEMBERS_PENDING ADD COLUMN M_AVATAR_URL text (255) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'M_AVATAR_URL' already exists in table 'FORUM_MEMBERS_PENDING'.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intShowAvatar','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strAvatarFolder','avatars/')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAvatarWidth','64')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAvatarHeight','64')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAvatarBorder','1')
Value(s) updated successfully |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 August 2005 : 05:13:13
|
Change your connection string to use one of those in config.asp that uses an OLEDB driver, for example:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("...")
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
zod411
Starting Member
24 Posts |
Posted - 16 August 2005 : 16:50:37
|
| I use a DSN, so I am not to sure on how I would go about doing that. In fact I am not very good at this at all. I am trying to set this up the same as my other forum on another page that someone else set up for me. I'm not the worst here, but i am no expert. You might have to take it slow for me. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
zod411
Starting Member
24 Posts |
Posted - 16 August 2005 : 18:55:53
|
ok we are getting closer. now i get this error:
Adding :AFI
Microsoft JET Database Engine error '80040e37'
Could not find output table 'FORUM_AVATAR'.
/FTR/admin_avatar_mass_add.asp, line 111
I also have this question... Now that I am using the OLEDB driver, I had to put in my path to my DB. Is that code somehow accessable for someone to find and copy my DB?
|
|
|
|
zod411
Starting Member
24 Posts |
Posted - 16 August 2005 : 18:59:34
|
| ok nevermind, I had to update the DB again. And now it works! Thanks! My question however remians..... |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 August 2005 : 19:27:33
|
| What question? ASP files are not accessible from outside the server. Your host, of course, can access it, but he doesn't need to have a look at the conn string anyway... No need to worry... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
zod411
Starting Member
24 Posts |
Posted - 16 August 2005 : 19:46:30
|
| ok thanks! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
