thank you Helene and Dmitry for your fast and detailled replies...
Actually I have used IBobjects with Interbase but this is my first time I
try to use them with Firebird, after I wrote my first mail I read on the
website that the IB Connection first tries to load the fbclient.dll then
for interbase client, but yesterday when I was trying to connect to a
firebird database (by double clicking on IBConnection component) I was not
allowed to select FDB databases, am I not using the latest IBO version?

When I manually wrote the database path in the property and try to connect
I got the wrong password error while I was able to connect to the same
database with the same password using IB Experts...

Let's assume I install Firebird in a different folder than the default
folder, is IBConnection able to detect it?

Thank you again

Vahan Yoghoudjian






Helen Borrie <helebor@...>
Sent by: IBObjects@yahoogroups.com
12/05/2006 11:00 AM
Please respond to IBObjects


To: IBObjects@yahoogroups.com
cc:
Subject: Re: [IBO] Firebird and IB Objects


At 05:15 PM 12/05/2006, you wrote:

>Hello group, I have a newbie question, I tried to search on the website
>but could not find...
>
>How can I connect a IB_Connection to a Firebird database?

Suppose you want to connect to employee.fdb in its default location
and you don't care about security at this point.

1. drop an ib_connection on your form
2. Set the following properties:
Name: cn1
Server: localhost
Path: c:\Program Files\Firebird\Firebird_1_5\examples\employee.fdb
Protocol: cpTCP_IP
Username: SYSDBA
Password: masterkey
PasswordStorage: psNotSecure

That's it. Of course, you won't see anything unless you hook up a
query to your connection. So, let's look at the Employee table (ROUGH!!)

1. Drop an IB_Query on your form.
2. Set properties:
SQL: select * from employee
IB_Connection: [select cn1]
IB_Transaction: [select <default>}

And you will want a datasource and some controls so you can look at the
data:

1. Drop an IB_Datasource on your form. Set its Dataset property to
IB_Query1.
2. Drop an IB_Grid on your form. Set its Datasource property to
IB_Datasource1.
3. Drop an IB_NavigationBar on the form and set its Datasource
property to IB_Datasource1.

Now, you want some code to get it all going. In your form's OnShow event:
begin
if not cn1.Connected then
cn1.Connect;
if not IB_Query1.Active then
IBQuery1.Open;
end;

Run this and you should see the Employee data.

Helen



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !



SPONSORED LINKS
Database software
Database development software
Inventory database software
Customer database software
Database design software
Membership database software

YAHOO! GROUPS LINKS

Visit your group "IBObjects" on the web.

To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
This is a service contracted by Schneider Electric to avoid Spam.
______________________________________________________________________



[Non-text portions of this message have been removed]