Copy link to clipboard
Copied
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!
Copy link to clipboard
Copied
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.
That is a .net class too (system). Maybe CF cannot access it. Try appending the path to that dll to your assembly list.
http://msdn.microsoft.com/en-us/library/system.data.odbc.odbcconnection.aspx
system/data/odbc/odbcconnection