Go Back   AnandTech Forums > Software > Programming

Forums
· Hardware and Technology
· CPUs and Overclocking
· Motherboards
· Video Cards and Graphics
· Memory and Storage
· Power Supplies
· Cases & Cooling
· SFF, Notebooks, Pre-Built/Barebones PCs
· Networking
· Peripherals
· General Hardware
· Highly Technical
· Computer Help
· Home Theater PCs
· Consumer Electronics
· Digital and Video Cameras
· Mobile Devices & Gadgets
· Audio/Video & Home Theater
· Software
· Software for Windows
· All Things Apple
· *nix Software
· Operating Systems
· Programming
· PC Gaming
· Console Gaming
· Distributed Computing
· Security
· Social
· Off Topic
· Politics and News
· Discussion Club
· Love and Relationships
· The Garage
· Health and Fitness
· Home and Garden
· Merchandise and Shopping
· For Sale/Trade
· Hot Deals with Free Stuff/Contests
· Black Friday 2014
· Forum Issues
· Technical Forum Issues
· Personal Forum Issues
· Suggestion Box
· Moderator Resources
· Moderator Discussions
   

Closed Thread
 
Thread Tools
Old 11-16-2012, 09:36 PM   #1
msi1337
Diamond Member
 
msi1337's Avatar
 
Join Date: Apr 2003
Location: Maryland
Posts: 7,444
Default urgent .dbs file help please!

I have been trying to help a local store owner I know with an issue that has come up lately. His POS computer which ran the POS software Retail Ice (version 7.0.49) crashed. I was able to recover the database which has his POS information, but it is only a single file named "pos.dbs"

We have had no luck loading the database into the new computer. Every time we try, SQL server crashes with an error 4005 saying the log file is missing.

My question is.. is there any way to extract the data from this file? He is okay to start over with a new DB, but he needs some of the totals from the past years file.

