.Net connection problem

icobani

I wrote a small c# code and run in timer internal 5 second. if this program is run i cant login in navision. I have a error message

please Help me [-o<

Error Message:

The following SQL server error(s) occured while accessing the Session Table: 525,"22003",[Microsoft],[ODBC Sql server][Difference of two datetime collumns caused owerflow at runtime. 3621,01100],[Microsoft][ODBC SQL Server Driver][SQL Server]The Statement has been terminated.

SQL:
IF OBJECT_ID('[tempdb]..[#$ndo$sessions]') IS NOT NULL DROP TABLE [#$ndo$sessions]...............








private void showThis()
{
string filter="select * from [" ;//+ txtCompanyName.Text + "$Demands]";
filter+=txtCompanyName.Text.Replace(".","_") + "$Demands] where [End Demand Approval]='" + txtUserName.Text + "'";
SqlConnection con=new SqlConnection(txtConStr.Text);
con.Open();
SqlDataAdapter da=new SqlDataAdapter(filter,con);
DataSet ds=new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count>0)
{
string Message= ds.Tables[0].Rows.Count + " qty demand";
}

con.Close();
}

icobani

http://www.mibuso.com/forum/viewtopic.php?t=12606

kine

see this: http://msmvps.com/blogs/kine/archive/20 ... 00356.aspx

Solution is to not use Per database license, because this check is connected to Per database functionality.

Of course, you still needs to fix the Session table if you need to open that "table".