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!

*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.

Jobs

Scalable SQL 3.01, Solomon IV, Data Export Problem

Scalable SQL 3.01, Solomon IV, Data Export Problem

(OP)
I inherited this system, running Scalable SQL 3.01 ON NT 3.51 Server, the application is Solomon IV 1.7. I can do everything with Solomon IV, but I can't execute SQL queries or make/modify reports, coz the gentleman before me left without leaving any notes or hints. I don't know the password, I can't use SQLScope to run queries.

I've managed to clear ownership on all the .DAT files, I can dump the data by using BUTIL, I am trying to import the data into PERVASIVE SQL 2000, that looks impossible, it doesn't import it. I am completely lost where to go, any hints, ideas appreciated.

RE: Scalable SQL 3.01, Solomon IV, Data Export Problem

Actually, you shouldn't have to dump the files to get them into Pervasive.SQL 2000i.  You should be able to simply copy them to the 2000i server, create a database, and then open them with PCC.  

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: Scalable SQL 3.01, Solomon IV, Data Export Problem

(OP)
I tried doing that, PCC doesn't recognize the data file, I know the database schema, I created identical table, tried to import from that .DAT file and also BUTIL dump text. PCC wizard doesn't recognize the data structure and it doesn't import. I have the DDF files for the whole database, but those are password protected, I tried to access them using BTSearch, it asks me for 'ownername/password' which I don't know.

RE: Scalable SQL 3.01, Solomon IV, Data Export Problem

(OP)
I've found a solution, I installed Solomon IV on a windows 95 machine (I use virtual PC for testing) moved only the '.dat' files to the existing database folder and I can access all the data and do everything with it. Pervasive has to do a lot more with compatibility if they want to compete in SQL Server environments.

RE: Scalable SQL 3.01, Solomon IV, Data Export Problem

Actually, compatibility is very good with Pervasive. I know of applications that were developed against Btrieve v5.10 and that data is still accessible to current versions of Pervasive.  The key is the application.  If the application doesn't maintain proper DDFs/data files then there could be problems. If there's security on the tables, then there's probably a reason the app wants to keep the data within the app.  

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: Scalable SQL 3.01, Solomon IV, Data Export Problem

I was searching the net and saw your question.  I am looking for the Scalable SQL 3.01 diskette and I was wondering if I could download it off of you or purchase this item from you.  We have solomon 2.06 and we want to move it to a different server but we do not have the disk anymore.  I you or anyone could help us please let me know

Eric Horansky
help@janes.com

RE: Scalable SQL 3.01, Solomon IV, Data Export Problem

See Thread321-773086

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

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!

Resources

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