After attempting to install the email confirmation mod I get the following error when I try to register:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_MEMBERS_PENDING'. Make sure it exists and that its name is spelled correctly.
/forum/register.asp, line 241
When I initiallly ran the mod setup I had delete dbs when finished checked and it returned "permission denied".
I re-ran the mod set up and it errored. Part of the error included 'FORUM_MEMBERS_PENDING'saying that it already exists. I uploaded my backup mdb file and tried the mod install again. The only error was table already exists as the last line.
I get a similar error with the admin except that it refers to "forum/admin_accounts_pending.asp, line 160"
I have searched the forums and tried everything that I could find. The forums operated perfectly (and still do minus the email mod)so the database can be written to. Im am using a DSN connection and did try the access 97 and 2000 settings in the config file and I get a read only error. I also tried what I found on the alternate setup (mod) file where code is used to remove and reinstall the table. No dice.
2nd update: I converted the database to 2000 still no good. I am not an ace with access but if someone can give me a push in the right direction I should be able to add the table off line. I am just not sure how I should construct the table.
The reason for your error is usually because you are using the Access 97 connection string. If you use the Access 2000 connection string and run the database setup it would install the database properly.
Can you give me a link to your forum? And you can email me the admin username and password so i can fix this for you. Make sure you are using the Access 2000 connection string.
«------------------------------------------------------» What new features are going to be in the 3.4 version? See the 3.4 UnOfficial Features List !
I was advised by Davio that my DSN uses an acess 97 string and the 2000 string is required for this. I had tried the first two choices (server.mappath)without success. There is a note (that I blindly missed)at the top of the server info page of the admin that references the dsnless connection. I ended up using the third option "MS Access 2000" and configured it to my "APPL_PHYSICAL_PATH" and my database folder. I again ran the mod set up. It worked like a charm and Davio's Mod is working perfectly!
Topic Locked
Posted - 15 July 2002 : 21:17:56
