Skip to Content
author's profile photo Former Member
Former Member

problem with a SQL query since the Advantage OLE DB Provider connector since Windev 23

Hello,

I would like to contact you to submit a problem with a SQL query since the Advantage OLE DB Provider connector since Windev 23.

The problem occurs in the following context:

- Advantage OLE DB Provider v.11.10 connector (version 11.10.0024)

- Advantage Database Server Release 11.1 for Windows x86 64-bit (version 11.10.0024)

We have the following alert message:

Window Title : Advantage Client Engine

Message : Exception code C0000005 was generating when calling the user-supplied callbackfunction. It is being disabled.

Button : OK

This message only occurs with a SQL call with WinDev 23 in 64 bits.

Indeed, for the same project, either if WinDev 21 (in 32 or 64 bits) without modification of the code or WinDev 23 (in 32 bits only), the problem does not occur!

If that does not prevent us from recovering the result of the SQL query, it is necessary to click on the "OK" button so that the SQL query runs, which is extremely blocking.

Concerning the setting up of the Advantage Database Server "Suppress Message Boxes" does not change anything (restart of the ADS service performed) and was not activated for testing on other versions of WinDev!

We have also submitted this issue in parallel with PC SOFT, in order to obtain possible solutions to this problem.

However, would you have a clear explanation for this error message and a way to resolve this problem?

I thank you for your response and remain at your disposal if needed.

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Posted on Apr 11, 2018 at 01:27 PM

    All I can tell you is that exception code C0000005 means "access denied". Without knowing what the software is doing in the background, I can't say what is causing this condition. Ideally, if PC Soft does not find a problem in their own code, they should open a support incident with SAP so that we can work through it together.

    Regards,

    Mike Loop
    Senior Product Support Engineer
    SAP Product Support

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 12, 2018 at 11:19 AM

    I've seen this error code in conjunction with mismatched or missing DLLs.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 27, 2018 at 10:11 AM

    Hi,

    According to Windev engineers who examinate the dump file (linked below), this error is caused by adsoledb64.dll.

    They tolds us that's maybe a cast problem which lost the 32bits of pointer most significant byte in adsoledb64.

    Here the pastebin link of the crash dump information.

    Additional information: This error is launched only on a Windows 10 x64 platform, the applications works well on a Windows 7 x64 platform.

    Best Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 27, 2018 at 12:49 PM

    Please open a support incident to pursue dump analysis and reproduction of the problem.

    Mike Loop
    Senior Product Support Engineer
    SAP Product Support

    Add a comment
    10|10000 characters needed characters exceeded

    • If you are able to log onto the SAP Market Place but do not have super-admin privileges, you would need to locate your company's super-admin. When you log in, you can click on "Contact Us" and choose one of the channels for Non-Technical help. They should be able to identify your super-admins.

      It should really be PC Soft that opens an incident on your behalf. It seems pretty far-fetched to suggest that we are improperly casting data, but only when version 23 of WinDev is being used on Windows 10.

      It might help if you can post the ads_err.* files from the server. Note, however, that some details may be included that could be considered sensitive, such as server names and user logins (without passwords).

      Regards,

      Mike Loop - SAP Product Support

  • author's profile photo Former Member
    Former Member
    Posted on May 14, 2018 at 08:03 AM

    I don't have a S-USER account so I can't access to the technical support.

    I'm stuck, so if you can't analyze the dump file, do you have an idea of this error?

    Add a comment
    10|10000 characters needed characters exceeded

    • PC Soft presumably has a a contractual relationship with SAP, so they should be opening a support incident with us. This would allow them to fix the problem for all users.The error indicates that the problem occurs during the execution of a user-defined callback function. Without access to that function, I have no way to analyze the error.

      Mike Loop - SAP Product Support

  • Posted on Aug 03, 2020 at 10:45 AM

    Hi Mike,
    since win10 and Excel 64bit with die 64bit OLEDB Driver we have the same

    error.

    The both following SQL commands demonstrate the Problem. They looks very identical but when we change the tables we get an error:

    Select top 1 qs_base.relakey from qs_base inner join qs_op on h_lei_rel = qs_op.relakey order by qs_op.op_datum -> Error

    Select top 1 qs_base.relakey from qs_op inner join qs_base on h_lei_rel = qs_op.relakey order by qs_op.op_datum -> no Error

    Do you have any idea

    Regards

    Michael Frie

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 06, 2020 at 06:05 PM

    Since the syntax of your two statements is identical, the problem is obviously with the underlying tables.

    If you have a support contract, please open an incident. Otherwise, please provide a SQL script that will generate the minimum tables needed to reproduce the error. Also let us know if you are using a data dictionary or free tables, and local or remote server.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.