View original (French)

OLE DB Access Error

edmichs -  
Hello,

hi!
<<Error accessing oledb
error number = 2032>> I established a connection to an Oracle database and everything works, but when I try a query to query my Oracle database, I get this error message:
Error accessing oledb
error number = 2032
failed to open the connection:
data source <BEST1>
PROVIDER OLEDB <OraOLEDB.Oracle>
system error delay:
source = OraOLEDB
error Number = -2147467259 (0*80004005)
I am working with Windev 17, please I don’t know what to do and I need help... Thank you

Configuration: Windows 7 / Chrome 52.0.2743.116

3 answers

  1.  nagaD.scar
    Hello,

    The first thing to do would be to provide the piece of code that isn't working x)

    More clearly, based on your post, I would say that you have a declared connector in your analysis. (I assume you have the Oracle drivers and that the connection is working). Are your queries created using the Windev query tool or do you write them manually? Are your connection details dynamic or static? Is your connection properly opened?

    In short, I need a bit more information because as it stands, all I can tell you is that your connection isn't working, but that's not going to help^^

    naga
    0
    1. edmichs Author
      Here is my code:

      gsdReqClient is a Data Source
      MyConnection is a Connection

      // Connection parameters

      IF NOT HDescribeConnection("MyConnection","system","Stage2016","BEST1","BEST1",hOledbOracle,hOLectureEcriture) THEN
      Info("incorrect parameters")
      Erreur(HErreurInfo())

      ELSE
      // Opening the connection
      HOuvreConnexion(MyConnection)

      Hourglass()
      // Executing the query
      IF NOT HExecuteSQLRequest(gsdReqClient, hDefaultRequest, "SELECT * FROM CLIENT") THEN
      Error(HErreurInfo())
      ELSE
      Info("The query contains "+ HNbRec(gsdReqClient) + " records.")
      END

      Hourglass(False)
      END

      I already have a connection established via OLE DB in my analysis, all Oracle drivers are properly installed and the connection I established works well, but when I execute a query it does not work.
      0
      1. nagaD.scar 



        HExécuteRequêteSQL(gsdReqClient, MaConnexion, hQueryWithoutCorrection, "SELECT champ1, champ2, champ3 FROM CLIENT")



        0
      2. nagaD.scar
        ah also, check your connection: 


         IF NOT OpenConnection(MyConnection) THEN
         Error(ErrorInfo()) 
         END


        And check your entry in tnsnames.ora
        0
      3. edmichs Author
        @nagaD.scarThank you already, but it doesn't always work. Here is the new error message it returns:

        OLE DB access error
        error number = 2032
        failed to open the connection:
        data source <BEST1>
        OLE DB PROVIDER <OraOLEDB.Oracle>
        connection error timeout:
        description = A multi-step OLE-DB operation generated errors.
        Check each available OLE-DB status value.
        No work was performed.
        source=Microsoft OLE DB Service Components
        Error Number=-2147217887 (0*8004e21)

        I checked my connection in test mode line by line and apparently that’s where the problem is, it doesn’t open the connection...
        all my entries are correct in my tnsnames.ora
        by the way, here’s my tnsnames.ora:

        # tnsnames.ora Network Configuration File: \app\Edy\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
        # Generated by Oracle configuration tools.

        BEST1 =
        (DESCRIPTION =
        (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = Edy-PC)(PORT = 1521))
        )
        (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = BEST1)
        )
        0
      4. nagaD.scar 




        HDécritConnexion("MyConnection","system","Stage2016","BEST1","",hOledbOracle,hOLectureEcriture)



        Normally, the data source is sufficient in Oracle.

        Oh, I also advise you to properly close the connection (HFermeConnexion) just in case (depending on your setup, you might have a limited or even unique number of connections - just to be safe, restart your Oracle service to cut any potential persistent connections).

        naga
        0
      5. edmichs Author
        @nagaD.scarSorry, but nothing... it always sends the same error message as at the beginning.
        If you have another piece of connection code that allows me to query my database, I'm all ears.
        0
    2. edmichs Author
      I have the native client for Windev 12 and not 17, is it possible to update it?
      0
      1. nagaD.scar
        You can purchase an upgrade license, but you will probably need to make a direct request.
        The prices for the upgrade to the latest version of Windev:
        https://www.pcsoft.fr/pcsoft/tarifs.htm#oracle

        But since in your case you want an upgrade for version 17, you will likely have to make a direct request to them.
        0
      2. edmichs Author
        @nagaD.scarAll I need is this library and not all the native access. Please, if you have it installed, could you send it to me by email??? I would be more than grateful...
        0
      3. nagaD.scar
        No, I think there's a license validation, so the DLL alone wouldn't be enough.. I’ll test it but I don’t know. However, I don’t have access to 17, I’m in 18, so there you go.
        0
      4. edmichs Author
        @nagaD.scarDon't worry about the license, I think it could work with the DLL from version 18.
        0
      5. nagaD.scar
        No, if each DLL were portable from one version to another, they wouldn't sell many licenses ^^ (and ultimately you could just rename your DLL from version 11)

        In fact, the license is tied to a key that is registered when you generate your exe. If there is no license, the exe will not be able to establish the connection.

        The possible solution would actually be to create a DLL (maybe a component would allow you to do that too) in version 11 of WinDev for transactions with Oracle, which you can then import into your project in version 18 to indirectly leverage native access. It's a bit cumbersome, but it should work.
        0