Problem while connecting to sage (hangs up)

Kiran · ‎03-10-2011

I have problems while connecting to sage.

I have made a program in dot net which uses sage in backend.

I have made use of sage 50 accounts 2011

Two to three times the program runs but then after that it hangs up on

this statement oWS.Connect(szDataPath, "MANAGER", "", "SDO EXAMPLE");

It just shows that the page is loading but doesnot do any thing.

I have added try catch block but it doesnot go in catch block too.

My code is as below

private List<SageProduct> GetProductFromSage()
        {
            List<SageProduct> lstSagePrdt = new List<SageProduct>();

            # region GetProductsSage

            //Declare Variables

            SageDataObject170.SDOEngine oSDO = new SageDataObject170.SDOEngine();

            SageDataObject170.WorkSpace oWS = null;

            SageDataObject170.StockRecord oStockRecord;

            String szDataPath;

            //Instantiate WorkSpace

            oWS = (SageDataObject170.WorkSpace)oSDO.Workspaces.Add("StockRecordExamplesss");
            oWS.UI = true;

            //Show select company dialog

            string SageCompany = ConfigurationManager.AppSettings["SageDataPath"];

            //szDataPath = oSDO.SelectCompany(SageCompany);

            szDataPath = SageCompany;

            //Try a connection, will throw an exception if it fails

            try
            {

                //Leaving the username and password blank generates a login dialog
                try
                {
                    oWS.Disconnect();
                    string strError = oSDO.LastError.Text;
                    oWS.Connect(szDataPath, "MANAGER", "", "SDO EXAMPLE");
                    string strErrors = oSDO.LastError.Text;

                }
                catch (Exception ex)
                {
                    oWS.Disconnect();
                    string strErrorss = oSDO.LastError.Text;
                }



                oStockRecord = (SageDataObject170.StockRecord)oWS.CreateObject("StockRecord");

                for (int i = 1; i <= oStockRecord.Count; i++)
                {
                    oStockRecord.Move(i);

                    MegaTreasure.com.Classes.SageProduct prd = new MegaTreasure.com.Classes.SageProduct();
                    prd.STOCK_CODE = (string)SDOHelper.Read(oStockRecord, "STOCK_CODE");
                    prd.DESCRIPTION = (string)SDOHelper.Read(oStockRecord, "DESCRIPTION");
                    prd.STOCK_CAT = (Int16)SDOHelper.Read(oStockRecord, "STOCK_CAT");
                    lstSagePrdt.Add(prd);
                }
                oWS.Disconnect();

            }
            catch (System.Exception excptn)
            {
                oWS.Disconnect();
            }

            return lstSagePrdt;
            #endregion
        }

Can please help me out how i can get the problem??

Thanks & Regards,

Kiran Nakhale