| Author |
 Topic  |
|
|
Dudboy
New Member
United Kingdom
75 Posts |
 Posted - 28 July 2003 : 10:58:54
|
Anyone help with this please as I really don't want to start a fresh forum.
We are changing ISP's and the current forum DB and Scripts are all running fine.
www.clubgti.com/forum
I have moved all files and Db to new server
http://80.82.139.228/forum/
And would have hoped all would be fine however I get this error
Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name 'FORUM_ACTIVE_USERS'.
/forum/inc_func_common.asp, line 61
Any clues.
Could it be that the old forum has stored info in this table which doesn't match on the new server ? |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
Dudboy
New Member
United Kingdom
75 Posts |
Posted - 28 July 2003 : 11:23:13
|
quote:
Originally posted by Nikkol
did you change your strConnString to reflect the new database location? did you run setup?
I have altered the connection string to the relevant server address, login and password still the same.
Do I need to run set-up again even though it is a current db that's alread populated etc.
Thanks |
 |
|
|
Dudboy
New Member
United Kingdom
75 Posts |
Posted - 28 July 2003 : 11:26:52
|
| I have run all the setup stuff again and it has made no difference. |
|
|
|
puzo
Junior Member
Israel
417 Posts |
Posted - 28 July 2003 : 14:28:09
|
Taken from my help thread about SQL:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=45989
-----------------------------------------------------
To achieve a successful import, remember to set the transform column for each table so that existing data is deleted and identity insert is enabled, as explained in the posts you must have read.
-----------------------------------------------------
If that doesnt help you start a new forum (with a new database), set it up then do as the text says above. |
 |
|
|
|
Dudboy
New Member
United Kingdom
75 Posts |
Posted - 28 July 2003 : 16:39:42
|
quote:
Originally posted by puzo
Taken from my help thread about SQL:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=45989
-----------------------------------------------------
To achieve a successful import, remember to set the transform column for each table so that existing data is deleted and identity insert is enabled, as explained in the posts you must have read.
-----------------------------------------------------
If that doesnt help you start a new forum (with a new database), set it up then do as the text says above.
This is not an import but a restore which does not give you the transform options.
Any more help.
It apears to be some form of permissions problem as I wrote a simple asp script to try and pull info from the database and it didn;t like that either. |
|
|
|
Dudboy
New Member
United Kingdom
75 Posts |
Posted - 29 July 2003 : 06:33:26
|
For reference if anyone else has this problem after a move this was the solution
EXEC sp_changeobjectowner 'clubgti.FORUM_MEMBERS', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_MEMBERS_PENDING', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_ACTIVE_USERS', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_MODERATOR', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_REPLY', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_TOPICS', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_TOTALS', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_ALLOWED_MEMBERS', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_SUBSCRIPTIONS', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_A_TOPICS', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_A_REPLY', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_BADWORDS', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_NAMEFILTER', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_GROUP_NAMES', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_GROUPS', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_CATEGORY', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_CONFIG_NEW', 'dbo'
EXEC sp_changeobjectowner 'clubgti.FORUM_FORUM', 'dbo'
Thanks Gary |
|
|
| |
Topic |
|
Topic Locked
