• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

Interbase 6 Open Source

I installed Interbase 6 Open Source, and I have two questions:

1. What about it's reliability and limitations (Concurrent connections, database limit) and what is the difference between the Open Source edition and other editions. Also the doployment and licensing.

Please don't point me to www.borland.com/interbase, I tried to read that pages but I get nothing

2. How to upgrade from Interbase 5 database to 6 Database. I cann't open old Interbase 5.5 database

Thanks Motaz
0
Motaz
Asked:
Motaz
  • 11
  • 5
  • 2
  • +1
1 Solution
 
MotazAuthor Commented:
Actually it is 6.01
0
 
rondiCommented:
Sorry, this may be slightly off topic, but is Interbase
written in Delphi ?
(just curious)
0
 
MotazAuthor Commented:
Interbase is a Database server developed by Borland, and it is shipped freely with Delphi CD, unfortunately no one know what is Interbase, only Delphi and C++Builder people know it, so that I ask this question here, and all Interbase users ask thier questions here. Also remmember that there is no Interbase topic in Database area.

Motaz
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
rondiCommented:
I wasn't saying your comment is in the wrong area :)
I just wanna know what language Interbase is written in.
I'm hoping it's Delphi, coz then I could enjoy going through some of the code & learn how ppl write relational database systems. I'd also be proud that my favoritest
language in the whole world was used to create such a
neat product.

rondi.
0
 
MotazAuthor Commented:
I'm not sure, but I think it is written in C, because Interbase is old.
Delphi can create databases such as Interbase and Oracle, C++Builder is written by Delphi, also JBuilder, and Delphi is also written by Delphi.

Don't worry Rondi, your favorate language is the best and create any thing in Windows, except only one thing: Device drivers, but may be in the next future Borland may support it.

www.geocities.com/motaz1
Motaz Abdel Azeem
0
 
lucikaCommented:
Hi

2. It is necessary in version 5 with the help of the gbak utility to make backup of base. And then in 6 versions with the help of the same utility restore.
0
 
ITugayCommented:
listenning.....

0
 
MotazAuthor Commented:
Oh no, Igor listening, I thought that Igor will solve this question.

Motaz
0
 
MotazAuthor Commented:
Igor, what version of Interbase you are using now?

Motaz
0
 
ITugayCommented:
Hi Motaz,

I'm using IB6 now. There is no problem to convert 5 version to 6.
You should backup your database from IB5 then restore it under IB6.
To make database compatible with previous version, use first dialect for database.
Be carefull, seemes no way to convert DB back from 6 to 5.

------
Igor.
0
 
MotazAuthor Commented:
Thanks Igor, ok which licence did you using now in Interbase 6?

Motaz
0
 
ITugayCommented:
I'm using downloaded from Borland IB6. It allow 4 user * 4 connections = 20 clients simulately. First time I was surprised that it allow more then 4 user, but later I understood that every user can have 4 different names :-)

-----
Igor.
0
 
MotazAuthor Commented:
Igor, I encounter problem when I deploy my application that uses IBX components, I copy gds32.dll, but I still get a problem about socket connection. I'm connecting to the server using TCP/IP. What else I need to distribute?
0
 
MotazAuthor Commented:
>4 different names :-)

What did you mean by this?
0
 
MotazAuthor Commented:
How can I backup the database using gbak?
0
 
ITugayCommented:
Hi Motaz,

do not copy gds32.dll, it's hackers way. You should install IB client to user's computer, it's normall way. You can download IB client from Borland's site.

>4 different names :-)

> What did you mean by this?

I mean that IB supports 4*4 connections indeed. Let say that you have four login names:

Motaz1, Motaz2.. Motaz4

Interbase allow you to make four connections. How it can decide that all four names are yours? - No way, right? So, it allow 16 different connections :-) At first I think that every user can have four connection with the same login name, but after do some experiments I noticed that it allow 16 different logins in the same time. Strange, but it works.

Backup:
use server manager instead of gbak, it would be much easy then to write command line with a lot of parameters. You will get a problems if you do not make a backup before install IB6 on the same computer over of IB5. In this case you have to install IB5 on different computer, copy your database there and make a backup file with "transportable format" option. Then copy backup file to computer with IB6 installed and restore database.

-----
Igor
0
 
MotazAuthor Commented:
Thanks Igor for all these informaion.
I tried multiple connection from a small app. (Opening Table in a grid) I can run 40 instances or more, with the same login (SYSDBA)

Did you download a free version of IB6 or you buy a liecenced version?
0
 
ITugayCommented:
Hi Motaz,

thanx for pts;-)

yes, I just downloaded it from Borland and did not buy any licensed version.

Igor.
0
 
MotazAuthor Commented:
Dear Igor,
Please see this question, it prevents me of sleeping.

http://www.experts-exchange.com/jsp/qManageQuestion.jsp?ta=delphi&qid=20181141
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 11
  • 5
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now