How to reference System.Data.dll in Ninjascript?

[sherazwaqar]

Hello Everybody:

I am using System.Data.dll file in one of my strategies. I have added the reference by right-clicking and selecting references to System.Data.dll file located in Windows --> Microsoft.Net --> Framework --> v2.0.50727

Strategy is working fine and everything is working as expected. I had issues when exporting the strategy. I have included the file "AdditionalReferences" with text "System.Data" at the root level of the exported zip file and have also added the System.Data.dll at the root level of the zip file.

When I import the file on another computer, Ninjatrader do not reference the System.Data.dll and failed to import the strategy.

Please guide what is the appropriate procedure to reference System.Data.dll.

Thank you

[NinjaTrader_Bertrand]

sherazwaqar, the process seems valid - which exact error on import on the other machine do you get thrown? Are moving from a 64 bit setup to a 64 bit setup or otherwise?

[sherazwaqar]

Please see the error messages when importing the strategy. I am developing on a 32 bit windows 7 and trying to import the strategy into 64 bit windows system.

[NinjaTrader_Bertrand]

sherazwaqar, I would expect the outcome when moving to 64 bit from this setup, if you add the 64 bit specific dll into the file would the issue persist (i.e. from this folder C:\Windows\Microsoft.NET\Framework64\v2.0.50727)?

[sherazwaqar]

sherazwaqar, I would expect the outcome when moving to 64 bit from this setup, if you add the 64 bit specific dll into the file would the issue persist (i.e. from this folder C:\Windows\Microsoft.NET\Framework64\v2.0.50727)?

Did the above and received the following message.

[NinjaTrader_Bertrand]

sherazwaqar, thanks. Is there any other 3rd party assembly referenced on the machine you export from? To find out which duplicate it finds offense at, I would suggest to manually install the dll in the bin > custom folder on your target machine, restart NT and recompile.

[sherazwaqar]

I do not have any other dlls referenced in the strategy other than System.Data.dll. I am developing it for commercial purposes and would like to know how should I include 32bit and 64 bit versions of the System.Data.dll file so users should have no issues importing it.

Thank you

[NinjaTrader_Bertrand]

I was not talking about this specific strategy, but the environment you export from in general. There should be no other references than the NT default ones and your explicitly needed one here.

Generally you would then have two versions ship, one for 32 and another for 64 bit.

[sherazwaqar]

This is what I have in installed assemblies.

[NinjaTrader_Bertrand]

Thanks, would still need to be understood what exactly is causing the duplicate message in this case -

'To find out which duplicate it finds offense at, I would suggest to manually install the dll in the bin > custom folder on your target machine, restart NT and recompile.'

[sherazwaqar]

I am able to make the strategy work on other computers. Its still in testing phase so I do not have a dll file yet. I can copy the strategy .cs file to Strategy Folder and open in Ninjascript editor and reference the assembly System.Data.dll and it works fine.

Please let me know, when I reference the dll from my development machine should I should reference it from windows-->microsoft.net--> Framework (adjust the path for 64 bit machine) or should I copy the dll in Custom folder and reference it in strategy from their.