BullCharts Forum Homepage
Forum Home Forum Home > BullCharts > BullCharts discussion
  New Posts New Posts RSS Feed: Re-installation woes (again)
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Re-installation woes (again)

 Post Reply Post Reply
Author
Message / View First Unread Post
kneighbour View Drop Down
Regular
Regular
Avatar

Joined: 12 Feb 2005
Location: Australia
Posts: 57
Post Options Post Options   Quote kneighbour Quote  Post ReplyReply Direct Link To This Post Topic: Re-installation woes (again)
    Posted: 28 Apr 2005 at 2:36pm

I have just re-installed Win XP on my main machine. The spyware was just getting too much. I would love to move to Linux....

Anyway, I have the same issue this time in installing MSDE. It took me 4 hours last time to finally get it to install. I accepted that as my system had been a few months without a re-install, and as we all know, for MS that is quite a while :)

But this is a brand new Win XP. I have only installed a firewall (Trend-Micro) and the MS Antispyware software. Nothing else. Bullcharts goes on ok, then it asks to install the MSDE. It tries to do this, and gets to about 80% on the progress dialog, then just sits there. I left it overnight just to see if it simply took a long time, but it was still sitting there this morning. I have tried this about 3 times now (ie killing the process and starting again). Each time it stops. It did create an error log file, but it says nothing useful (at least not to me).

My machine is an Intel P4 1.7GHz, 512 RAM machine. I am connected via a router to Telstra cable.

Do you have any suggestions that I can try?  I think that the last time I downloaded newer versions from MS and tried several installs. It finally worked, but what worked in the end I now forget. As I said, it took 4 hours of stuffing around - I do not want to go down that route again if I can help it - although so far it has probably taken me an hour.

I have to say that choosing to use the MSDE is unfortunate. It is VERY slow at the best of times. Can I put in my vote for your programmers to look at using a better DB engine? Even the size of the DB file is ridiculous - 405 megs! This should really be less than 100 megs - so it is no wonder it is so slow.

And it is not merely academic. It is so slow to load I often click the shortcut again as it seems nothing is happening. You then get error messages. I also have to wait a LONG time for some screens to load as I use a lot of ribbons - and some indicators take ages to draw. It is really affecting how I use the program, and that is not a good thing. Mind you, at the moment I cannot use it at all...

 

 

 

 



Edited by kneighbour
Back to Top
Tim Allen View Drop Down
BullCharts Staff
BullCharts Staff
Avatar

Joined: 10 Sep 2004
Location: Australia
Posts: 53
Post Options Post Options   Quote Tim Allen Quote  Post ReplyReply Direct Link To This Post Posted: 28 Apr 2005 at 4:25pm
Originally posted by kneighbour

But this is a brand new Win XP. I have only installed a firewall (Trend-Micro) and the MS Antispyware software. Nothing else. Bullcharts goes on ok, then it asks to install the MSDE. It tries to do this, and gets to about 80% on the progress dialog, then just sits there. I left it overnight just to see if it simply took a long time, but it was still sitting there this morning. I have tried this about 3 times now (ie killing the process and starting again). Each time it stops. It did create an error log file, but it says nothing useful (at least not to me).

  • Make sure "Microsoft SQL Server Desktop Engine" doesn't appear in the Add/Remove Programs control panel - uninstall it if it does.
  • Delete "C:\Program Files\Microsoft SQL Server\MSSQL\" if it still exists, just to clear off any last vestiges of MSDE from your system.
  • Reboot, just to be totally completely sure.
  • Go to "C:\Program Files\BullSystems\BullCharts\MSDE\" and run the setup.exe directly. Hopefully it works, now that we've removed the most common causes of trouble.
  • If it doesn't work, make a copy of "C:\MSDELog.log" before you cancel or kill the installer - when you kill the installer, it writes a whole lot of "shutting down" stuff to the log file which just obscures what the real problem is.
  • Once you have a logfile, the last few lines should describe what the installer was trying to do when it hit a problem. You can either try and examine it yourself (You can read the Microsoft Support article about troubleshooting an MSDE installation), or send it to info@bullsystems.com.au and we'll try to figure out what's gone wrong.

Originally posted by kneighbour

