Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

Unix is a Registered Bell of AT&T Trademark Laboratories. -- Donn Seeley

devel / comp.lang.xharbour / Re: SQLRDD ODBC Error using FirebirdSQL

SubjectAuthor
* SQLRDD ODBC Error using FirebirdSQLMario H. Sabado
+* Re: SQLRDD ODBC Error using FirebirdSQLCarlos Vargas
|`* Re: SQLRDD ODBC Error using FirebirdSQLMario H. Sabado
| `* Re: SQLRDD ODBC Error using FirebirdSQLMario H. Sabado
|  `- Re: SQLRDD ODBC Error using FirebirdSQLMario H. Sabado
`* Re: SQLRDD ODBC Error using FirebirdSQLculikr@gmail.com
 `- Re: SQLRDD ODBC Error using FirebirdSQLMario H. Sabado

1
SQLRDD ODBC Error using FirebirdSQL

<0eed95d0-74d3-492e-81da-8a2b23e79c68n@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17677&group=comp.lang.xharbour#17677

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:620a:31a2:b0:76d:8856:b878 with SMTP id bi34-20020a05620a31a200b0076d8856b878mr62909qkb.5.1693467061948;
Thu, 31 Aug 2023 00:31:01 -0700 (PDT)
X-Received: by 2002:a17:902:f68f:b0:1b8:a8f5:a97b with SMTP id
l15-20020a170902f68f00b001b8a8f5a97bmr863280plg.7.1693467061410; Thu, 31 Aug
2023 00:31:01 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!1.us.feeder.erje.net!feeder.erje.net!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Thu, 31 Aug 2023 00:31:00 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=136.158.35.77; posting-account=sLlfXgoAAAB-ViheA31lhrDJmVKQuQpT
NNTP-Posting-Host: 136.158.35.77
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <0eed95d0-74d3-492e-81da-8a2b23e79c68n@googlegroups.com>
Subject: SQLRDD ODBC Error using FirebirdSQL
From: mhsabado@gmail.com (Mario H. Sabado)
Injection-Date: Thu, 31 Aug 2023 07:31:01 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 2583
 by: Mario H. Sabado - Thu, 31 Aug 2023 07:31 UTC

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

Re: SQLRDD ODBC Error using FirebirdSQL

<5f2fe3a5-dc21-4174-9168-09672fbe409an@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17684&group=comp.lang.xharbour#17684

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:622a:1805:b0:40f:e2a5:3100 with SMTP id t5-20020a05622a180500b0040fe2a53100mr5727qtc.6.1693499131229;
Thu, 31 Aug 2023 09:25:31 -0700 (PDT)
X-Received: by 2002:a17:90a:f40b:b0:26d:68ca:439f with SMTP id
ch11-20020a17090af40b00b0026d68ca439fmr1005174pjb.7.1693499130772; Thu, 31
Aug 2023 09:25:30 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Thu, 31 Aug 2023 09:25:30 -0700 (PDT)
In-Reply-To: <0eed95d0-74d3-492e-81da-8a2b23e79c68n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=190.143.247.89; posting-account=VNWrSAoAAAAzTQ9dAKd6iPU3ea2LLmkd
NNTP-Posting-Host: 190.143.247.89
References: <0eed95d0-74d3-492e-81da-8a2b23e79c68n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <5f2fe3a5-dc21-4174-9168-09672fbe409an@googlegroups.com>
Subject: Re: SQLRDD ODBC Error using FirebirdSQL
From: karlos.vargas@gmail.com (Carlos Vargas)
Injection-Date: Thu, 31 Aug 2023 16:25:31 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
 by: Carlos Vargas - Thu, 31 Aug 2023 16:25 UTC

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?

Re: SQLRDD ODBC Error using FirebirdSQL

<ee6ad569-faba-47a8-905d-1a35631cfc4dn@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17686&group=comp.lang.xharbour#17686

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:620a:46aa:b0:76f:745:f56e with SMTP id bq42-20020a05620a46aa00b0076f0745f56emr2346qkb.0.1693503362704;
Thu, 31 Aug 2023 10:36:02 -0700 (PDT)
X-Received: by 2002:a63:6d42:0:b0:56a:750e:d79d with SMTP id
i63-20020a636d42000000b0056a750ed79dmr65958pgc.10.1693503362309; Thu, 31 Aug
2023 10:36:02 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Thu, 31 Aug 2023 10:36:01 -0700 (PDT)
In-Reply-To: <0eed95d0-74d3-492e-81da-8a2b23e79c68n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=2804:2a4c:1082:cd45:39e7:6453:996d:1228;
posting-account=PyPxfAoAAADNUfqQVzj3zqwX61JSXPu4
NNTP-Posting-Host: 2804:2a4c:1082:cd45:39e7:6453:996d:1228
References: <0eed95d0-74d3-492e-81da-8a2b23e79c68n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <ee6ad569-faba-47a8-905d-1a35631cfc4dn@googlegroups.com>
Subject: Re: SQLRDD ODBC Error using FirebirdSQL
From: culikr@gmail.com (culikr@gmail.com)
Injection-Date: Thu, 31 Aug 2023 17:36:02 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 2918
 by: culikr@gmail.com - Thu, 31 Aug 2023 17:36 UTC

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

Re: SQLRDD ODBC Error using FirebirdSQL

<d4063c4f-7870-4ad6-9d2f-9fb92caad86en@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17687&group=comp.lang.xharbour#17687

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:620a:145:b0:76e:e858:3511 with SMTP id e5-20020a05620a014500b0076ee8583511mr10888qkn.6.1693514863644;
Thu, 31 Aug 2023 13:47:43 -0700 (PDT)
X-Received: by 2002:a17:902:d48c:b0:1b7:d4d2:c385 with SMTP id
c12-20020a170902d48c00b001b7d4d2c385mr265394plg.1.1693514863362; Thu, 31 Aug
2023 13:47:43 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Thu, 31 Aug 2023 13:47:42 -0700 (PDT)
In-Reply-To: <ee6ad569-faba-47a8-905d-1a35631cfc4dn@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=136.158.35.77; posting-account=sLlfXgoAAAB-ViheA31lhrDJmVKQuQpT
NNTP-Posting-Host: 136.158.35.77
References: <0eed95d0-74d3-492e-81da-8a2b23e79c68n@googlegroups.com> <ee6ad569-faba-47a8-905d-1a35631cfc4dn@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <d4063c4f-7870-4ad6-9d2f-9fb92caad86en@googlegroups.com>
Subject: Re: SQLRDD ODBC Error using FirebirdSQL
From: mhsabado@gmail.com (Mario H. Sabado)
Injection-Date: Thu, 31 Aug 2023 20:47:43 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 3163
 by: Mario H. Sabado - Thu, 31 Aug 2023 20:47 UTC

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

Re: SQLRDD ODBC Error using FirebirdSQL

<24f1f9d3-9c1d-4092-8e68-9ba4a4fbb2e1n@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17688&group=comp.lang.xharbour#17688

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:ad4:57c4:0:b0:63d:33d1:1db2 with SMTP id y4-20020ad457c4000000b0063d33d11db2mr7625qvx.0.1693515069582;
Thu, 31 Aug 2023 13:51:09 -0700 (PDT)
X-Received: by 2002:a63:7b4d:0:b0:564:8375:d240 with SMTP id
k13-20020a637b4d000000b005648375d240mr155008pgn.12.1693515069071; Thu, 31 Aug
2023 13:51:09 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Thu, 31 Aug 2023 13:51:08 -0700 (PDT)
In-Reply-To: <5f2fe3a5-dc21-4174-9168-09672fbe409an@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=136.158.35.77; posting-account=sLlfXgoAAAB-ViheA31lhrDJmVKQuQpT
NNTP-Posting-Host: 136.158.35.77
References: <0eed95d0-74d3-492e-81da-8a2b23e79c68n@googlegroups.com> <5f2fe3a5-dc21-4174-9168-09672fbe409an@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <24f1f9d3-9c1d-4092-8e68-9ba4a4fbb2e1n@googlegroups.com>
Subject: Re: SQLRDD ODBC Error using FirebirdSQL
From: mhsabado@gmail.com (Mario H. Sabado)
Injection-Date: Thu, 31 Aug 2023 20:51:09 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 3202
 by: Mario H. Sabado - Thu, 31 Aug 2023 20:51 UTC

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

Re: SQLRDD ODBC Error using FirebirdSQL

<8e823fd8-722f-4ad7-9e38-3dbcf45ed221n@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17690&group=comp.lang.xharbour#17690

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:ad4:48c2:0:b0:64a:2de0:786d with SMTP id v2-20020ad448c2000000b0064a2de0786dmr7577qvx.7.1693515981937;
Thu, 31 Aug 2023 14:06:21 -0700 (PDT)
X-Received: by 2002:a05:6870:c794:b0:1bf:817a:633d with SMTP id
dy20-20020a056870c79400b001bf817a633dmr16032oab.0.1693515980616; Thu, 31 Aug
2023 14:06:20 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Thu, 31 Aug 2023 14:06:20 -0700 (PDT)
In-Reply-To: <24f1f9d3-9c1d-4092-8e68-9ba4a4fbb2e1n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=136.158.35.77; posting-account=sLlfXgoAAAB-ViheA31lhrDJmVKQuQpT
NNTP-Posting-Host: 136.158.35.77
References: <0eed95d0-74d3-492e-81da-8a2b23e79c68n@googlegroups.com>
<5f2fe3a5-dc21-4174-9168-09672fbe409an@googlegroups.com> <24f1f9d3-9c1d-4092-8e68-9ba4a4fbb2e1n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <8e823fd8-722f-4ad7-9e38-3dbcf45ed221n@googlegroups.com>
Subject: Re: SQLRDD ODBC Error using FirebirdSQL
From: mhsabado@gmail.com (Mario H. Sabado)
Injection-Date: Thu, 31 Aug 2023 21:06:21 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 4287
 by: Mario H. Sabado - Thu, 31 Aug 2023 21:06 UTC

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
***********************************************************

Re: SQLRDD ODBC Error using FirebirdSQL

<87621c81-7c9e-4aec-bb58-7fff75a2cfefn@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17699&group=comp.lang.xharbour#17699

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:ad4:58b2:0:b0:652:dc2e:6243 with SMTP id ea18-20020ad458b2000000b00652dc2e6243mr97286qvb.10.1693627901733;
Fri, 01 Sep 2023 21:11:41 -0700 (PDT)
X-Received: by 2002:a17:90a:fc97:b0:26d:12ec:ec8f with SMTP id
ci23-20020a17090afc9700b0026d12ecec8fmr1051426pjb.8.1693627901177; Fri, 01
Sep 2023 21:11:41 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Fri, 1 Sep 2023 21:11:40 -0700 (PDT)
In-Reply-To: <8e823fd8-722f-4ad7-9e38-3dbcf45ed221n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=136.158.35.77; posting-account=sLlfXgoAAAB-ViheA31lhrDJmVKQuQpT
NNTP-Posting-Host: 136.158.35.77
References: <0eed95d0-74d3-492e-81da-8a2b23e79c68n@googlegroups.com>
<5f2fe3a5-dc21-4174-9168-09672fbe409an@googlegroups.com> <24f1f9d3-9c1d-4092-8e68-9ba4a4fbb2e1n@googlegroups.com>
<8e823fd8-722f-4ad7-9e38-3dbcf45ed221n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <87621c81-7c9e-4aec-bb58-7fff75a2cfefn@googlegroups.com>
Subject: Re: SQLRDD ODBC Error using FirebirdSQL
From: mhsabado@gmail.com (Mario H. Sabado)
Injection-Date: Sat, 02 Sep 2023 04:11:41 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 4835
 by: Mario H. Sabado - Sat, 2 Sep 2023 04:11 UTC

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

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor