1 Reply Latest reply on Jun 13, 2011 10:51 AM by -==cfSearching==-

    Connect to .NET dll

    mullentr

      Using CF 8 - IIS - Oracle

       

      I'm trying to connect to a .NET dll and can kind of connect but keep getting the error system/data/odbc/odbcconnection not found in specified assembly list.

       

      Here's the .NET documentation I got:

       

      To Insert payment use the function InsertPaymentTrans in GeneralLedgerBL.dll. Returns string

       

      GeneralLedgerBL.GLTransaction GLTrans = new GeneralLedgerBL.GLTransaction();

       

      strMessage = GLTrans.InsertPaymentTrans(ID, TimeframeID,TransAmount,TransID);

       

      To void a transaction use the function VoidTransaction in GeneralLedgerBL.dll Returns string

       

      GeneralLedgerBL.GLTransaction GLTrans = new GeneralLedgerBL.GLTransaction();

       

      strMessage = GLTrans.VoidTransaction(TransID);

       

      Honestly have no idea how to translate this to Coldfusion...

       

      Also, I ran a .reg file that inserted the following into the registry:

       

      [HKEY_LOCAL_MACHINE\SOFTWARE\CDOR\HOUS\GL]
      "ID"="MYID"
      "PWD"="MYPWD"
      "DSN"="MYDSN"

       

      And when I do this it fids the dll, but retursns the system/data/odbc/odbcconnection error
      <cfobject type=".NET" name="myObj" class="GeneralLedgerBL.GLTransaction" assembly="mypath/GeneralLedgerBL.dll">

       

      The .NET developer said I have to initiate the class first... I've tried and can't get anything to work. Yes, the .NET Integration service is running and dll is local.
      Any help on this would be appreciated!