Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Problem moving SQL database from one server to ...
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

richfed
Average Member

United States
999 Posts

Posted - 21 October 2005 :  06:05:01  Show Profile  Visit richfed's Homepage
... another!

My web host moved my SQL database to a supposedly faster MS-SQL server. I changed the connection string on config.asp to their specifications and now get the following error when attempting to access my board:

Microsoft OLE DB Provider for SQL Server error '80040e37'

Invalid object name 'FORUM_ACTIVE_USERS'.

/messageboard/inc_func_common.asp, line 62


The above mentioned line 62 is: set rs = my_conn.execute (strSql)

I am using Snitz version 3.4.05 ... http://www.mohicanpress.com/messageboard/

Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1]

Edited by - richfed on 21 October 2005 06:07:24

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 21 October 2005 :  06:12:32  Show Profile  Send ruirib a Yahoo! Message
Looks like not all the database tables were copied... Better ask the host what he did.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

richfed
Average Member

United States
999 Posts

Posted - 21 October 2005 :  18:50:22  Show Profile  Visit richfed's Homepage
Thanks ruirib ...

My web hosts says all tables are fine - ??? - and that it is a DNS issue that need to resolve. They had me change my connection string user name & password. It's there now, but ... well, take a look. http://www.mohicanpress.com/messageboard/
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 21 October 2005 :  19:14:02  Show Profile  Send ruirib a Yahoo! Message
Looking better now..


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

richfed
Average Member

United States
999 Posts

Posted - 21 October 2005 :  19:18:58  Show Profile  Visit richfed's Homepage
Yes ... now it's all cleared ...

Thanks again ...
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 21 October 2005 :  19:29:08  Show Profile  Send ruirib a Yahoo! Message
When that happens, you just need to run setup.asp. That's what I did.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000 Version 3.4.07