Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

6 May, 2024: The networking issue during the past two days has been identified and appears to be fixed. Will keep monitoring.

devel / comp.lang.xharbour / Error on ODBC insert

SubjectAuthor
* Error on ODBC insertMarco
`* Error on ODBC insertdlzc
 `* Error on ODBC insertMarco
  `* Error on ODBC insertdlzc
   `* Error on ODBC insertEnrico Maria Giordano
    `- Error on ODBC insertdlzc

1
Error on ODBC insert

<80a1bfca-e0b9-4187-8bfc-64e1dca21f07n@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:620a:2414:b0:6b6:1382:e7b7 with SMTP id d20-20020a05620a241400b006b61382e7b7mr12190819qkn.490.1658829252429;
Tue, 26 Jul 2022 02:54:12 -0700 (PDT)
X-Received: by 2002:a05:6902:706:b0:670:b750:2542 with SMTP id
k6-20020a056902070600b00670b7502542mr13728464ybt.73.1658829252234; Tue, 26
Jul 2022 02:54:12 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer03.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: Tue, 26 Jul 2022 02:54:11 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=92.223.202.50; posting-account=lAXggwoAAAA38TK43OjI5YNBHUtHVZ9n
NNTP-Posting-Host: 92.223.202.50
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <80a1bfca-e0b9-4187-8bfc-64e1dca21f07n@googlegroups.com>
Subject: Error on ODBC insert
From: marcopeg...@gmail.com (Marco)
Injection-Date: Tue, 26 Jul 2022 09:54:12 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1404
 by: Marco - Tue, 26 Jul 2022 09:54 UTC

Hi, I have a dbfcdx file indexed using xharbour DBFCDX RDD set using the RDDSetDefault("DBFCDX") function.

I can read and write to the file with a PHP\ODBC application using the Microsoft Visual FoxPro ODBC Driver version 6.01.8629.01 but when i try to do an insert on the database the ODBC driver return this error:

[Microsoft][ODBC Visual FoxPro Driver]Feature is not available

Does anyone know a solution?

thanks

Re: Error on ODBC insert

<89854601-822e-4e2c-9211-ae13d01d6ab2n@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:ac8:4e8d:0:b0:31f:403c:fd with SMTP id 13-20020ac84e8d000000b0031f403c00fdmr3548612qtp.337.1658851069063;
Tue, 26 Jul 2022 08:57:49 -0700 (PDT)
X-Received: by 2002:a0d:eacf:0:b0:31e:5d0c:f074 with SMTP id
t198-20020a0deacf000000b0031e5d0cf074mr15284844ywe.218.1658851068854; Tue, 26
Jul 2022 08:57:48 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.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: Tue, 26 Jul 2022 08:57:48 -0700 (PDT)
In-Reply-To: <80a1bfca-e0b9-4187-8bfc-64e1dca21f07n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=68.107.209.13; posting-account=7bF0GwoAAABMFHX6V4fON4-1F6LFJ834
NNTP-Posting-Host: 68.107.209.13
References: <80a1bfca-e0b9-4187-8bfc-64e1dca21f07n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <89854601-822e-4e2c-9211-ae13d01d6ab2n@googlegroups.com>
Subject: Re: Error on ODBC insert
From: dlz...@cox.net (dlzc)
Injection-Date: Tue, 26 Jul 2022 15:57:49 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1839
 by: dlzc - Tue, 26 Jul 2022 15:57 UTC

Dear Marco:

On Tuesday, July 26, 2022 at 2:54:13 AM UTC-7, Marco wrote:
> Hi, I have a dbfcdx file indexed using xharbour DBFCDX RDD set
> using the RDDSetDefault("DBFCDX") function.
>
> I can read and write to the file with a PHP\ODBC application
> using the Microsoft Visual FoxPro ODBC Driver version
> 6.01.8629.01 but when i try to do an insert on the database
> the ODBC driver return this error:
>
> [Microsoft][ODBC Visual FoxPro Driver]Feature is not available
>
> Does anyone know a solution?

"Insert" is not a method offered in DBFCDX, "append" is. See if that does not help.

https://hackfox.github.io/section4/s4g058.html
.... deprecated by anyone that has used it, I imagine.

David A. Smith

Re: Error on ODBC insert

<998d7649-6853-4a58-b3b1-45efbec19acan@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:6214:c8a:b0:473:26f:59e0 with SMTP id r10-20020a0562140c8a00b00473026f59e0mr15611744qvr.63.1658852809029;
Tue, 26 Jul 2022 09:26:49 -0700 (PDT)
X-Received: by 2002:a81:5211:0:b0:31e:5ada:9fc8 with SMTP id
g17-20020a815211000000b0031e5ada9fc8mr15323747ywb.473.1658852808723; Tue, 26
Jul 2022 09:26:48 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.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: Tue, 26 Jul 2022 09:26:48 -0700 (PDT)
In-Reply-To: <89854601-822e-4e2c-9211-ae13d01d6ab2n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=92.223.202.50; posting-account=lAXggwoAAAA38TK43OjI5YNBHUtHVZ9n
NNTP-Posting-Host: 92.223.202.50
References: <80a1bfca-e0b9-4187-8bfc-64e1dca21f07n@googlegroups.com> <89854601-822e-4e2c-9211-ae13d01d6ab2n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <998d7649-6853-4a58-b3b1-45efbec19acan@googlegroups.com>
Subject: Re: Error on ODBC insert
From: marcopeg...@gmail.com (Marco)
Injection-Date: Tue, 26 Jul 2022 16:26:49 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 2322
 by: Marco - Tue, 26 Jul 2022 16:26 UTC

Il giorno martedì 26 luglio 2022 alle 17:57:49 UTC+2 dlzc ha scritto:
> Dear Marco:
> On Tuesday, July 26, 2022 at 2:54:13 AM UTC-7, Marco wrote:
> > Hi, I have a dbfcdx file indexed using xharbour DBFCDX RDD set
> > using the RDDSetDefault("DBFCDX") function.
> >
> > I can read and write to the file with a PHP\ODBC application
> > using the Microsoft Visual FoxPro ODBC Driver version
> > 6.01.8629.01 but when i try to do an insert on the database
> > the ODBC driver return this error:
> >
> > [Microsoft][ODBC Visual FoxPro Driver]Feature is not available
> >
> > Does anyone know a solution?
> "Insert" is not a method offered in DBFCDX, "append" is. See if that does not help.
>
> https://hackfox.github.io/section4/s4g058.html
> ... deprecated by anyone that has used it, I imagine.
>
> David A. Smith

Hi, the insert is done with PHP\ODBC not from xharbour, but the table and the index is created by xharbour. Any idea to prevent the error? Other query under PHP\ODBC on the same table doesnt give the error.

Re: Error on ODBC insert

<7ef5c06c-df83-40c7-9b9e-398241e80c6cn@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:620a:319a:b0:6b5:eba5:a1c8 with SMTP id bi26-20020a05620a319a00b006b5eba5a1c8mr13910480qkb.292.1658864098294;
Tue, 26 Jul 2022 12:34:58 -0700 (PDT)
X-Received: by 2002:a81:1b97:0:b0:2db:640f:49d8 with SMTP id
b145-20020a811b97000000b002db640f49d8mr15849381ywb.326.1658864098151; Tue, 26
Jul 2022 12:34:58 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer03.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: Tue, 26 Jul 2022 12:34:57 -0700 (PDT)
In-Reply-To: <998d7649-6853-4a58-b3b1-45efbec19acan@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=68.107.209.13; posting-account=7bF0GwoAAABMFHX6V4fON4-1F6LFJ834
NNTP-Posting-Host: 68.107.209.13
References: <80a1bfca-e0b9-4187-8bfc-64e1dca21f07n@googlegroups.com>
<89854601-822e-4e2c-9211-ae13d01d6ab2n@googlegroups.com> <998d7649-6853-4a58-b3b1-45efbec19acan@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <7ef5c06c-df83-40c7-9b9e-398241e80c6cn@googlegroups.com>
Subject: Re: Error on ODBC insert
From: dlz...@cox.net (dlzc)
Injection-Date: Tue, 26 Jul 2022 19:34:58 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 2202
 by: dlzc - Tue, 26 Jul 2022 19:34 UTC

Dear Marco:

On Tuesday, July 26, 2022 at 9:26:49 AM UTC-7, Marco wrote:
....
> Hi, the insert is done with PHP\ODBC not from xharbour, but
> the table and the index is created by xharbour. Any idea to
> prevent the error? Other query under PHP\ODBC on the same
> table doesnt give the error.

Wrong newsgroup. You must use Foxpro resources, with Foxpro ODBC connection issues. When you do that, I think you will find out that the current ODBC code no longer supports what was a REALLY bad idea.

Since you appear to have missed my obvious advice: use APPEND [add to the end of the file], rather than INSERT [copy the existing file to a new file up to recno()-1, append this record, append the rest of the records from the original table, close the original table, delete the original table, reopen the indexes, reindex all the indexes, position the record pointer to recno()].

David A. Smith

Re: Error on ODBC insert

<tbpg6t$259ne$1@dont-email.me>

  copy mid

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

  copy link   Newsgroups: comp.lang.xharbour
Path: i2pn2.org!i2pn.org!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: e.m.gior...@emagsoftware.it (Enrico Maria Giordano)
Newsgroups: comp.lang.xharbour
Subject: Re: Error on ODBC insert
Date: Tue, 26 Jul 2022 21:44:30 +0200
Organization: A noiseless patient Spider
Lines: 14
Message-ID: <tbpg6t$259ne$1@dont-email.me>
References: <80a1bfca-e0b9-4187-8bfc-64e1dca21f07n@googlegroups.com>
<89854601-822e-4e2c-9211-ae13d01d6ab2n@googlegroups.com>
<998d7649-6853-4a58-b3b1-45efbec19acan@googlegroups.com>
<7ef5c06c-df83-40c7-9b9e-398241e80c6cn@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Tue, 26 Jul 2022 19:44:29 -0000 (UTC)
Injection-Info: reader01.eternal-september.org; posting-host="8d5248ed48b55375c54f5fc68a9b1533";
logging-data="2270958"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18hRdkF1jE/qLSRnUiUAcHe"
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
Thunderbird/102.0.3
Cancel-Lock: sha1:br6KnzX6ZECmvOiAYIWbgjshPiw=
In-Reply-To: <7ef5c06c-df83-40c7-9b9e-398241e80c6cn@googlegroups.com>
 by: Enrico Maria Giordan - Tue, 26 Jul 2022 19:44 UTC

Il 26/07/2022 21:34, dlzc ha scritto:

> Since you appear to have missed my obvious advice: use APPEND [add to the end of the file], rather than INSERT [copy the existing file to a new file up to recno()-1, append this record, append the rest of the records from the original table, close the original table, delete the original table, reopen the indexes, reindex all the indexes, position the record pointer to recno()].

INSERT is the SQL statement for APPEND, if I understood correctly what
Marco is asking for.

EMG

http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

Re: Error on ODBC insert

<e163052e-9d39-49b5-a793-27490bef044dn@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:620a:2889:b0:6b6:5410:b2c7 with SMTP id j9-20020a05620a288900b006b65410b2c7mr12681110qkp.697.1658936753904;
Wed, 27 Jul 2022 08:45:53 -0700 (PDT)
X-Received: by 2002:a05:6902:10c1:b0:66f:1f9f:9c00 with SMTP id
w1-20020a05690210c100b0066f1f9f9c00mr17211213ybu.583.1658936753750; Wed, 27
Jul 2022 08:45:53 -0700 (PDT)
Path: i2pn2.org!i2pn.org!aioe.org!pasdenom.info!usenet-fr.net!fdn.fr!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: Wed, 27 Jul 2022 08:45:53 -0700 (PDT)
In-Reply-To: <tbpg6t$259ne$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=68.107.209.13; posting-account=7bF0GwoAAABMFHX6V4fON4-1F6LFJ834
NNTP-Posting-Host: 68.107.209.13
References: <80a1bfca-e0b9-4187-8bfc-64e1dca21f07n@googlegroups.com>
<89854601-822e-4e2c-9211-ae13d01d6ab2n@googlegroups.com> <998d7649-6853-4a58-b3b1-45efbec19acan@googlegroups.com>
<7ef5c06c-df83-40c7-9b9e-398241e80c6cn@googlegroups.com> <tbpg6t$259ne$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <e163052e-9d39-49b5-a793-27490bef044dn@googlegroups.com>
Subject: Re: Error on ODBC insert
From: dlz...@cox.net (dlzc)
Injection-Date: Wed, 27 Jul 2022 15:45:53 +0000
Content-Type: text/plain; charset="UTF-8"
 by: dlzc - Wed, 27 Jul 2022 15:45 UTC

Dear Enrico:

On Tuesday, July 26, 2022 at 12:44:32 PM UTC-7, Enrico Maria Giordano wrote:
....
> INSERT is the SQL statement for APPEND, if I understood correctly what
> Marco is asking for.

INSERT has a different meaning in FoxPro, than does APPEND. He is using that driver as he stated. Maybe that is what he meant to do, but... He also stated he was using DBFCDX, not SQLRDD.

We'll see what he says.

David A. Smith

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor