External reference compiles but doesn't work

[claxxical]

I've used Sqlite in my custom indicator for almost ten years starting back in the NT7 days. When the early NT8 betas came out, I updated my ninjascript successfully and was able to continue Sqlite access from my indicator. I ended up sticking with NT7 for a while but am now giving NT8 a try again and I'm having a problem referencing this dll in 8.0.5.2.

I added the reference by right-clicking in the ninjascript editor. It gets added without any errors and compilation also seems to work as well. However once I open the indicator list on a chart, I see the "Could not load file or assembly" error in the console output.

I'm using the same dll that I've always used before. Any ideas on this? Am I adding the reference incorrectly?

[claxxical]

Hi NinjaTrader_ChrisL,

This is in response to your reply on the post I accidentally made in the NT7 forum:

http://ninjatrader.com/support/forum/showthread.php?p=509213#post509213

Hello,
Thank you for the note.
Please first ensure that you copy the sqlite.dll into C:\Users\<user name>\Documents\NinjaTrader 8\bin\Custom.
Your SQLite dll might be a 32 bit dll since you were using it with NinjaTrader 7. If you are running NinjaTrader 8 as a 64 bit application the dll will not load. Try to obtain the 64 bit version of the dll and see if that works.
Note that the latest version on NinjaTrader is 8.0.6.1 and most importantly that Indicators developed for NinjaTrader 7 will not run on NinjaTrader 8 unless they are ported by the vendor or yourself.
If we may be of any further assistance, please let us know.

----------------------------------------------------------------------------------------------

The dll is in the \bin\Custom folder and is also 64 bit (I was using NT7 64 before). I also ported it successfully in the early NT8 betas as I mentioned so either I'm doing something different now or something changed in NT8 since then. I'll upgrade to the latest version and see if that helps.

Thank you

[NinjaTrader_ChrisL]

Hello,
Thank you for the reply.
Can you please link me to the dll you are trying to use? I have found several different SQLite libraries.
I look forward to your reply.

[claxxical]

Ugh realized I mixed up the dll and it was for the wrong .NET version

[NinjaTrader_ChrisL]

Hello,
Thank you for the reply.
May I confirm, did you resolve your inquiry?
I look forward to your reply.

[claxxical]

Yes the indicator works now. I just wish the error would have caught at compile time. It was a weird time to fail (loading the indicator list on a chart) and I had to open the console output to see it. Anyway, glad it's working now and thanks for your help!