Re: [DUG]: Connecting to Interbase

Mark Howard Thu, 21 Jun 2001 15:00:54 -0700

Willie

This is where I started a couple of days ago (without success)

I put a TDatabase on the form, IBDatabase.

I set it's DatabaseName property to 'D:\IBTEST\IB\MyDB.GDB'

I set the DriverName to INTRBASE

I set the Connected property to True and get "Inavlid Parameter"

I set Params SERVER NAME='D:\IBTEST\IB\MyDB.GDB', try again with same result

What other Param do I need to set?

TIA

Mark

----- Original Message -----

From: Willie

To: Multiple recipients of list delphi

Sent: Thursday, June 21, 2001 11:20 PM

Subject: RE: [DUG]: Connecting to Interbase

Alternatively .....

you could use a TDatabase component of the Data Access components tab - the Database Name (i.e. the GDB file name and path) can be set at run time (and design time by double clicking and entereing the session parameters) as can login name and password.

This uses the BDE but doesn't require an alias.

Or have I misunderstood the question?

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David Smith
Sent: Thursday, 21 June 2001 3:18 p.m.
To: Multiple recipients of list delphi
Subject: RE: [DUG]: Connecting to Interbase

Hi Mark,

Yes this is correct when using the BDE. (as far as I know) Interbase must be connected by an Alias. You could use the IB components and then you can specify a filename to open.

Alternatively you could create dialog that creates a temp alias in the BDE which points to the Interbase db selected.

var

MyList: TStringList;
begin
MyList := TStringList.Create;
try
    with MyList do
    begin
      Add('SERVER NAME=IB_SERVER:/PATH/DATABASE.GDB');
      Add('USER NAME=MYNAME');
    end;
    Session1.AddAlias('NewIBAlias', 'INTRBASE', MyList);
finally
    MyList.Free;
end;
end;

Thanks,

David Smith.

  -----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Howard
Sent: Thursday, 21 June 2001 12:57 PM
To: Multiple recipients of list delphi
Subject: [DUG]: Connecting to Interbase

Hi

With my Paradox database I could just use an OpenFileDialog to point to a file in the Database directory to set this before opening tables. ie I did not have to have an Alias set up in the BDE.

It seems that to connect to Interbase (at this stage using the BDE) I must have an Alias set up.

Can someone confirm this for me please (it might save a lot of time wasting for me trying to do what can't be done)

TIA

Mark

Re: [DUG]: Connecting to Interbase

Reply via email to