×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Password Recovery Clarion .dat files

Password Recovery Clarion .dat files

Password Recovery Clarion .dat files

(OP)
We have an application that extracts data from .dat files using TOPSCAN and loads the data into a warehouse. The programmer responsible for that application got...upset and changed the owner password for those files and then left. Obviously we now have a problem. We have about three years of history in those files that I am afraid we cannot recover. Our backup cycle is 14 days and we only extract data once a month. So you can see the situation. Is there a utility to reset/recover those passwords for someone with full administrator access to the system? The server base is W2K. We did get the passwords straight for the TPS files.

RE: Password Recovery Clarion .dat files

TOPSCAN works only with Topspeed files (*.TPS) - When you try to open a Clarion DAT file, it asks for a password because it cannot understand the header format. So maybe there is no password at all. You can open Clarion DAT files from the Database Browser within the Clarion Development Environment OR using an DOS utility called CSCN.exe (which was part of Clarion 2.1) OR other 3rd party tools. There is a freeware utility written in Clarion called XSCAN written by Vadim Berman. You could check that out. The website is www.power10.co.il/en and the contact e-mails are info@www.power10.co.il and support@www.power10.co.il.

RE: Password Recovery Clarion .dat files

(OP)
Thank you. I mistated my problem. I need a utility to extract data from the .dat and .tps files and load into a format that can be imported into the data mine. The data files aren't protected, it is the extraction code that was protected. Hopefully I can find something and not have to write extractors all over again.

RE: Password Recovery Clarion .dat files

TOPSCAN has an Export option (File --> Export) which allows you to export TPS files into a Text file (ASCII). Clarion 2.1 has a CCVT.exe which allows you to convert from Clarion to dBASE or Text file. XSCAN also has an option to copy data records between files which can be used to convert to a Text file. The only problem is that XSCAN expects the File Definition in the same format as used in Clarion programs - so you will have to create those definitions.

If you do program in Clarion, you could create a Export Program quite easily with or without the help of 3rd party products like the Import/Export template from Sterling Data.

If you do not have Clarion 2.1 and want the CSCN & CCVT utility programs, reply with your e-mail address and I shall mail it to you.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close