This discussion is archived
1 Reply Latest reply: Feb 18, 2009 6:19 AM by 685854 RSS

OraOledbous10.dll Specific module could not be found

681544 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points