| Author |
 Topic  |
|
|
tobycerqua
Starting Member
USA
15 Posts |
 Posted - 30 April 2002 : 16:35:16
|
server:
WinNT 4
MSSQL 7
IIS 4
error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'FORUM_CONFIG_NEW'.
/forum/config.asp, line 130
i have no idea what is wrong. i'm trying to run setup.asp?rc=5 for the initial setup, and this is the error i get. any ideas? help!
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 30 April 2002 : 16:43:44
|
| can you post the link to the forum? |
 |
|
|
tobycerqua
Starting Member
USA
15 Posts |
|
|
tobycerqua
Starting Member
USA
15 Posts |
Posted - 30 April 2002 : 16:53:12
|
i omitted an important detail: this is HuwR's modified version, straight from his website. however, i made the (possibly totally wrong) assumption that the initial setup would be identical.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tobycerqua
Starting Member
USA
15 Posts |
Posted - 01 May 2002 : 14:41:54
|
http://www.hrosary.org/forum/config.txt
also, so you know: i changed the connection string just slightly (took out the curly brackets), but i know it works.
Edited by - tobycerqua on 01 May 2002 14:44:54 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 01 May 2002 : 14:50:47
|
I can't see anything wrong with config.asp, although I cannot understand why you need to remove the brackets.
Were the tables created? Can you check it?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 01 May 2002 14:52:37 |
|
|
|
tobycerqua
Starting Member
USA
15 Posts |
Posted - 01 May 2002 : 15:26:32
|
yep, they don't ever get created. i don't get that far. if you go to setup.asp (or setup.asp?rc=5), it simply breaks.
huwr? you out there? any ideas?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tobycerqua
Starting Member
USA
15 Posts |
Posted - 02 May 2002 : 09:26:26
|
hi again,
i was able to fix the problem, actually. at some point during *both* previous attempts at install, i must have made a mistake -- once i wiped it all clean and tried a third time, it works great. i suspect that i either missed a step or did something in the wrong order.
http://www.hrosary.org/forum
also, for anyone encountering the same problem (the error message in the first post in this thread) when attempting an install of HuwR's version of the forum: you must install the regular snitz forums FIRST. then do HuwR's stuff.
thanks again, all.
|
|
|
|
Fury
New Member
USA
62 Posts |
Posted - 10 May 2002 : 00:14:26
|
Finally! I found a post that has my exact problem.
I have Huw's most recent modified version running in Access. I created a blank SQL database. Created a user with public and db_owner rights and assigned that user to the blank DB. Modified the config.sys (even tried ruirib's other connection string). Changed the dbtype line to sql (verified I commented out the others). Then tried to run the setup.asp?RC=5 and I get the same error that tobycerqua started this thread with.
There has to be an easier way than starting over doesn't there? Huw? I'll check Huw's site to see if he has anything there and if I find anything I'll paste the answer here.
|
|
|
|
Fury
New Member
USA
62 Posts |
Posted - 10 May 2002 : 00:26:34
|
Ok, the answer is there and it does not look as bad as it sounded. I'm going to try it but here are the intructions for Huw's version...
quote:
New Installation SQL db Only:
1) Upload Snitz's latest release to your server & dbs_Huwdbmods.asp (In Zip)
2) Set your connection strings
3) Run Setup.asp?RC=5
4) Run admin_mod_dbsetup.asp & select "Huws Forum DB changes" *You will have some errors when dropping tables since there are none.
5) Verify that the base forum is operating properly, you can now delete these files or leave them in a folder for backup or future use
6) Install all the files located in the Modified forum zip in a folder called "forum".
7) Make sure you set your connect string in the new config file
8) Run Admin_run_config.asp
9) You should now have a working forum!
I'll let you know how it goes.
|
|
|
|
Fury
New Member
USA
62 Posts |
Posted - 10 May 2002 : 01:11:16
|
Everything worked fine up to step 8. I get an error but Huw says that the error is not important and can be ignored. Ok...
So now I have to take my old stuff and put it in here. This is going to take some time but for the benefit of the upgrade from Access to SQL I suppose it's worth it.
|
|
|
| |
Topic |
|
Topic Locked
