Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-09 : 08:50:27
|
| Jim writes "I am not a techie and need help. I have a website (www.mtonline.com) that is not working properly. It works very slowly or I get MS error messages such as the following:-------------------------------------------- Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver]Timeout expired D:\INETPUB\WWWROOT\MTONLINE\FACIL\../includes/func_dataaccess.inc, line 18 orD:\INETPUB\WWWROOT\MTONLINE\FACIL\../includes/func_dataaccess.inc, line 43 error 'ASP 0113' Script timed out /facil/facilResultContent1.asp The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeOut or by changing the changing the value in the IIS administration tools.------------------------------------------------------------ When inquiring about it, I got the following from my host who created the site 5 years ago...----------------------------------------------------------------"Your site is on a ancient version of an SQL DB (in the computer world 5 years is pretty old). So getting in and touching lots of things is dangerous. We do not have really anyone here that familiar with the version of your DB (v6.5). You have a few options. (1) I will continue to have our IT department look into it(2) You can hire an SQL 6.5 expert to look into the situation(3) You are welcome to move the site to another hosting provider. They would either need to upgrade the DB (which is no trivel task and of considerable expense) or have a version of 6.5 hangin around somewhere (highly unlikely). I am happy to continue to host the site, but I do not want to inherit recoding the site or transferring an unstable DB. We did explore upgrading the DB to a newer version but this is also very dangerous and time consuming. It could require a considerable amount of re-programming. ----------------------------------------------------------------My problem is it's be over 2 weeks and the site doesn't get fixed and I haven't been able to get a copy of the program and DB.I don't know what to do, and don't have a lot of money to invest in it. Can the v6.5 DB be upgraded to 7.0 or SQL 2000 and if so, what might the cost be? Can you help me ? Thanks for your prompt reply..Jim Curtis, Windsor, CA. jim.curtis2@comcast.net" |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-09 : 11:41:30
|
| I would expect that upgrading from SQL 6.5 to SQL 2000 would be relatively straight forward - it is quite possibly that the application will work without modification - however its a bit like "how long is a piece of string" [note that I don't think there is a direct migration from 6.5 to 2000 - but I thnk there was direct migration to SQL7).SQL 2000 licences for use on the web are very expensive - in dollars I would guess $5,000 to $10,000 per processor.A hosting provider offering a shared SQL database would be affordable, by comparison.Kristen |
 |
|
|
|
|
|
|
|
Upgrading to 2000