Solved

Details for earlier post:  "URGENT PLEASE_can't ID screen-flash SQL window..."

Posted on 2011-09-15
6
383 Views
Last Modified: 2012-05-12
Note:  this is a detailed follow-up to an abbreviated description of this problem which was posted earlier:

          URGENT PLEASE_can't ID screen-flash SQL window which may be interfering with QuickBooks

Hello,

The following sequence of events has happened twice with a few slight variations.  The first time was 2-3 days ago.  The second time was earlier this evening (the 14th).

1) Power Outage
The power went out for not more than 5-10 seconds then came back on.  It seemed as though the outage was in my entire house as it was night and I cannot see a thing.  All the lights in my office and an adjoining hall were out and all of my computer and associated equipment went off.  As a result, I had to press the power button on my tower to restart my computer.  I didn't think much of it so I have not asked neighbors if they had a short power outage as well.

2) QuickBooks (QB) won't run
I did not make a connection the first time between the power outage and problems with QB (Pro 2010) since it was a day or two after the outage before I tried to use QB.  (Indeed, there is may be no connection at all but the timing this evening brought the possibility to mind.)  Yesterday was the first time I tried to use QB after the first outage.  I have had no problems with it previously but it had been quite a few days since I had it running.  However yesterday, when I ran it, it could not find the data file (.qbw).  As I was doing some searches to try to get that resolved, QB went down and I got the typical Windows pop-up message when an app fails: "QuickBooks has stopped working."  When I tried to run it again, that same pop up appeared within a couple of seconds.  I tried restarting my computer and a couple of other things (which I don't remember now) but finally concluded that I would just have to reinstall the software.  I found a backup file but realized that I had worked on QB since creating that.  As a result I started looking for the current working file in hopes that I could reinsert that once the software was running again.  To learn if that was OK, I posted a question on the Intuit Community forum:

          Is it OK to grab current data file before re-install, then reinsert it after -- so no data is loss?


One part of the response suggested that I attempt to repair the application through the Control Panel before totally reinstalling it.  I did that and voilà, it worked!  I spent quite a bit of time working on QB after that (because I have tax returns due tomorrow).  :p

Tonight I had worked on QB a bit and although it was open, it was not the active window when the power outage occurred.  It was virtually identical to the earlier outage, lasting just a few seconds.  I had to restart my computer again but this time I could not launch QB.  Each time I would immediately get the "stopped working" pop-up.  Thinking that I could get it running again in a short time, I went back to the Control Panel and went through the repair.  However, this time it would still not launch.  I went back and repaired it a second time but got the same result.  The second time around, I noticed that a small box flashed on the screen just an instant before the repair process was completed.  The flash had been far too short in duration to determine anything about what it was.  Since I had not been watching closely during the first repair, I went through the process of third time and again, there was a brief flash.

I have the Camtasia Studio app installed so I used it to begin recording my screen and went thru the repair process again.  The flash occurred exactly as it had previously so I was able to frame through that point on the recording and capture the image:
 a
I have no idea whether or not the power outage has anything to do with this issue but this flashed window seems like it may.  As closely as I can tell, the window says:

          C:\Users\Steve\AppData\Local\Temp\dofhide.exe

and the screen says:

          SQL Anywhere Command File Hiding Utility Version 11.0.1.2550

I googled both but did not find anything -- at least not anything I understand.  Also, searching that directory (with hidden files and extensions viewable) produced nothing.

It's very late where I live so I've got to call it a night but hopefully some kind and well-SQL-versed person will see this and be able to post a solution before I rise -- that would be a very welcome (and appreciated) relief.

Thanks

PS  Can I refer to the 2nd time around as the SQL Sequel??   :)
0
Comment
Question by:Steve_Brady
  • 3
  • 2
6 Comments
 
LVL 3

Accepted Solution

by:
chandrasekar1 earned 334 total points
ID: 36541637
As far i checked in net, due to some spyware the “dbfhide.exe” got corrupted, so you need to repair or replace the file with right one. I hope it will resolve this issue.

I am checking for any free tools or file download options and let you know.
0
 
LVL 3

Assisted Solution

by:chandrasekar1
chandrasekar1 earned 334 total points
ID: 36541681
0
 
LVL 2

Assisted Solution

by:lbushby
lbushby earned 166 total points
ID: 36541973
Quickbooks uses Sybase's 'SQL Anywhere' as its database engine.

dbfhide.exe is a utility that comes with SQL Anyhwhere that is used to encrypt configuration files used by the engine (see here)

I doubt that the fact that dbfhide is running is the cause of any problem.  My guess would be that the power outage is causing the database used by Quickbooks to become corrupted in some way.

I think you're more likely to find something useful on the Quickbooks support site unless there are any Quickbooks experts on Experts Exchange?

e.g. searching for 'corrupt' on the quickbooks site brings up quite a few results
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:Steve_Brady
ID: 36544004
Thanks for the comments and suggestions.  I will post any new information I come up with.
0
 

Author Comment

by:Steve_Brady
ID: 36567812
Thanks for all the help!

I eventually ended up calling QuickBooks tech support.  The tech ended up going through a number of different steps including doing a clean install (i.e. removing every Intuit folder on my computer).  In the end the problem turned out to be related to having the working .qbw file in a folder with older conflicting QuickBooks files.  Once the .qbw was moved to where it belongs, everything worked fine.

By the way, that correct location is:

C:\Users\Public\Documents\Intuit\QuickBooks\Company Files
0
 

Author Closing Comment

by:Steve_Brady
ID: 36567820
Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now