| Author |
 Topic  |
|
|
mortioli
Average Member
United Kingdom
898 Posts |
 Posted - 11 July 2005 : 15:55:27
|
Hi I wonder if someone could help me please?
I originally posted this query a long long time ago (http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=53825&SearchTerms=view_count) but never got it sorted.
Basically, I moved my database from Access to MSSQL, and ever since, the T_VIEW_COUNT is empty and won't increase on each view.
I attempted to fill in the default value with 0, on my old host, but it didn't work. I've now moved host, along with my MSSQL DB, and it still doesn't work now.
Could anyone please help me so I can get the views counting again please!?
Here's a screen shot from MSSQL ASP.Net Enterprise Manager - http://img.photobucket.com/albums/v460/ojm/t_view_count.gif
The headings across the top read;
Key / Name / Type / Length / Prec / Scale / Nulls / Default / Ident / Seed / Incr / Insert
Any help would be great!
Thanks,
Oli |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 July 2005 : 17:09:17
|
That means that, by now, you've basically moved/upsized your DB to SQL Server twice without applying our recommendations on the subject. The issue is with default values, indeed.
If you can, start anew. Run setup.asp?RC=5, which will delete the existing tables and recreate yours properly, then use DTS to transfer the data. There are recommendations on the isse, just use the search page on Access to SQL Server (instructions also apply to this case). |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
| |
Topic |
|
|
|
Topic Locked
