• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

urgent .dbs file help please!

Status
Not open for further replies.
msi1337

msi1337

Diamond Member
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.
 
What was response from vendor when they were contacted? Do they have some export/import tool?
 
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.
 
msi1337 said:
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.
Click to expand...

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.
 
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.
 
Documentation on the web indicate a SQLbase type server

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.
Click to expand...

You may be able to get assistance here link

And also, this thread is now showing up on GOOGLE - congrats
 
Looks like the drivers connect to a database server. There are downloads on that same page for sqlbase server as well.
 
msi1337 said:
Vendor wants 250$ an hour to troubleshoot it. No luck opening with excel or access
Click to expand...

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.
 
EagleKeeper said:
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.
Click to expand...

I would be very surprised if the vendor agreed to those terms.
 
KLin said:
I would be very surprised if the vendor agreed to those terms.
Click to expand...

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
 
Status
Not open for further replies.

TRENDING THREADS

Back
Top