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
 Access->SQL Conversion		  New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 3

fetch
Starting Member

46 Posts
Posted - 26 April 2005 :  14:49:50  Show Profile  Visit fetch's Homepage
Update counts gives me a success message, but it still doesn't display the counts on the new forum - even after refreshing then checking on another computer.
http://www.mhsaa.org/4rum/forum/
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 26 April 2005 :  15:48:52  Show Profile  Send ruirib a Yahoo! Message
Weird...can you compare the values in the FORUM_TOTALS table, between the Access and SQL Server tables?

Also, it seems like you're problems with the table structure have not finished yet:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'F_HIDDEN'.

/4rum/blankforum/inc_functions.asp, line 1419

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

fetch
Starting Member

46 Posts
Posted - 26 April 2005 :  17:50:54  Show Profile  Visit fetch's Homepage
Yeah I noticed that today too. I'll fix it tonight - it only shows up when you're not logged in.
http://www.mhsaa.org/4rum/forum/
Go to Top of Page

fetch
Starting Member

46 Posts
Posted - 28 April 2005 :  21:14:22  Show Profile  Visit fetch's Homepage
Still trying to get the topic numbers to display. I fixed the db error that you noticed but it didn't help. Here's the result of the update counts -

Updating Counts Step 4 of 4

Totals: Total Topics: 1722
Archived Topics: 1968
Total Posts: 31223
Total Archived Posts: 20648
Registered Users: 1442

Count Update Complete

************************************************

I checked the Access DB and the SQL DB - the FORUM_TOTALS table looks the same for both, and there isn't any difference in the column structure at all.
http://www.mhsaa.org/4rum/forum/
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 29 April 2005 :  03:46:13  Show Profile  Send ruirib a Yahoo! Message
I wasn't talking about the column structure, I meant the values in the table. Are they the same?

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

fetch
Starting Member

46 Posts
Posted - 29 April 2005 :  13:07:23  Show Profile  Visit fetch's Homepage
They were a little off, so I updated the SQL to match Access and no change in error. Also it's weird but if you go into the individual topics all the totals appear.
http://www.mhsaa.org/4rum/forum/
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 29 April 2005 :  13:19:52  Show Profile  Send ruirib a Yahoo! Message
You updated the SQL? What do you mean?

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

fetch
Starting Member

46 Posts
Posted - 29 April 2005 :  14:34:36  Show Profile  Visit fetch's Homepage
I updated the values of the single record in SQL to match those that were in the Access version that was imported.
http://www.mhsaa.org/4rum/forum/
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 29 April 2005 :  16:45:32  Show Profile  Send ruirib a Yahoo! Message
I can't get to the blank forum.

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

fetch
Starting Member

46 Posts
Posted - 29 April 2005 :  18:08:02  Show Profile  Visit fetch's Homepage
Try it now - it's on a POS server until I can get this upgrade done.
http://www.mhsaa.org/4rum/forum/
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 30 April 2005 :  05:31:27  Show Profile  Send ruirib a Yahoo! Message
What connection string are you using to the SQL DB?

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

fetch
Starting Member

46 Posts
Posted - 30 April 2005 :  11:46:55  Show Profile  Visit fetch's Homepage
Any other ideas? I think I really am at a loss now. :-(
http://www.mhsaa.org/4rum/forum/
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 30 April 2005 :  21:15:11  Show Profile  Send ruirib a Yahoo! Message
Are you using a connections string with the JETOLEDB provider?

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

fetch
Starting Member

46 Posts
Posted - 01 May 2005 :  01:43:31  Show Profile  Visit fetch's Homepage
Sorry, I missed your connection string post the first time cuz it went to page 2. Here's my string (with my own login info of course):

strConnString = "driver={SQL Server};server=SERVER_NAME;uid=USERNAME;pwd=PASSWORD;database=snitz2000" '## MS SQL Server 7

which actually may be an issue cuz it's on a SQL2000 box. What should i be using?
http://www.mhsaa.org/4rum/forum/
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 May 2005 :  10:37:10  Show Profile  Send ruirib a Yahoo! Message
Use something like this instead:


strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;"


After changing it, try updating the forum counts again.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
Page: of 3 Previous Topic Topic Next Topic  
Previous Page | Next Page
 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.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07