Hi, all.
I'm a delphi developer who is working on a very old delphi application
that uses db2v7 via ADO (Mdac).
I know that v7 is very, very old, but at this moment, we cant' upgrade
to a different version... :-((
(I've seen db2 v9.. it's cool, IF WORKS FINE....).
Now, I need to add a table that uses (b)lob fields.
I've create a small table to do some test, but I've errors getting or
setting blob field value from delphi application:
[ibm][cli driver] CLI0102E Invalid conversion. SQLSTATE=07006.
In ibm site, it's very hard to get information about our current db2
version...
Now, I don't understand what is wrong in my source code, beacuse I've
used delphi code that works fine with other databases like Sybase.
My questions:
1) someone has informations about bugs in db2v7 related with (b)lob
management?
2) In our database we have 1 tablespace.
I MUST create a specific tablespace for blob data? Or, I CAN do it, to
improve performances?
3) I'm working via oledbprovider.
Now I can't test this situation using ODBC, but, if necessary, I can
use an other database connection to manage table with blob data.
Obviusly, only id someone know if using odbc I haven't this error.
4) someone knows some direct links to db2 v7 documentation?
ibm site is a maze....
delphi version is 7.
db2 server is running on win2003.
my pc has xp sp2.
TIA.
Alberto Salvati