locked
exe called in SP RRS feed

  • Question

  • Hi,

    I have an exe that is been called from an SP using

    EXEC master..xp_cmdshell  m_Command.exe.

    when i execute this command Shell on my server that is a SQl Server 2005 Ent x64 machine

    NULL

    Unhandled Exception: System.BadImageFormatException: Could not load file or assembly 'Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. An attempt was made to load a program with an incorrect format.

    File name: 'Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, PublicKeyToken=89b483fxxxxxxx342'

       at XXX.DataLayer.DynamicTierDAO.GetXXXMessage(Int32 PersonID, String xxxMessageCode, String oracleConnectionString)

       at XXXTierUpdate.Program.GetXXXMessage(Int32 PersonID, String XXXMessageCode)

       at XXXXTierUpdate.Program.Main(String[] args)

    NULL

    WRN: Assembly binding logging is turned OFF.

    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

    Note: There is some performance penalty associated with assembly bind failure logging.

    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

    NULL

    NULL

     But if I execute the same exe in a SQl Server 2005 Ent x32 machine I get the result set as

     2~  58~  1657~ 88343~   2~  82~  1657~124343~   2~ 106~  1657~160343~~~TIER VALIDITY - 19NOV2013

    Please let me know if you have come across such issue, and how can it be resolved.

    Thursday, December 5, 2013 8:08 AM

Answers

  • Hello,

    Have you installed & setup the 64 bit Oracle client on the machine, where SQL Server is running?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Fanny Liu Monday, December 9, 2013 7:51 AM
    • Marked as answer by Fanny Liu Friday, December 13, 2013 6:27 AM
    Thursday, December 5, 2013 8:26 AM

All replies

  • Hello,

    Have you installed & setup the 64 bit Oracle client on the machine, where SQL Server is running?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Fanny Liu Monday, December 9, 2013 7:51 AM
    • Marked as answer by Fanny Liu Friday, December 13, 2013 6:27 AM
    Thursday, December 5, 2013 8:26 AM
  • yes correct, it seems no oracle client on the server

    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Thursday, December 5, 2013 9:01 AM