Error -2147217887 from VB to BO
Hi,
I'm trying to send a SELECT query to a BO DB, using a VB app. The query runs fine directly on BO, but through the app, I get a -2147217887 error. The message is "Les proprits requises ne peuvent tre prises en charge", which translates as "the required properties cannot be dealt with" but does not mean much.
I cannot send a example of the code because the app is a query writer and I don't have access to the source.
Thank you for any suggestion.
bja
[502 byte] By [
bja3406] at [2007-11-11 10:05:31]
# 2 Re: Error -2147217887 from VB to BO
BO DB is a Business Objects DataBase(sorry).
As I mentionned, I do not have access to the VB code but here is the SQL query (generated by Business Objects and copied into the query writer :
SELECT
CK_T_TBK01.CKTBK01_NUCTSC,
CK_T_TBK01.CKTBK01_NUCACS
FROM
CK_T_TBK01
WHERE
(
(CK_T_TBK01.CKTBK01_IDNDCD = '050'
OR CK_T_TBK01.CKTBK01_IDNDCD = '055'
OR CK_T_TBK01.CKTBK01_IDNDCD = '060')
AND CK_T_TBK01.CKTBK01_IDCDP8 != '08100'
AND CK_T_TBK01.CKTBK01_IDCDP8 != '50100'
AND CK_T_TBK01.CKTBK01_DFNDC9 != '12/31/2044 00:0:0'
AND CK_T_TBK01.CKTBK01_DENDC9 > '11/11/2006 00:0:0'
AND CK_T_TBK01.CKTBK01_DENDC9 >= @variable('cDateDebut')
)
ORDER BY
1
Bja
