Search:

Type: Posts; User: Martin Moleman

Page 1 of 44 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    17
    Views
    752

    Re: DF-20.1 Stored Procedure Call

    Bob,

    Thanks, I could reproduce the error when calling a PostgreSQL function without arguments.
    This will be fixed in the next 20.1 build.
  2. Replies
    17
    Views
    752

    Re: DF-20.1 Stored Procedure Call

    Bob,

    Sorry this took so long. Finally found some time to look into this.

    First, there is something strange going on with calling PostgreSQL stored procedures. I could not get that working yet. ...
  3. Replies
    17
    Views
    752

    Re: DF-20.1 Stored Procedure Call

    Bob,

    I could reproduce the error. Will take a closer look to see what is going on.
  4. Replies
    2
    Views
    301

    Re: DF-20 ODBC Incorrect Data Type

    This was reported before and there is already a fix in the DataFlex 20.1 beta.

    Is it possible for you to try this with DataFlex 20.1 beta? With that version citext columns will be returned as...
  5. Replies
    10
    Views
    438

    Re: DF-20 system table errors

    So is there no index defined on the recnum column?
    I did not try it, but I expect the table can be opened without error if you define an index on recnum.
  6. Replies
    10
    Views
    438

    Re: DF-20 system table errors

    Can you provide a Create Table script for the table.
    If there are indexes defined on the PostgreSQL side, make sure these are included.
  7. Replies
    10
    Views
    438

    Re: DF-20 system table errors

    I think the second part should look like this:

    SYSTEM_FILE YES
    TABLE_CHARACTER_FORMAT ANSI
    USE_DUMMY_ZERO_DATE YES

    So, no RECNUM_TABLE and PRIMARY_INDEX setting, but just a SYSTEM_FILE YES
    ...
  8. Replies
    10
    Views
    438

    Re: DF-20 system table errors

    Can you show the <table>.int file for this table?
  9. Re: Could not load database driver "DFBTRDRV"

    Pervasive 8.6 is really really old. Some 15 years old I would guess. At that time there was no 64bit version for PSQL.

    The current latest version is v15. Actian only supports v13 and later

    For...
  10. Replies
    22
    Views
    1,095

    Re: Embedded SQL funny chars

    First of all, this should work. If you have a Pervasive database with data stored through the DataFlex PSQL driver (DFBTRDRV), you can access this data with ODBC_DRV (embedded SQL) using the...
  11. Replies
    22
    Views
    1,095

    Re: Embedded SQL funny chars

    Hello Jimmy,

    I experimented a little and this works for me. I can write data with accented characters to a PSQL table through DFBTRDRV and read it back with ODBC_DRV with embedded SQL.

    As far...
  12. Replies
    7
    Views
    520

    Re: Collation for MYSQL and Dataflex

    1. No, you can use any database
    2. The driver generates SQL with qualified names, so with a schema name. I don't think you need a search_path in that case?
    3. Not sure I understand, but as a...
  13. Replies
    7
    Views
    520

    Re: Collation for MYSQL and Dataflex

    The following page in the help contains information how to set up a MySQL (Unicode) database with DataFlex 20.0:...
  14. Replies
    3
    Views
    439

    Re: Crash in MSSQLDRV.DLL

    Thanks, this will be fixed in the next build.
  15. Replies
    3
    Views
    439

    Re: Crash in MSSQLDRV.DLL

    Matthew,

    Thanks for reporting.
    What DataFlex / Mssqldrv version was this?

    We have a similar report (crash after error during restructure) that we are currently investigating.

    EDIT: In...
  16. Re: Unknown data type: 'DEFAULT' (MariaDB)

    I could reproduced the issue.
    It will be fixed in next build.
  17. Re: Constantly Getting "DFBTRERR Cannot read from cachefile" with DF 20.0

    This can happen when you have a mix of 32bit programs and 64bit programs. The cch files for 32 and 64bit are not interchangeable.

    For the SQL drivers this was solved by generating separate cch...
  18. Re: Order Entry giving errors with MariaDB 10.6.4

    Peter,

    We could reproduce the issue. Turns out this is related to a recent change with the for update clause. This is not working correct on MariaDB.

    For now you can work around it by turning...
  19. Re: SQL Always On failover cluster instances (FCI)

    You can provide such options at the Additional Connect String Options in the SQL Connection Manager.

    14802
  20. Replies
    6
    Views
    855

    Re: Accessing a MSSQL View

    Can you provide a reproducible case for this?
  21. Re: IsConnectionIdLoggedIn generating error depending on Argument_Size

    Peter,

    Nice catch, I could reproduce what you are seeing.
    We will look into it.
  22. Re: DF 20 - Db2 - Can`t change PK values from dbExplorer

    This is actually a driver issue that we have already a fix for.
    I will send you the latest drivers build with the fix.
    We intend to publish an update shortly.
  23. Re: Problems with stored procedures in Dataflex 2020

    This issue with SQLGetArgument in the DataFlex 20.0 drivers was reported before and we already fixed the issue.

    We intend to publish an update with the fix later this week.
  24. Replies
    86
    Views
    3,951

    Re: What MS SQL Client softwear do I need?

    That command line sets up a DSN. You don't need this. The DataFlex mssqldrv does not use DSNs, but DSN-less connections.
    For DataFlex you should set up connections with SQL Connection Manager in...
  25. Replies
    86
    Views
    3,951

    Re: What MS SQL Client softwear do I need?

    https://docs.dataaccess.com/dataflexhelp/#t=mergedProjects%2FDevelopmentGuide%2FSQL_Database_Drivers_Client_Usage.htm
Results 1 to 25 of 1100
Page 1 of 44 1 2 3 4