Skip to content

Delphi Data Access Components

Delphi Data Access Components is a line of DB connectivity solutions for such databases as: Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, Microsoft Access, DB2, Sybase Advantage Database Server, Sybase Adaptive Server Enterprise, and other databases (using ODBC provider).

http://www.devart.com/dac.html

Delphi Data Access Components

Categories

JUMP TO ANOTHER FORUM

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

243 results found

  1. I would like to use complex connect strings similar to JDBC thin driver, e.g.
    (DESCRIPTION=(CONNECTTIMEOUT=5)(TRANSPORTCONNECTTIMEOUT=3)(RETRYCOUNT=5)
    (ADDRESSLIST=(LOADBALANCE=OFF)(FAILOVER=ON)
    (ADDRESS=(PROTOCOL=tcp)(HOST=xyz1.abc.def.loc)(PORT=1521))
    (ADDRESS=(PROTOCOL=tcp)(HOST=xyz2.abc.def.loc)(PORT=1521)))
    (CONNECTDATA=(SERVICENAME=ABCD_GCSTANDBY)))

    It is similar to the entries you can put into the TNSNAMES.ORA file.

    It looks like ODAC.net does support something similar,
    I would like to have it in the VCL version.

    To us, the most important thing is Connect Time Failover

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Oracle  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. In dbMonitor on the parameters screen it would be wonderful to be able to right click and copy the parameter value. We use lots of GUIDs and that would make life so much better when debugging.

    Or can I download the source code for dbMonitor and edit it myself?

    thanks,

    Jon.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. db Monitor has fetch checkbox that is useless at the moment.
    It would be nice if the fetch time would be sent to the db monitor

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Common  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. Connection Pooling should work in multi threaded environments with transactions.
    I think the current design may be flawed. I think there should be a special connectionpool with which connections can be linked. in a multi-threaded environment, you want the thread to grab a connection, use it, and release it. at the moment, if you want to start a transaction, with connection pooling enabled, the current connection is basically blocked as it does not do anything smart in tracking the underlying connection to a thread. I currenltly get an error - cannot start transaction when one is already active... so I…

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. Actually (v6.2.4), the PgDac TPgDump component does not generate appropriate code for inherited tables, making it useless when inherited tables are used, and we need to get the SQL script to generate the given schema.

    TPgDump should support tables inheritance and:
    - create base tables before inherited tables
    - use the inherits clause within the table creation sql statement
    - do not generate insert statements for base tables data, only for inherited tables

    Thanks,

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  PostgreSQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. It would be great if UNIDAC could allow the use of multiple connection pools. For example I need two connetion pools to 2 different databases at the same application. This is currently not supported in UNIDAC

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. Hello,

    I'am testing multithreading with IBDac. For the moment the solution I have found is :
    1) Execute a TIbcquery in a thread
    2) Copy the result of 1) into a Memory Dataset (in the main thread) when 1) finished.

    I would like to know if it possible to do something like Firedac :
    https://delphi.programmingpedia.net/en/tutorial/4114/retrieving-updated-tdataset-data-in-a-background-thread
    or
    https://riptutorial.com/fr/delphi/example/14361/exemple-firedac

    The very interesting to transfer data between Query is the property :

    Form.FDQuery1.Data := Query.Data;

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. They should have a component that easily imports data from excel, csv or text into a table and that supports large files.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. It's about time dbMonitor had a long awaited upgrade with some really basic common sense pieces of functionality added.

    1) Add buttons to clear terminated processes and all processes. Come on guys, having to select each process one by one to clear it is, quite frankly, ridiculous and poor UI design.

    2) Parameters should be formatted according to the DB you're connected to.
    E.g. for Oracle
    Like this...
    :SrcSchema VARCHAR2(13) :='MY_SCHEMA' ;

    rather than this

    :SrcSchema(VARCHAR[13])='MY_SCHEMA'
    Why? Well it allows us developers to set up anonymous blocks quickly to test the same call, if say an error occurs. Currently I…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Common  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. It would be Nice to have implementation of:
    - TUniQuery.CommandTimeOut
    - TUniQuery.Options.NullForZeroDate

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. Please implement the support of AutoCreateMode in your components.

    Further description:
    http://docwiki.embarcadero.com/Libraries/Rio/en/Data.DB.TFieldOptions.AutoCreateMode

    With this option it's possible to create calculated fields in design time and all other fields will be added automaticly on runtime.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. Add support for Firebird 3 item iscdpbauthpluginlist and iscspbauthpluginlist. At the moment I am not able to specify what plugins are available to log in to Firebird 3.0 (Legycy_auth, Aug, Aug256)

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. When you add a new sql function at runtime (TLiteUtils.RegisterFunction) you can't use it at design time in a UniQuery because the function is unknown.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. It would be good to have the ability to populate a table direct from CSV file

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. It is very important nowadays in using oracle cloud services, which require using the oracle Wallet, especially for ADW and ADT.

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Oracle  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. Dar soporte para archivos csv

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. As the "coInvertNullOrder" flag -for client side sorting the dataset- is already imlpemented for some of the providers, it would be nice to be able to control the default method how NULL values are sorted (comes as first or comes as last).

    The best approach would be to be able to control this over f.e. with an "IN" postfix in the IndexFieldNames, per field.

    Like: "SomeField DESC IN;OtherField ASC"

    Thx.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. dbMonitor - Define in the application for each TUniConnection if it sends messages to dbMonitor or not.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. FillFieldsDefaultValues (in TCustomDADataSet.DataEvent) procedure is called everytime for a dataset, if Options.DefaultValues is True. It creates a query to get the default values. It might be a good idea to cache the defaults and avoid the query.

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?