Exception handling

[tbmuc]

I'm not sure if this is a ninja or a mysql issue:

I tried to open a mysql connection by the official c# mysql connector demo code within the NinjaScript Initialize -method:

MySql.Data.MySqlClient.MySqlConnection conn;

string myConnectionString;

myConnectionString = "server=127.0.0.1;uid=root;" +
"pwd=12345;database=test;";

try
{
conn = new MySql.Data.MySqlClient.MySqlConnection();
conn.ConnectionString = myConnectionString;
conn.Open();
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
Log(ex.Message);
}


Thereafter I got the Message in the Log-File, that Initialize failed, because "AssembyResolveEvent-Handler cannot return ReflectionOnly Assemblys".

Can exception handling be used within Ninjascript?

Best Regards

Thomas

[NinjaTrader_Joydeep]

Hello Thomas,
NinjaScript is basically c# and you can use the try catch blocks for exception handling. Please refer to this sample code which further illustrates it.

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

SQL is beyond what we can support buy you can refer to this thread which is in similar lines

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

[tbmuc]

Hello Joydeep,

thank you for your support. The error may be caused by a version conflict. I've installed several Net Versions. How can I find out which one is used by the Ninjascript compiler? In the "Assemby Reference" view are the names but no pathes to the system DLLs.

Best Regards
Thomas

[NinjaTrader_Joydeep]

Hello Thomas,
NinjaTrader directs to the .Net Framework 3.5.

A typical path will be like C:\Windows\Microsoft.NET\Framework64\v3.5\

You can download the compatible .Net Framework version 3.5 from here

http://www.microsoft.com/en-us/download/details.aspx?id=22