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