Oracle OleDB client .dll error ( NageswaraRao help ?? )

[Rick Lipkin]

To Any Oracle experts

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

OraOleDBpus10.dll .. Specific module could not be found

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

Rao .. if you are reading this .. I know you do a lot of Oracle .. any ideas here ??

Rick Lipkin

Code: Select all

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

oRs := TOleAuto():New( "ADODB.Recordset" )
oRs:CursorType     := 1        // 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

[nightwalker]

You need to register the Oracle Data Provider for a client PC.

Ex. regsvr32 OraOLEDB10.dll ......... ?!

[Rick Lipkin]

Nightwalker

Thank you for responding .. by accident I think I found out what was happening .. I use xMate and when I launch the executable from from the build ( from xMate ) .. that is where the error occurs .. if I just build the program, then click and run the program from the executable .. I have no problems.

I think it has something to do with the 'country code' or language. Launching the executabe from xMate was the problem .. I have no clue why ?? .. but if I just build the exe and run it from the local drive, or from a network drive .. it works GREAT !!

Rick Lipkin