DBX4 & Delphi2007 TDBXError 'Incorrect values within SQLDA structure'

[lowmax]

Hi,

when I try to insert a blob(text) into a table using DBX4 I get the
following error mesage:
Exception .. TDBXError 'Incorrect values within SQLDA structure'
With DBX&D2005 everything works fine.
What's going wrong?

Thanks for help!

lowmax

[Cesar Romero]

Post by lowmax
when I try to insert a blob(text) into a table using DBX4 I get the
following error mesage: Exception .. TDBXError 'Incorrect values
within SQLDA structure' With DBX&D2005 everything works fine.
What's going wrong?

_________________________________________

lowmax,

Did you install all updates? It was a but in midas.dll from RTM and I
guess still in Update 1 version.
Just make sure you have all updates installed.

[lowmax]

Post by Cesar Romero

Post by lowmax
when I try to insert a blob(text) into a table using DBX4 I get the
following error mesage: Exception .. TDBXError 'Incorrect values
within SQLDA structure' With DBX&D2005 everything works fine.
What's going wrong?

_________________________________________
lowmax,
Did you install all updates? It was a but in midas.dll from RTM and I
guess still in Update 1 version.
Just make sure you have all updates installed.

Hi Cesar,

thanks for your fast answer. I use the Rad Studio 2007,
so the Updates 1-3 should already included.

lowmax

[Cesar Romero]

Post by lowmax

Post by Cesar Romero

Post by lowmax
when I try to insert a blob(text) into a table using DBX4 I get
the following error mesage: Exception .. TDBXError 'Incorrect
values within SQLDA structure' With DBX&D2005 everything works
fine. What's going wrong?

_________________________________________
lowmax, Did you install all updates? It was a but in midas.dll
from RTM and I guess still in Update 1 version.
Just make sure you have all updates installed.

Hi Cesar,
thanks for your fast answer. I use the Rad Studio 2007,
so the Updates 1-3 should already included.
lowmax

_________________________________________

lowmax,

Do you have December update?
Check you midas.dll version, maybe you have a old version, also, try
use midaslib.dcu in you project to avoid midas.dll as a test.

My Midas.dll is 11.0.9202.10471
if you have this file in system32, try register with regsvr32

[Bill Todd [TeamB]]

I am not having any errors working with blob fields in InterBase using
RAD Studio 2007 with all updates. I suggest you download and install
all updates from the registered users page to make sure you have them
all installed. Also make sure you have one and only one midas.dll on
your system.

[lowmax]

Sorry, I have forgot to say that I use Firebird 1.5.4.4910 instead
Interbase. I've checked also the midas.dll and it has the Version
11.0.2902.10471. I#Ve also installed the Dec2007 update for the Rad
Studio2007E.

lowmax

Post by lowmax

Post by Cesar Romero

Post by lowmax
when I try to insert a blob(text) into a table using DBX4 I get the
following error mesage: Exception .. TDBXError 'Incorrect values
within SQLDA structure' With DBX&D2005 everything works fine.
What's going wrong?

_________________________________________
lowmax,
Did you install all updates? It was a but in midas.dll from RTM and I
guess still in Update 1 version.
Just make sure you have all updates installed.

Hi Cesar,
thanks for your fast answer. I use the Rad Studio 2007,
so the Updates 1-3 should already included.
lowmax

[lowmax]

Post by lowmax
Sorry, I have forgot to say that I use Firebird 1.5.4.4910 instead
Interbase. I've checked also the midas.dll and it has the Version
11.0.2902.10471. I#Ve also installed the Dec2007 update for the Rad
Studio2007E.

Whose Firebird dbExpress drive are you using?

I'm using the Interbase-Driver (dbxint30.dll) from D2007.
In older Delphi Versions the IB-Driver works fine.

lowmax

[Bill Todd [TeamB]]

Post by lowmax
I'm using the Interbase-Driver (dbxint30.dll) from D2007.
In older Delphi Versions the IB-Driver works fine.

The InterBase dbX driver has never been tested against and has never
officially supported Firebird. There have been other reports of
problems with the new dbX 4 InterBase driver when used with Firebird.

Please vote for QC 41034 which requests that CodeGear provide a dbX
driver for Firebird. It alread has 798 votes (which I think is a record
for any QC request) and the more votes it gets the more likely it is
that CodeGear will provide the driver.

In the meantime you might want to look at one of the commercial dbX
drivers for FB such as the one from Upscene Productions at
www.upscene.com.

[Markus.Humm]

[snip]

Post by Bill Todd [TeamB]
Please vote for QC 41034 which requests that CodeGear provide a dbX
driver for Firebird. It alread has 798 votes (which I think is a record
for any QC request) and the more votes it gets the more likely it is
that CodeGear will provide the driver.

Yes please do this!

Post by Bill Todd [TeamB]
In the meantime you might want to look at one of the commercial dbX
drivers for FB such as the one from Upscene Productions at
www.upscene.com.

Althoug it is only a dbx3 driver so it has to use the dbx3 bridge I use
this driver without problems, but to be fair: also without blobs... ;-)

Greetings

Markus

[lowmax]

Post by Markus.Humm
[snip]

Post by Bill Todd [TeamB]
Please vote for QC 41034 which requests that CodeGear provide a dbX
driver for Firebird. It alread has 798 votes (which I think is a record
for any QC request) and the more votes it gets the more likely it is
that CodeGear will provide the driver.

