Oracle 10 'cannot store a template'

rbuser

I just upgraded from Delphi 5, Reportbuilder 7 Ent, Oracle 9 to Delphi
2007, Reportbuilder 10.06 Ent., Oracle 10g Now I get 'Cannot store a
template to a field of this type' when running my app with templates
stored as text in a LONG. Tried using a BLOB field and binary storage,
same result. What's up with this? Please help...



--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Tom,

Which connectivity are you using with Oracle? The template field of the
rb_Item table should be a BLOB type. Be sure you are creating your table
exactly the way they are created in the CreateEndUserTables.sql file given
in the \RBuilder\Demos\4. EndUser Databases\Oracle\... directory. In my
testing with RB 10.06 and Oracle 10, I am able to get the end-user example
working correctly.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Has anyone stored Reportbuilder 10 reports in either a BLOB or Long field
in Oracle?




--- posted by geoForum on http://delphi.newswhat.com

rbuser

I'll look at the example. I am connecting via a TADOConnection. My
connection string is

Provider=MSDAORA.1;User ID=IUSER_WEBSERVER;Data Source=XE;Persist Security
Info=True

I have also tried a different provider:

Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User
ID=iuser_webserver;password=waterfowl;Data Source=XE

Note that this application works with old the Delphi and Reportbuilder
when connected to either Oracle 9 or 10. A recompile with no changes in
Delphi 2007/Reportbuilder 10.06 causes this error.

Thank You,

Tom




--- posted by geoForum on http://delphi.newswhat.com

rbuser

I just tried the Oracle end user example and it isn't working, either. It
errors out trying to open the qryItem query. When I set qryItem.active to
True in codeview I get the error message 'Invalid field type'. The SQL
from the query runs with no problem directly in Oracle and in PL/SQL.

Any ideas about what's happening?




--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Tom,

You might consider using Direct Oracle Access (DOA) when connecting to an
Oracle DB. This has been tested to function correctly with all versions of
Delphi and ReportBuilder. See the demo in the \RBuilder\Demos\4. EndUser
Databases\Oracle... directory.

http://www.allroundautomations.nl/doa.html

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

O.K. Turns out this isn't a Reportbuilder problem. I cant get 2007 to
recognise BLOBs or LONGs through my ADO connections. The same code works
fine when compiled with D5 or D6.




--- posted by geoForum on http://delphi.newswhat.com