I have to say that choosing to use the MSDE is unfortunate. It is VERY slow at the best of times. Can I put in my vote for your programmers to look at using a better DB engine?

When we first set up the database engine for BullCharts, the alternative was using a Microsoft Access database and MSDE is much faster than Access. Any alternative database engines would have to be incredibly easy to implement into BullCharts or incredibly fast in order to justify the engineering effort of replacing a very large and complicated piece of software that mostly works fairly well.

Back to Top
kneighbour View Drop Down
Regular
Regular
Avatar

Joined: 12 Feb 2005
Location: Australia
Posts: 57
Post Options Post Options   Quote kneighbour Quote  Post ReplyReply Direct Link To This Post Posted: 28 Apr 2005 at 9:50pm

Originally posted by Tim Allen

When we first set up the database engine for BullCharts, the alternative was using a Microsoft Access database and MSDE is much faster than Access. Any alternative database engines would have to be incredibly easy to implement into BullCharts or incredibly fast in order to justify the engineering effort of replacing a very large and complicated piece of software that mostly works fairly well.

Well, this is what I do for a living - I write database applications. I agree that MSDE is better than using MS Access. But almost any DB engine is better than Access/MSDE. I could name several. And all would be faster and smaller and give you less support issues. And do not forget that every user has to run the MSDE - that is always running on my machine, even if Bullcharts is not. I don't particularly like that.

Converting the DB is childs play. I could probably do it in an afternoon. There is very little engineering involved. There are several tools around that do just that. The harder bit is modifying your code to talk to the different DB engine. They all have their little quirks. But since most DB engines now are SQL based, it should be fairly simple. I would certainly mention it to your software guys, and let them mull it over for the next year. If they are any good (and I suspect that that are), then they will already be thinking of how to fix the speed problems.

Anyway, I don't suggest that you seriosuly look at it right now. But I have to say that it is a big handicap. For a start, I cannot run it on my old Windows 98 machine. I have to say that there are still a lot of people out there running these old systems still. I still use Win 95 at work, for example. And of course the speed is a very real issue. I am thinking of upgrading my machine with more RAM and a faster CPU just so that I can use Bullcharts. I should not have to do that.

Back to Top
kneighbour View Drop Down
Regular
Regular
Avatar

Joined: 12 Feb 2005
Location: Australia
Posts: 57
Post Options Post Options   Quote kneighbour Quote  Post ReplyReply Direct Link To This Post Posted: 28 Apr 2005 at 9:53pm

Originally posted by Tim Allen

Make sure "Microsoft SQL Server Desktop Engine" doesn't appear in the Add/Remove Programs control panel - uninstall it if it does.

Here is a good one for you. I just installed Win XP Service Pack 2. For no good reason - but when I rebooted, the MSDE was running! And now Bullcharts works ok. That is really weird as the MSDE install definately did not finish.

Anyway, it is now all working. Thanks fo the tips.

Back to Top
Tim Allen View Drop Down
BullCharts Staff
BullCharts Staff
Avatar

Joined: 10 Sep 2004
Location: Australia
Posts: 53
Post Options Post Options   Quote Tim Allen Quote  Post ReplyReply Direct Link To This Post Posted: 29 Apr 2005 at 9:44am
Originally posted by kneighbour

Originally posted by Tim Allen

Make sure "Microsoft SQL Server Desktop Engine" doesn't appear in the Add/Remove Programs control panel - uninstall it if it does.

Here is a good one for you. I just installed Win XP Service Pack 2. For no good reason - but when I rebooted, the MSDE was running! And now Bullcharts works ok. That is really weird as the MSDE install definately did not finish.

Anyway, it is now all working. Thanks fo the tips.


That is weird. Oh well, I'll add it to our BullCharts support documentation - I'm glad to hear everything's working for you again!

Back to Top
Brendon View Drop Down
BullCharts Staff
BullCharts Staff
Avatar

Joined: 10 Sep 2004
Location: Australia
Posts: 126
Post Options Post Options   Quote Brendon Quote  Post ReplyReply Direct Link To This Post Posted: 29 Apr 2005 at 11:53am
We are looking at different options for later.  If you would like to email me some db ideas it will help.  brendonl@weblink.com.au
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Bulletin Board Software by Web Wiz Forums® version 9.69
Copyright ©2001-2010 Web Wiz