Hi,

I have built latest xHarbour and SQLRDD using BCC73. Running the demo01.prg and selecting ODBC, I encountered the following error. I think this is related to conversion from DBF Logical Data Type to FB Boolean. Selecting "Firebird Native" connection
works without problem though.

***************************************************************
Connecting to dsn=FBODBC;
Connected to : FIREBIRD 06.03.2975 WI-V Firebird 4.0
RDD in use : SQLEX
Error SQLRDD/0 SQL execution error at dbGoTop, return code: -1, state: HY000, description: [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 10. Arguments: ( [ 1] = Type: C Val: SELECT A.)

Error at ...: dbGoTop(2737) in Module: ..\source\sqlex1.c
Called from : MAIN(45) in Module: demo01.prg

C:\xharbour\xHarbourBuilder\xHarbour-SQLRDD\samples> **********************************************************************

Selecting ODBC using PostgresSQL 9.3 does not proceed and no error log was generated. Native PostgreSQL works fine though and have better performance than FirebirdSQL
*********************************************
Connecting to dsn=pgs9; Connected to : POSTGRESQL 9.3.25 RDD in use : SQLEX
*******************************************

Thank you for your great work and contributions to community.

Best regards,
Mario

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

El jueves, 31 de agosto de 2023 a la(s) 01:31:02 UTC-6, Mario H. Sabado escribió:

Hi,

I have built latest xHarbour and SQLRDD using BCC73. Running the demo01.prg and selecting ODBC, I encountered the following error. I think this is related to conversion from DBF Logical Data Type to FB Boolean. Selecting "Firebird Native" connection

works without problem though.

***************************************************************
Connecting to dsn=FBODBC;
Connected to : FIREBIRD 06.03.2975 WI-V Firebird 4.0
RDD in use : SQLEX
Error SQLRDD/0 SQL execution error at dbGoTop, return code: -1, state: HY000, description: [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 10. Arguments: ( [ 1] = Type: C Val:
SELECT A.)

Error at ...: dbGoTop(2737) in Module: ..\source\sqlex1.c
Called from : MAIN(45) in Module: demo01.prg

C:\xharbour\xHarbourBuilder\xHarbour-SQLRDD\samples> **********************************************************************

Selecting ODBC using PostgresSQL 9.3 does not proceed and no error log was generated. Native PostgreSQL works fine though and have better performance than FirebirdSQL
*********************************************
Connecting to dsn=pgs9; Connected to : POSTGRESQL 9.3.25 RDD in use : SQLEX *******************************************

Thank you for your great work and contributions to community.

Best regards,
Mario

me perece que hay dos versiones del cliente: firebird y firebird3 podrias probar con el firebird3?

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Mario

Which firebird version ?

Regards
Luiz



Em quinta-feira, 31 de agosto de 2023 às 04:31:02 UTC-3, Mario H. Sabado escreveu:

Hi,

I have built latest xHarbour and SQLRDD using BCC73. Running the demo01.prg and selecting ODBC, I encountered the following error. I think this is related to conversion from DBF Logical Data Type to FB Boolean. Selecting "Firebird Native" connection

works without problem though.

***************************************************************
Connecting to dsn=FBODBC;
Connected to : FIREBIRD 06.03.2975 WI-V Firebird 4.0
RDD in use : SQLEX
Error SQLRDD/0 SQL execution error at dbGoTop, return code: -1, state: HY000, description: [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 10. Arguments: ( [ 1] = Type: C Val:
SELECT A.)

Error at ...: dbGoTop(2737) in Module: ..\source\sqlex1.c
Called from : MAIN(45) in Module: demo01.prg

C:\xharbour\xHarbourBuilder\xHarbour-SQLRDD\samples> **********************************************************************

Selecting ODBC using PostgresSQL 9.3 does not proceed and no error log was generated. Native PostgreSQL works fine though and have better performance than FirebirdSQL
*********************************************
Connecting to dsn=pgs9; Connected to : POSTGRESQL 9.3.25 RDD in use : SQLEX *******************************************

Thank you for your great work and contributions to community.

Best regards,
Mario

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On Friday, September 1, 2023 at 12:25:32 AM UTC+8, Carlos Vargas wrote:

El jueves, 31 de agosto de 2023 a la(s) 01:31:02 UTC-6, Mario H. Sabado escribió:

Hi,

I have built latest xHarbour and SQLRDD using BCC73. Running the demo01.prg and selecting ODBC, I encountered the following error. I think this is related to conversion from DBF Logical Data Type to FB Boolean. Selecting "Firebird Native" connection

works without problem though.

***************************************************************
Connecting to dsn=FBODBC;
Connected to : FIREBIRD 06.03.2975 WI-V Firebird 4.0
RDD in use : SQLEX
Error SQLRDD/0 SQL execution error at dbGoTop, return code: -1, state: HY000, description: [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 10. Arguments: ( [ 1] = Type: C Val:
SELECT A.)

Error at ...: dbGoTop(2737) in Module: ..\source\sqlex1.c
Called from : MAIN(45) in Module: demo01.prg

C:\xharbour\xHarbourBuilder\xHarbour-SQLRDD\samples> **********************************************************************

Selecting ODBC using PostgresSQL 9.3 does not proceed and no error log was generated. Native PostgreSQL works fine though and have better performance than FirebirdSQL
*********************************************
Connecting to dsn=pgs9; Connected to : POSTGRESQL 9.3.25 RDD in use : SQLEX
*******************************************

Thank you for your great work and contributions to community.

Best regards,
Mario

me perece que hay dos versiones del cliente: firebird y firebird3 podrias probar con el firebird3?

Hola Carlos,

Yes, I'm using version of firebird lib and client.

Thanks,
Mario

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On Friday, September 1, 2023 at 1:36:03 AM UTC+8, cul...@gmail.com wrote:

Mario

Which firebird version ?

Regards
Luiz
Em quinta-feira, 31 de agosto de 2023 às 04:31:02 UTC-3, Mario H. Sabado escreveu:

Hi,

I have built latest xHarbour and SQLRDD using BCC73. Running the demo01.prg and selecting ODBC, I encountered the following error. I think this is related to conversion from DBF Logical Data Type to FB Boolean. Selecting "Firebird Native" connection

works without problem though.

***************************************************************
Connecting to dsn=FBODBC;
Connected to : FIREBIRD 06.03.2975 WI-V Firebird 4.0
RDD in use : SQLEX
Error SQLRDD/0 SQL execution error at dbGoTop, return code: -1, state: HY000, description: [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 10. Arguments: ( [ 1] = Type: C Val:
SELECT A.)

Error at ...: dbGoTop(2737) in Module: ..\source\sqlex1.c
Called from : MAIN(45) in Module: demo01.prg

C:\xharbour\xHarbourBuilder\xHarbour-SQLRDD\samples> **********************************************************************

Selecting ODBC using PostgresSQL 9.3 does not proceed and no error log was generated. Native PostgreSQL works fine though and have better performance than FirebirdSQL
*********************************************
Connecting to dsn=pgs9; Connected to : POSTGRESQL 9.3.25 RDD in use : SQLEX
*******************************************

Thank you for your great work and contributions to community.

Best regards,
Mario

Hi Luiz,

I'm using FB ver 3 Lib and Fbclient.

Thanks,
Mario

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On Friday, September 1, 2023 at 4:51:10 AM UTC+8, Mario H. Sabado wrote:

On Friday, September 1, 2023 at 12:25:32 AM UTC+8, Carlos Vargas wrote:

El jueves, 31 de agosto de 2023 a la(s) 01:31:02 UTC-6, Mario H. Sabado escribió:

Hi,

I have built latest xHarbour and SQLRDD using BCC73. Running the demo01.prg and selecting ODBC, I encountered the following error. I think this is related to conversion from DBF Logical Data Type to FB Boolean. Selecting "Firebird Native"

connection works without problem though.

*************************************************************** Connecting to dsn=FBODBC;
Connected to : FIREBIRD 06.03.2975 WI-V Firebird 4.0
RDD in use : SQLEX
Error SQLRDD/0 SQL execution error at dbGoTop, return code: -1, state: HY000, description: [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 10. Arguments: ( [ 1] = Type: C Val:
SELECT A.)

Error at ...: dbGoTop(2737) in Module: ..\source\sqlex1.c
Called from : MAIN(45) in Module: demo01.prg

C:\xharbour\xHarbourBuilder\xHarbour-SQLRDD\samples> **********************************************************************

Selecting ODBC using PostgresSQL 9.3 does not proceed and no error log was generated. Native PostgreSQL works fine though and have better performance than FirebirdSQL
*********************************************
Connecting to dsn=pgs9; Connected to : POSTGRESQL 9.3.25 RDD in use : SQLEX
*******************************************

Thank you for your great work and contributions to community.

Best regards,
Mario

me perece que hay dos versiones del cliente: firebird y firebird3 podrias probar con el firebird3?

Hola Carlos,

Yes, I'm using version of firebird lib and client.

Thanks,
Mario

Hi Luiz,

For the dbf2sql.prg, it encounters problem when there's Logical data type from the dbf file. If I remove the Logical data type field, it works fine. For the created column in Firebird, the data type is Boolean which is expected.

Thanks,
Mario


**********************************************************
Connecting to FIREBIRD=127.0.0.1:c:\firebird\firebird_4_0\data\TEST.FDB;uid=SYSDBA;pwd=masterkey;charset=ISO8859_1
RDD in use : SQLRDD
09/01/23 05:00:44.247
Uploading... stokmast (166976 records)
Error SQLRDD/1020 Data type error: data type origin: 128 - data type target 1024

Error at ...: __DBAPP(0) in Module: SQLRDD
Called from : UPLOAD(80) in Module: dbf2sql.prg
Called from : MAIN(56) in Module: dbf2sql.prg ***********************************************************

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On Friday, September 1, 2023 at 5:06:23 AM UTC+8, Mario H. Sabado wrote:

On Friday, September 1, 2023 at 4:51:10 AM UTC+8, Mario H. Sabado wrote:

On Friday, September 1, 2023 at 12:25:32 AM UTC+8, Carlos Vargas wrote:

El jueves, 31 de agosto de 2023 a la(s) 01:31:02 UTC-6, Mario H. Sabado escribió:

Hi,

I have built latest xHarbour and SQLRDD using BCC73. Running the demo01.prg and selecting ODBC, I encountered the following error. I think this is related to conversion from DBF Logical Data Type to FB Boolean. Selecting "Firebird Native"

connection works without problem though.

*************************************************************** Connecting to dsn=FBODBC;
Connected to : FIREBIRD 06.03.2975 WI-V Firebird 4.0
RDD in use : SQLEX
Error SQLRDD/0 SQL execution error at dbGoTop, return code: -1, state: HY000, description: [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 10. Arguments: ( [ 1] = Type: C Val:
SELECT A.)

Error at ...: dbGoTop(2737) in Module: ..\source\sqlex1.c
Called from : MAIN(45) in Module: demo01.prg

C:\xharbour\xHarbourBuilder\xHarbour-SQLRDD\samples> **********************************************************************

Selecting ODBC using PostgresSQL 9.3 does not proceed and no error log was generated. Native PostgreSQL works fine though and have better performance than FirebirdSQL
*********************************************
Connecting to dsn=pgs9; Connected to : POSTGRESQL 9.3.25 RDD in use : SQLEX
*******************************************

Thank you for your great work and contributions to community.

Best regards,
Mario

me perece que hay dos versiones del cliente: firebird y firebird3 podrias probar con el firebird3?

Hola Carlos,

Yes, I'm using version of firebird lib and client.

Thanks,
Mario

Hi Luiz,

For the dbf2sql.prg, it encounters problem when there's Logical data type from the dbf file. If I remove the Logical data type field, it works fine. For the created column in Firebird, the data type is Boolean which is expected.

Thanks,
Mario

**********************************************************
Connecting to FIREBIRD=127.0.0.1:c:\firebird\firebird_4_0\data\TEST.FDB;uid=SYSDBA;pwd=masterkey;charset=ISO8859_1
RDD in use : SQLRDD
09/01/23 05:00:44.247
Uploading... stokmast (166976 records)
Error SQLRDD/1020 Data type error: data type origin: 128 - data type target 1024

Error at ...: __DBAPP(0) in Module: SQLRDD
Called from : UPLOAD(80) in Module: dbf2sql.prg
Called from : MAIN(56) in Module: dbf2sql.prg ***********************************************************

Hi Luiz,

As additional info. If I run dbf2sql using Firebird ODBC and select SQLRDD (instead of SQLEX), it works fine. If I remove the Logical field in my testing and select SQLEX RDD, the performance is 3X faster.

Thanks,
Mario

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)