| Author |
 Topic Search  Topic Options
|
samirfouad 
Newbie
Joined: 14 August 2009
Status: Offline
Points: 18
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: upgrading 7 to 9.6
Posted: 11 November 2009 at 4:45am |
|
I was trying to upgrad from v7 to the new version 9.6 but i got this error
Server Error in Forum Application
An error has occurred
while connecting to the database.
Please contact the forum
administrator.
Support Error Code:-
err_Access_db_connection
File Name:-
database_connection.asp
Error details:-
Microsoft JET
Database Engine
Unrecognized database format '
i will appreciate anyhelp
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 November 2009 at 9:46am |
|
It looks like your Access database has become corrupted.
Download the Access database, open it in Access, and use the Compact and Repair Tool to fix the database.
These types of corruption issues are common with Access and you may want to look at upsizing to SQL Server for better performance and reliability.
|
|
|
|
samirfouad
Newbie
Joined: 14 August 2009
Status: Offline
Points: 18
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 November 2009 at 10:13am |
|
I will appreciate if you let me know how to uprise to sql and keep the arabic langauge as the forum contains more than 25000 questions and answers for patients to learn.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 November 2009 at 10:23am |
|
It is hard to say as there are different ways of doing and different ways of doing.
Often when we do this for customers moving to our hosting services it can take between 20 minutes and 3 hours to do, depending if any schema is dropped or don't have the correct datatypes or wrong constraints.
|
|
|
|
samirfouad
Newbie
Joined: 14 August 2009
Status: Offline
Points: 18
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 November 2009 at 5:28pm |
|
thank you for help
I am considering to use your host but i need sometime as i have just started with new one this year. also i can not find live support in the host.
thank you again , i did the compact and repair and seem it works, however, still error come on saying
Server Error in Forum Application
An error initialising Global Variables from database.
Please contact the forum administrator.
Support Error Code:- err_Access_getForumConfigurationData()_read_global_variables
File Name:- global_variables_inc.asp
Error details:-
Microsoft JET Database Engine
No value given for one or more required parameters.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 November 2009 at 7:18am |
|
Hosting customers get both phone support and a ticket system. We do not offer a live online chat type support as found in the past that this tended to slow down fault finding as people tend to give very short quick replies rather than a more detailed response people give in support tickets that allow support staff to more quickly identify any problems and give more fuller accurate answers.
Our Hosting Solutions, as well as being able to upsize the database from Access to SQL Server 2008, also include the latest Premium Edition of Web Wiz Forums and free updates. Also any issues with your forum are dealt with much quicker as support staff are able to look directly at your forum installation to find any problems. This is why companies like Microsoft and PriceWaterHouse Coopers host forums with us as it's much easier and cheaper for them having us manage the technical side for them.
As to your forum error without being able to dig into your system it's hard to say what the fault maybe as this is an usual error. The first I would try is re-uploading the files again incase a corrupted file is the course of the issue. Also make sure you have upgraded the database from version 7.x to version 9.x and not trying to run an old version 7.x database with version 9.x
|
|
|
|
samirfouad
Newbie
Joined: 14 August 2009
Status: Offline
Points: 18
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 November 2009 at 10:47am |
|
I found that I can have a host for the forum with around 7#/month which suits me as It is not for profit forum i.e teaching and free consultation to help others.
My forum is in arabic and english as i receive both arabic and english questions and need to keep the forum as it is with the same connections but i think using mssql or mysql is much better and specially registration of patient as the main problem i am facing now is that patients can not register int he current forum.
if i Register for the starter forum host would it better to use msql or mysql??
how can we transfer the database so that to keep all the information and design?? database is 30MB
shall we keep the overall design of the website including the forum as it is or changes will be made in the shape of the website??
How long it take to restor the forum working online?
please forgive me, as i am not professional in networking but as a professor in obstetrics and gynecology i see that it is better for me to control things to be able to help patient in a quick way
I will be grateful if you answer my questions and have a look at www.arabicobgyn.net to give me your advice.
thank you for your support
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 November 2009 at 11:22am |
The database would need to be upsized to SQL Server as mySQL uses a very different schema, this can be done for you and would just need your present Access database. We find SQL Server much more reliable and able to handle larger forums than mySQL can. Without knowing more information about your present forum and website it would be hard to advise you. If you would like to send us an email from the link below then should be able to advise you better and discuss the best options and migration for you:- http://www.webwiz.net/contact/
|
|
|
|
