Skip to main content
Participant
June 12, 2011
Question

Connect to .NET dll

  • June 12, 2011
  • 1 reply
  • 406 views

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!

This topic has been closed for replies.

1 reply

Inspiring
June 13, 2011

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