Connecting a script to SQL Server

[Turtle Trader]

When connecting to SQL Server, where would the Connect code go?

Would it go in Initialize() or in OnBarUpdate() but only executed the first time in?

Likewise, where would the Disconnect code go? The connection need to be dropped when the script is terminating...

Thanks

[NinjaTrader_RyanM1]

Hello TurtleTrader,

This is outside scope of NinjaTrader support, but one of our members put together a sample and guide. It's available here:

http://www.ninjatrader.com/support/forum/showthread.php?t=10296

[Turtle Trader]

Thanks...though that script appears to open and close the DB connection each time there is a data point. I am looking for a persistent connection to reduce all that overhead.

If I rephrase the question, perhaps there is an answer...

"Is there a user-usable method that is triggered when the script is terminating?" I can put the disconnect code there.

[NinjaTrader_RyanM1]

Thanks for the reply. Sure, there is OnTermination()

http://www.ninjatrader.com/support/helpGuides/nt7/ontermination.htm

[Turtle Trader]

Perfect...

Thank you.