urgent .dbs file help please!

Discussion in 'Programming' started by msi1337, Nov 16, 2012.

Thread Status:
Not open for further replies.
  1. msi1337

    msi1337 Diamond Member

    Joined:
    Apr 16, 2003
    Messages:
    7,605
    Likes Received:
    0
    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.
     
  2. EagleKeeper

    EagleKeeper Discussion Club Moderator<br>Elite Member
    Staff Member

    Joined:
    Oct 30, 2000
    Messages:
    42,600
    Likes Received:
    0
    What was response from vendor when they were contacted? Do they have some export/import tool?
     
  3. msi1337

    msi1337 Diamond Member

    Joined:
    Apr 16, 2003
    Messages:
    7,605
    Likes Received:
    0
    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.
     
  4. EagleKeeper

    EagleKeeper Discussion Club Moderator<br>Elite Member
    Staff Member

    Joined:
    Oct 30, 2000
    Messages:
    42,600
    Likes Received:
    0
    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.
     
  5. Markbnj

    Markbnj Elite Member <br>Moderator Emeritus
    Moderator

    Joined:
    Sep 16, 2005
    Messages:
    15,687
    Likes Received:
    8
    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.
     
  6. EagleKeeper

    EagleKeeper Discussion Club Moderator<br>Elite Member
    Staff Member

    Joined:
    Oct 30, 2000
    Messages:
    42,600
    Likes Received:
    0
    Documentation on the web indicate a SQLbase type server

    You may be able to get assistance here link

    And also, this thread is now showing up on GOOGLE - congrats
     
  7. Tweak155

    Tweak155 Lifer

    Joined:
    Sep 23, 2003
    Messages:
    10,292
    Likes Received:
    18
    I worked on a wonky system once and believe it or not I could open the file in Excel. Hey, worth a shot.
     
  8. EagleKeeper

    EagleKeeper Discussion Club Moderator<br>Elite Member
    Staff Member

    Joined:
    Oct 30, 2000
    Messages:
    42,600
    Likes Received:
    0
    :thumbsup:

    Nothing to lose; Databases apparently embed the schema for interpretation
     
  9. msi1337

    msi1337 Diamond Member

    Joined:
    Apr 16, 2003
    Messages:
    7,605
    Likes Received:
    0
    Vendor wants 250$ an hour to troubleshoot it. No luck opening with excel or access
     
  10. KLin

    KLin Lifer

    Joined:
    Feb 29, 2000
    Messages:
    29,330
    Likes Received:
    3
  11. KLin

    KLin Lifer

    Joined:
    Feb 29, 2000
    Messages:
    29,330
    Likes Received:
    3
    Looks like the drivers connect to a database server. There are downloads on that same page for sqlbase server as well.
     
  12. EagleKeeper

    EagleKeeper Discussion Club Moderator<br>Elite Member
    Staff Member

    Joined:
    Oct 30, 2000
    Messages:
    42,600
    Likes Received:
    0
    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.
     
  13. KLin

    KLin Lifer

    Joined:
    Feb 29, 2000
    Messages:
    29,330
    Likes Received:
    3
    I would be very surprised if the vendor agreed to those terms.
     
  14. EagleKeeper

    EagleKeeper Discussion Club Moderator<br>Elite Member
    Staff Member

    Joined:
    Oct 30, 2000
    Messages:
    42,600
    Likes Received:
    0
    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
     
Loading...
Thread Status:
Not open for further replies.