🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #4571

Re: Problem with Informix serial column in ADO

#4571
From: Alexei Karas
Date: Mon, 03 Dec 2001 08:39
38 lines
2209 bytes
Hi,

generally speaking I didn't try to use Informix's OLEDB provider with BCB,
but I tried it with VB. OLEDB providers from Informix are pretty unstable I
should say...:( You may try to use OLEDB provider for ODBC (this should not
require any changes in your code, just adjusting of the connection string)
and if it will work OK, then you must use OLEDB over ODBC and wait for
another version of Informix OLEDB provider.

HTH,
    Alex

"MaweRick" <theMawe@Mail.Ru> wrote in message news:3c031f37_1@dnews...
> Hi
>
> I have problem, when using ADO connection && ADO Query with Informix OLE
DB
> provider
>
> The Problem are:
> Let SQL text in ADO Query be as follows: Select * from SomeTable
> this select works fine but, if SomeTable consist field someID of Informix
> type SERIAL (counter in Informix term),
> then in result set there is no column someID as if SomeTable not consist
> them.
>
> If we change SQL text to: Select SomeID from SomeTable then program or Cpp
> Builder will hang.
>
> Hawe ANYONE any idea of what to do?
>
> P.S. I've apply AdoUpdate1.
> P.P.S Sory for BAAAD english, i'm russian englishman :)
>
> See YOU later
> MaweRick
>
>
Technical Details
Message-ID: <3c0b39d9_2@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!194.25.134.62!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews
References: <3c031f37_1@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,52e4bfe746b11ea4
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-12-03 00:38:51 PST
From: "Alexei Karas" <nospam_AlexKaras_thatsextraaswell@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3c031f37_1@dnews>
Subject: Re: Problem with Informix serial column in ADO
Date: Mon, 3 Dec 2001 10:39:43 +0200
Lines: 39
MIME-Version: 1.0
Content-Type: text/plain;
 charset="windows-1251"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 212.109.63.210
Message-ID: <3c0b39d9_2@dnews>
X-Trace: dnews 1007368665 212.109.63.210 (3 Dec 2001 00:37:45 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!194.25.134.62!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews