| Author |
 Topic  |
|
|
thefreemason
Starting Member
27 Posts |
 Posted - 05 September 2004 : 09:05:34
|
Our forum main /forum.asp is not showing the stats for how many times the topic has been view/read...we migrated to a SQL and now all new topics dont show this info.
http://www.thefreemason.com/forum/default.asp br /
Any thoughts ?
Mike |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 05 September 2004 : 10:29:39
|
| Thats a issue with the default value for the field, which should be set to 0. I also suspect that you will have other problems with the forum, since the error you're getting means the database upgrade process was not correctly done. When did you do the upgrade and how was it done? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
thefreemason
Starting Member
27 Posts |
Posted - 05 September 2004 : 15:09:41
|
| We imported the tables from Access to MSSQL about a week ago. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
thefreemason
Starting Member
27 Posts |
Posted - 06 September 2004 : 08:32:17
|
Hi
We cant use EManager, and our Host does not provide a service to do this. Any other way ?
Mike |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
thefreemason
Starting Member
27 Posts |
Posted - 07 September 2004 : 04:20:12
|
| We open up the MSSQL and use the import option to import from the Access dbase. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 September 2004 : 07:17:15
|
| You open MS SQL with what? I can only think that you used Enterprise Manager, that is, that you used DTS from Enterprise Manage to do that. MS SQL has no other tool that I know of to do that. This being the case, I don't know why can't you follow the advice for the move from Access, as per the link I posted before. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
thefreemason
Starting Member
27 Posts |
Posted - 07 September 2004 : 12:06:16
|
| You can connect to MS SQL if you upsize from Access. Access creates a link using a shortcut. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 September 2004 : 12:45:56
|
Ah, I see. Well if you can't connect using EM and your host does not provide this kind of service, I suspect there ain't much that you can do.
Why can't you use Enterprise Manager? Could you use some other app, if available, or does your host forbid outside access to the database server? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
