|
i tell u why i need the Sql Ver 7.5 cuz in 7.5 thers
wwfSPActiveUsersWhereIPis wwfSPAddNewActiveUser wwfSPUpdateActiveUser wwfSPDeleteActiveUser wwfSPDeleteActiveUserDoubleEntry wwfSPCountOfActiveUsers wwfSPCountOfActiveGuests
those stored procedures in there but in 7.6 and above the
Version history file says Changes in 7.6 > 7.7
msSQL_server_setup.asp - removed the creating of the tblActiveUsers table and the stored procedures:- wwfSPActiveUsersWhereIPis wwfSPAddNewActiveUser wwfSPUpdateActiveUser wwfSPDeleteActiveUser wwfSPDeleteActiveUserDoubleEntry wwfSPCountOfActiveUsers wwfSPCountOfActiveGuests
witout them i cant run my forum ..
why i am stayin on 7.5 and not upgrading to 7.7 ?
first i got lot mods that not works with 7.7 so i decide to stay on 7.5 .
my mods to importent and i wont change ver antill i make them work with the newest verision .
now thats what i am trying to do : (well doing it for the next 4 days)
i got Access Db his size 100mb i deleted old topics and download compect and fix and its 60mb now . i decided to move to Sql Verision cuz i got over than 50online and 60mb db is quite big .
i tried the enterprise app to convert my access db to Sql it works fine
but whan i run the forum i got problems :
wwfSPActiveUsersWhereIPis not found and more and more .. so i understand that i mising some procedures... i ran to Web Wiz download section and no Ver 7.5 Sql verision to download . .
so i download the new 7.7sql and took the mssql setup file from there
and run that on my 7.5 fourm it made EMPTY tabels and the procedures i think . but not those procedures i need to run the 7.5
i looked in Verision history file and saw that mssql setup for 7.7 wont make anymore those procedures :( i wes in big problem
i searched all the night and day aftar the right mssql setup file that will add those procedures . finaly nice webmaster that hed the mssql setup gave me BUT the file wes for 7.1sql verision
i guased it be ok . and i wes rite i didnt get more errors about mising procedures . i wes heppy tut everting is good now but no 
whan i tried to post msg or replay i got error :
ADODB.Recordset error '800a0cb3'
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/Forum/ver9/post_message.asp, line 746
in that line :
'Insert the new Thread details in the recordset .AddNew
i searched here in webwiz and found that topic thing that discuss about same error . but it didnt help me . so i called my host provider ask them to help me . aftar they looked into it they answerd me that whan i used the sql setup thing it make new tabels in db that means
and thats the problem (i short it cuz i didnt really understand)
so there suggestion wes : get ur setup for ur Verision so it make the new tabels u need than Export ur Date from the access to those tabels that been made .
i am working day and night to get those Setup sql for my verision 7.5
but with no luck . u wes my last hope and now no hope .
maybe u can somhow get me the 7.5 sql setup ? maybe u know how to fix the error :
ADODB.Recordset error '800a0cb3'
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/Forum/ver9/post_message.asp, line 746
in that line :
'Insert the new Thread details in the recordset .AddNew
maybe ...
|