1 Reply Latest reply: Feb 18, 2009 8:19 AM by 685854 RSS

    OraOledbous10.dll Specific module could not be found

    681544
      To Any Oracle experts,

      I have downloded the latest Oracle 10g Vista\XP client 10.2.03 which includes the OraOledb ADO drivers. I am getting a spuradic error :

      "OraOleDBpus10.dll .. Specific module could not be found." My Oracle database is 9i ..

      Strangly enough .. this only occurs when I run my executable from my local drive ( xp sp3 ) . if I place the executable on a network drive .. running it from my box ( same box ) .. the error does not occur ..

      I am new to this forum .. I am using a TOLeAuto() class from xHarbour and Borland's C++ 5.5 compiler. The below code is the syntax. I loaded the Oracle database utilities, SQL+ and the Windows Drivers which includes the OraOledb. I know the setup is working because I can connect with the SQL+ utility so I know my tnsnames and sqlnet.ora files are correct.

      Again .. this error only shows up sporadically on my local xp-sp3 box .. I have not loaded it on Vista .. and forget about Windows 7 .. the client will not even install because the OS version number is out of range.

      The paths are correct, and my compiled program runs from a network .. just not ( always ) on my local xp sp-3 machine .. especially seems to happen after a run-time failure of my application. This is an app in development and I wil lhave run-time failures constantly.

      Any advice would be quite helpful

      Rick Lipkin
      SC Dept of Health, USA


      //-----------------------------------

      xPROVIDER := "OraOledb.oracle"
      xSOURCE := "efis"
      xUSERID := "suntrack"
      xPASSWORD := "xxxxxxxx"

      oRs := TOleAuto():New( "ADODB.Recordset" )
      oRs:CursorType := 3 // opendkeyset
      oRs:CursorLocation := 3 // local cache
      oRs:LockType := 3 // lockoportunistic

      cSQL := "SELECT FAC.LOCAL_FACIL_EID, "
      cSQL += "FAC.TANK_OWNER_EID, "
      cSQL += "FAC.SITE_NUM AS SITE_NUM, "
      cSQL += "STANDARDTASKS.GETNAME( LOCAL_FACIL_EID,'NO_NUM' ) AS FACILITY, "
      cSQL += "ADDR.ADDRESS_1 AS ADDRESS, "
      cSQL += "ADDR.CITY AS CITY, "
      cSQL += "ADDR.STATE_CODE AS STATE, "
      cSQL += "STANDARDTASKS.GETNAME( FAC.TANK_OWNER_EID,'NO_NUM' ) AS OWNER, "
      cSQL += "FAC.LOCKED_IND AS READ_ONLY "
      cSQL += "from SUNTRACK.EFIS_UST_FACILITIES FAC, "
      cSQL += "SUNTRACK.ADDRESSES ADDR "
      cSQL += "where ADDR.OWNER_EID = FAC.LOCAL_FACIL_EID "
      cSQL += "AND ADDR.ADDRESS_TYPE_CODE = 'BUSINESS' "
      cSQL += "AND ADDR.STOP_DATE IS NULL order by site_num"

      TRY
      oRS:Open(cSQL,'Provider='+xPROVIDER+';Data Source='+xSOURCE+';User Id='+xUSERID+';Password='+xPASSWORD )
      CATCH oErr
      MsgInfo( "Error in Opening EFIS_UST_RELEASES table" )
      oWndChild:Show()
      RETURN(.F.)
      END TRY