Yes please do this!

Post by Bill Todd [TeamB]
In the meantime you might want to look at one of the commercial dbX
drivers for FB such as the one from Upscene Productions at
www.upscene.com.

Althoug it is only a dbx3 driver so it has to use the dbx3 bridge I use
this driver without problems, but to be fair: also without blobs... ;-)
Greetings
Markus

I've now voted for QC41034, too! I hope CG will done it quickly in the
next update, because I think a lot of projects will based on firebird.
(Current votes 803)

lowmax

[Bill Todd [TeamB]]

Post by lowmax
I've now voted for QC41034, too! I hope CG will done it quickly in
the next update, because I think a lot of projects will based on
firebird. (Current votes 803)

Remember that you can distribute your five QC votes across any number
of QC entries including applying all five to one QC entry. As we used
to say in Chicago, vote early, vote often.<g>

[Markus.Humm]

Post by Bill Todd [TeamB]

Post by lowmax
I've now voted for QC41034, too! I hope CG will done it quickly in
the next update, because I think a lot of projects will based on
firebird. (Current votes 803)

Remember that you can distribute your five QC votes across any number
of QC entries including applying all five to one QC entry. As we used
to say in Chicago, vote early, vote often.<g>

Hello,

sorry but your voting info is wrong or at least outdated:

everybody now has a unlimited number of votes but can only give 10 votes
to any individual report. This won't yet work with the web client and
for the standard Windows client installed together with the Delphi IDE
some update is necessary. This update is somewhere in Code Central...

Greetings

Markus

[Tomohiro Takahashi]

Hi,

Have you tried DBXOODBC with Firebird's ODBC Driver?
[Open source dbExpress drivers]
https://sourceforge.net/project/showfiles.php?group_id=38250
[Version 3.100, 2008-03-24: Beta [dbx3]]
http://sourceforge.net/project/shownotes.php?release_id=576691&group_id=38250

Regards,
KEN <TAKAHASHI, Tomohiro>

Post by lowmax

Post by Markus.Humm
[snip]

Post by Bill Todd [TeamB]
Please vote for QC 41034 which requests that CodeGear provide a dbX
driver for Firebird. It alread has 798 votes (which I think is a record
for any QC request) and the more votes it gets the more likely it is
that CodeGear will provide the driver.

Yes please do this!

Post by Bill Todd [TeamB]
In the meantime you might want to look at one of the commercial dbX
drivers for FB such as the one from Upscene Productions at
www.upscene.com.

Althoug it is only a dbx3 driver so it has to use the dbx3 bridge I use
this driver without problems, but to be fair: also without blobs... ;-)
Greetings
Markus

I've now voted for QC41034, too! I hope CG will done it quickly in the
next update, because I think a lot of projects will based on firebird.
(Current votes 803)
lowmax

[Bill Todd [TeamB]]

Post by lowmax
Sorry, I have forgot to say that I use Firebird 1.5.4.4910 instead
Interbase. I've checked also the midas.dll and it has the Version
11.0.2902.10471. I#Ve also installed the Dec2007 update for the Rad
Studio2007E.

Whose Firebird dbExpress drive are you using?

[Cesar Romero]

Post by lowmax
Sorry, I have forgot to say that I use Firebird 1.5.4.4910 instead
Interbase. I've checked also the midas.dll and it has the Version
11.0.2902.10471. I#Ve also installed the Dec2007 update for the Rad
Studio2007E.

_________________________________________

lowmax,

I had testes with Firebird 1.5.4, 2.0.3 and 2.1b and works fine with
all 3 here.

If you are having the problem that I had, it has nothing to do with
firebird, is midas.dll, load a biolife.cds will raise the same error.

Did you tried register midas.dll??
Did you tried with midaslib.dcu???

[Paul Hughes]

Post by lowmax
Sorry, I have forgot to say that I use Firebird 1.5.4.4910 instead
Interbase. I've checked also the midas.dll and it has the Version
11.0.2902.10471. I#Ve also installed the Dec2007 update for the Rad
Studio2007E.

I would also check which version of GDS32.DLL you are using. Is it the
Firebird fbclient (generated as GDS32 during your Firebird install) or is it
the original Interbase GDS32. I have seen the error you mentioned which I
think occurred when inadvertently accessing a Firebird 2 DB using the
genuine Interbase file instead of the Firebird version.

Regards, Paul.

[lowmax]

Post by Paul Hughes

Post by lowmax
Sorry, I have forgot to say that I use Firebird 1.5.4.4910 instead
Interbase. I've checked also the midas.dll and it has the Version
11.0.2902.10471. I#Ve also installed the Dec2007 update for the Rad
Studio2007E.

I would also check which version of GDS32.DLL you are using. Is it the
Firebird fbclient (generated as GDS32 during your Firebird install) or is it
the original Interbase GDS32. I have seen the error you mentioned which I
think occurred when inadvertently accessing a Firebird 2 DB using the
genuine Interbase file instead of the Firebird version.
Regards, Paul.

I've already checked midas.dll and gds32.dll again, but it o.k.

Then I have done the same project (Only modifications in the transaction
syntax) in D2005E and it works without any problems on the same machine
with the same alias. (dbx uses dbexpint.dll instead of dbxint30.dll)

lowmax