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: General / Classic ASP versions(v3.4.XX)
 PErformance issue on windows server 2012 R2
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

s80ts0465
Junior Member

Italy
290 Posts

Posted - 15 September 2017 :  03:34:15  Show Profile  Send s80ts0465 an ICQ Message  Reply with Quote
Hi, I upgraded the system form Windows 7 to Windows Server 2012 R2 64bit. Everything works, but I noticed a slower forum navigation and in same cases long wait to show pages.
Could it be a ODBC connections issue? I still the same string of before...Provider=Microsoft.Jet.OLEDB.4.0

Is there any known issue with Windows server 2012 R2 64bit?

Ste


Edited by - s80ts0465 on 15 September 2017 04:22:23

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 15 September 2017 :  06:23:59  Show Profile  Visit HuwR's Homepage  Reply with Quote
There aren't any known issues, however you would probably get much better performance using SQL Express rather than an ACCESS database

MVC .net dev/test site | MVC .net running on Raspberry Pi
Go to Top of Page

s80ts0465
Junior Member

Italy
290 Posts

Posted - 15 September 2017 :  07:10:41  Show Profile  Send s80ts0465 an ICQ Message  Reply with Quote
Thanks for the reply,
I was already thinking about to upgrade to MySQL o SQL Express, do you suggest SQL Express? is there any migration procedure?

anyway, before the upgrade everything was much faster, and the DB dimensions are similar
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 15 September 2017 :  13:05:48  Show Profile  Visit HuwR's Homepage  Reply with Quote
since you are using a windows server, I would install sql express, Microsoft provide an app for migrating access to sql
https://docs.microsoft.com/en-us/sql/ssma/access/installing-sql-server-migration-assistant-for-access-accesstosql

MVC .net dev/test site | MVC .net running on Raspberry Pi
Go to Top of Page

s80ts0465
Junior Member

Italy
290 Posts

Posted - 15 September 2017 :  17:34:59  Show Profile  Send s80ts0465 an ICQ Message  Reply with Quote
I found in the forum this procedure for migration access to sql https://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=63884

what do I have to follow? this guide or simply use the tool you suggested?
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 15 September 2017 :  18:28:51  Show Profile  Visit HuwR's Homepage  Reply with Quote
the tool is probably easier (it didn't exist back when that post was made) but following the steps in the post would also work

MVC .net dev/test site | MVC .net running on Raspberry Pi
Go to Top of Page

s80ts0465
Junior Member

Italy
290 Posts

Posted - 17 September 2017 :  06:16:16  Show Profile  Send s80ts0465 an ICQ Message  Reply with Quote
Ok, tomorrow I'll try the tool, hope to not have problems with it and improve performance and avoid index issues.

After completed the migration, Hhve I to do something on the forum? apart to change the connection DB string?

Edited by - s80ts0465 on 17 September 2017 06:40:15
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 18 September 2017 :  06:36:47  Show Profile  Visit HuwR's Homepage  Reply with Quote
you may need to just load the setup.asp page to refresh everything (you won't need to run anything, just choose go back to forum if the page indicates everything is ok)

MVC .net dev/test site | MVC .net running on Raspberry Pi
Go to Top of Page

s80ts0465
Junior Member

Italy
290 Posts

Posted - 18 September 2017 :  07:21:24  Show Profile  Send s80ts0465 an ICQ Message  Reply with Quote
some problems... after upgraded, entered to forum is requested to upgrade the DB
quote:
The database you are using needs to be upgraded !!

Code : 80040E09
, but after that the page is blank

I also tried to install a fresh database and the setup page reply with a good database creation, but after I come back to default.asp I have the blank page
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000 Version 3.4.07