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

How do I connect to an existing Mimer Database

How do I connect to an existing Mimer Database

(OP)
Hi All,

I am new to Mimer. I see that tables are stored in Databanks. How can I access an existing databases databanks.
Please help me. It is quite urgent.

RE: How do I connect to an existing Mimer Database

Hi Niteshc,

First of all you have to connect to the database (server). Then you'll have access to all the tables, regardless of which databank they reside in. (As long as you have access rights to the tables.)

You can read more about tables and databanks here:
http://developer.mimer.com/documentation/html_93/Mimer_SQL_Engine_DocSet/DB_environment5.html

"Except at the point when tables are created, the existence of databanks is transparent to users and application programs. When access is requested to a table, information in the data dictionary is used by Mimer SQL to locate the table and make it available, if permissible."


/Jarl

RE: How do I connect to an existing Mimer Database

(OP)
Thanks alot JarlH for the reply. Let me explain the scenario to you but I think this will ot be possible. I have all the information from an existing database from a school. The previous programmers used Mimer. Now that I am developing a new program for them I need to access the existing data. I have all their databanks in my possession.

Would it be possible to get access to this data? Please advise me once again.

RE: How do I connect to an existing Mimer Database

First you'll have to set up a database server using the databanks you have.

1. Make sure Mimer SQL installed on your computer.

2. Use the Mimer Administrator (on Windows) to set up a server for your database (i.e. your collection on databank files).

3. Start the server.

4. Connect to the database server using your favorite SQL query tool (e.g DbVisualizer, WinSQL, BSQL), and now you have access to the data!


HTH,
Jarl

RE: How do I connect to an existing Mimer Database

(OP)
Hi again,

Thanks for the reply. How will I use the existing Databanks. On the Mimer Administrator I get the message : "No databanks found. Do you want to create them"

What should be my next step.Please help. Can you take me through the process. I'd really really appreciate it. Im quite stuck.

RE: How do I connect to an existing Mimer Database

That's a bit strange. Is there a file called sysdb92.dbf or sysdb93.dbf in the folder you specified as home directory?

Which Mimer version are you using?

RE: How do I connect to an existing Mimer Database

(OP)
Yes there is a file called sysdb92. I have all the system databanks also(logdb etc). I am using Mimer SQL 9.3. Do I have to download an older version maybe.

If I place these dbf files in a folder would the Mimer Administrator recognise those files?

RE: How do I connect to an existing Mimer Database

Either install Mimer SQL 9.2 and use the databanks as they are, or use the upgrade functionality in v9.3 to convert the databank files to v9.3. (This is described in the upgrade chapter in Release Notes.)

RE: How do I connect to an existing Mimer Database

(OP)
Thanks alot JarlH. I will try this and get back to you. I can't thank you enough.

RE: How do I connect to an existing Mimer Database

(OP)
Hi JarlH,

I have downloaded Mimer SQL 9.2. Everything seemed to be going according to plan until now. The problem is, I need the password the previous programmers used in order to setup a connection.

I don't know what do do now. sad

RE: How do I connect to an existing Mimer Database

Without password you are lost! (If you have the SYSADM password you can reset the user password, using the ALTER IDENT statement.)

There's no old program code you can search for passwords?

RE: How do I connect to an existing Mimer Database

(OP)
Ok then. I will get my boss to contact someone who maybe knows the password. Thank you so much for your help JarlH. I will let you know what happens. You are a lifesaver. smile

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