Re: Access DB for Multi-user

Hi,

I installed Firebird and EMS Firebird Manager. I created the tables and
connected them to Delphi using
InterBase Database, Transaction and Table components. I have two questions:

- How can I auto login to db? (Each time it displays a login window.)

- It displays a message : "Dynamic SQL Error SQL Error Code = -206 Column
Unknown=COUNTRY At line 2, column 8"
There is a COUNTRY field in the db and the table component. I am trying to
filter them with a code in main form's OnShow
event:

IBTable1.Close;
IBTable1.Filtered := False;
IBTable1.Filter := 'Country= USA'
IBTable1.Filtered := True;
IBTable1.Open;

Thanks,
Can Karaca


"listmember" <listmember@xxxxxxxxxxxxxxx> wrote in message
news:xn0e4w1rq1lerp400s@xxxxxxxxxxxxxxxxxxxxx
>> I am using an Access DB for a single user application. I connect to
>> DB with ADO Connection
>> and a connection string. Can I use my application more than one
>> computer if I get connected to
>> the Access DB from each computer? Can be any problem?
>
> Can,
>
> Why dont you consider replacing Access with Firebird or
> PostgeSQL?
>
> Both are much better and as easy to use.
>
> You can still use Access to manipulate them too.


.

Relevant Pages

  • ANN: InterXpress for Firebird 1.0.8 released!
    ... "InterXpress for Firebird" is our driver that supports Borlands ... Server Edition with Connection Pooling ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Recommendation
    ... you need a seperate connection (rather than session) ... I would highly recommend Firebird. ... > I have one indy server and in each thread of server i create one session ...
    (borland.public.delphi.thirdpartytools.general)
  • ANN: InterXpress for Firebird 1.0.9 released
    ... "InterXpress for Firebird" is our driver that supports Borlands ... Server Edition with Connection Pooling ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: [opensuse] How to see what is blocking IP requests?
    ... There is a second interface for local connections only, but I can't remember what it is called. ... I don't think it is being blocked, firebird is refusing the connection. ... determine what interfaceit is listening on. ...
    (SuSE)
  • [opensuse] Re: How to see what is blocking IP requests?
    ... If I try to connect to the server in local mode, ... If I then try to connect with IP locally using 127.0.0.1 the connection is actively refused. ... (I assume that the firebird daemon name starts with "firebird", otherwise you need a different -c argument.) ... It is actually listening through xinetd. ...
    (SuSE)