any help is appreciated.
__________________
Heatware (Ranked #14 out of 90,000+ users)
Ebay Feedback
msi1337 is offline  
Old 11-17-2012, 04:50 PM   #2
EagleKeeper
Discussion Club Moderator
Elite Member
 
EagleKeeper's Avatar
 
Join Date: Oct 2000
Location: Bumps west of Denver
Posts: 42,600
Default

What was response from vendor when they were contacted? Do they have some export/import tool?
__________________
F15 Air Superiority Fighter - Never has one been lost in aerial combat (104 kills)
EagleKeeper is offline  
Old 11-17-2012, 06:45 PM   #3
msi1337
Diamond Member
 
msi1337's Avatar
 
Join Date: Apr 2003
Location: Maryland
Posts: 7,444
Default

the vendor won't help. The software is pretty old and they don't offer support unless you have an active account with them. Also, they no longer support the version he is using.
__________________
Heatware (Ranked #14 out of 90,000+ users)
Ebay Feedback
msi1337 is offline  
Old 11-18-2012, 11:12 AM   #4
EagleKeeper
Discussion Club Moderator
Elite Member
 
EagleKeeper's Avatar
 
Join Date: Oct 2000
Location: Bumps west of Denver
Posts: 42,600
Default

Quote:
Originally Posted by msi1337 View Post
the vendor won't help. The software is pretty old and they don't offer support unless you have an active account with them. Also, they no longer support the version he is using.
Without the vendor giving you the database schema, you are screwed.
Between a rock and a hard place; get an active account for the minimum time frame allowed with the requirement that the vendor provide the schema. they may have to upgrade as part of the active account.

Vendors get you by the short hairs by hooking a company on a product and not properly supporting it unless a lot of $$ is continually sent for support contracts.
__________________
F15 Air Superiority Fighter - Never has one been lost in aerial combat (104 kills)
EagleKeeper is offline  
Old 11-18-2012, 12:31 PM   #5
Markbnj
Moderator
Programming
 
Markbnj's Avatar
 
Join Date: Sep 2005
Posts: 13,104
Default

You sure this is a SQL Server file? The only databases I've heard of which use .dbs files are Gupta SqlBase, Sql Anywhere, and one other I can't recall that also isn't SQL Server.
__________________
Everytime I try to tell you, the words just come out wrong

**
Some meaningless scribbling of no account

The 4th Realm

Arts and Letters Daily - Get some culture
Markbnj is online now  
Old 11-19-2012, 07:42 AM   #6
EagleKeeper
Discussion Club Moderator
Elite Member
 
EagleKeeper's Avatar
 
Join Date: Oct 2000
Location: Bumps west of Denver
Posts: 42,600
Default

Documentation on the web indicate a SQLbase type server

Quote:
Copies of the POS.DBS are harder to get, as you
must copy the entire DBS file (and have the
necessary free space to save it) and you must also
make sure no one is logged into POS or Office Star
while you copy, and the SQLbase server must be
stopped. This is because you cannot copy a file that is
be accessed by others. The advantage to this type of
file is that the restore process is much quicker, as you
only have to copy the POS.DBS file back into the
proper folder.
You may be able to get assistance here link

And also, this thread is now showing up on GOOGLE - congrats
__________________
F15 Air Superiority Fighter - Never has one been lost in aerial combat (104 kills)
EagleKeeper is offline  
Old 11-19-2012, 10:29 AM   #7
Tweak155
Diamond Member
 
Tweak155's Avatar
 
Join Date: Sep 2003
Location: Michigan
Posts: 9,082
Default

I worked on a wonky system once and believe it or not I could open the file in Excel. Hey, worth a shot.
__________________
Organo Gold Coffee

Heatware 92-0-0
Tweak155 is offline  
Old 11-19-2012, 11:44 AM   #8
EagleKeeper
Discussion Club Moderator
Elite Member
 
EagleKeeper's Avatar
 
Join Date: Oct 2000
Location: Bumps west of Denver
Posts: 42,600
Default

Quote:
Originally Posted by Tweak155 View Post
I worked on a wonky system once and believe it or not I could open the file in Excel. Hey, worth a shot.


Nothing to lose; Databases apparently embed the schema for interpretation
__________________
F15 Air Superiority Fighter - Never has one been lost in aerial combat (104 kills)
EagleKeeper is offline  
Old 11-19-2012, 02:20 PM   #9
msi1337
Diamond Member
 
msi1337's Avatar
 
Join Date: Apr 2003
Location: Maryland
Posts: 7,444
Default

Vendor wants 250$ an hour to troubleshoot it. No luck opening with excel or access
__________________
Heatware (Ranked #14 out of 90,000+ users)
Ebay Feedback
msi1337 is offline  
Old 11-19-2012, 03:00 PM   #10
KLin
Lifer
 
KLin's Avatar
 
Join Date: Feb 2000
Location: Phreaznaux
Posts: 28,732
Default

http://support.guptatechnologies.com....php/Downloads

Try downloading/installing the driver packs, create an odbc connection and reference the .dbs file, then try linking the tables in access?
__________________
'L_'
KLin is offline  
Old 11-19-2012, 03:03 PM   #11
KLin
Lifer
 
KLin's Avatar
 
Join Date: Feb 2000
Location: Phreaznaux
Posts: 28,732
Default

Looks like the drivers connect to a database server. There are downloads on that same page for sqlbase server as well.
__________________
'L_'
KLin is offline  
Old 11-19-2012, 03:40 PM   #12
EagleKeeper
Discussion Club Moderator
Elite Member
 
EagleKeeper's Avatar
 
Join Date: Oct 2000
Location: Bumps west of Denver
Posts: 42,600
Default

Quote:
Originally Posted by msi1337 View Post
Vendor wants 250$ an hour to troubleshoot it. No luck opening with excel or access
I suspect that more than $250 is being spent trying to solve the problem.

Pay the $250/hr for a set maximum (2-3 hrs) with the understanding that if the situation is not resolved before the max - no payment is made.
__________________
F15 Air Superiority Fighter - Never has one been lost in aerial combat (104 kills)
EagleKeeper is offline  
Old 11-19-2012, 05:33 PM   #13
KLin
Lifer
 
KLin's Avatar
 
Join Date: Feb 2000
Location: Phreaznaux
Posts: 28,732
Default

Quote:
Originally Posted by EagleKeeper View Post
I suspect that more than $250 is being spent trying to solve the problem.

Pay the $250/hr for a set maximum (2-3 hrs) with the understanding that if the situation is not resolved before the max - no payment is made.
I would be very surprised if the vendor agreed to those terms.
__________________
'L_'
KLin is offline  
Old 11-19-2012, 07:45 PM   #14
EagleKeeper
Discussion Club Moderator
Elite Member
 
EagleKeeper's Avatar
 
Join Date: Oct 2000
Location: Bumps west of Denver
Posts: 42,600
Default

Quote:
Originally Posted by KLin View Post
I would be very surprised if the vendor agreed to those terms.
Much depends of the vendor has the solution.

As a vendor, that is the only reason to accept such conditions.

Potentially look for a specialist or (hate to say this) but contract offshore for someone that can crack the schema
__________________
F15 Air Superiority Fighter - Never has one been lost in aerial combat (104 kills)
EagleKeeper is offline  
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 01:44 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.