DynDeveloper.com

If you're a consultant, entering reg keys in Dynamics is a simple thing, you do it daily (or so it seems)

Developers do it far less frequently, so this is a short guide on how to enter the registration keys in Dynamics GP

Why would a developer care about reg keys? Because you can't do any VBA or Modifier mods without a set of keys that allow it.

This simple query is a starter for an AR report, it displays data by month (sales, payments, net) and adds a running total

The final output looks like this:

Here is the code: I am getting the error when submitting the data. No Error coming when reading the data. This is small service upgrade from version 8 to 10.

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient; 
using System.Diagnostics;
using System.Web;
using System.Web.Services;
using System.EnterpriseServices;
using Microsoft.Dynamics.GP.eConnect;
using System.Xml;

namespace eConnect
{
	/// <summary>
	/// Web service for Great Plains integration via eConnect
	/// </summary>
	public class Poster : System.Web.Services.WebService
	{
        String ConnectionString;
        XmlDocument xmlDoc;

		public Poster()
		{
			//CODEGEN: This call is required by the ASP.NET Web Services Designer
			InitializeComponent();
		}

		#region Component Designer generated code
		
		//Required by the Web Services Designer 
		private IContainer components = null;
				
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
		}

		/// <summary>
		/// Clean up any resources being used.
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if(disposing && components != null)
			{
				components.Dispose();
			}
			base.Dispose(disposing);		
		}
		
		#endregion

		[ WebMethod(TransactionOption=TransactionOption.RequiresNew) ]
		public eConnectResult PostDoc(string xmldoc2)
		{
//            eConnectResult r = new eConnectResult("");
//            ContextUtil.DisableCommit();
//            ExecProcsXML.ExecStoredProcedure8Class test = new ExecProcsXML.ExecStoredProcedure8Class();
//            try 
//            {
//                r.result = test.ExecStoredProc(xmldoc,System.Configuration.ConfigurationSettings.AppSettings

[ "GPConnectionString"],ref r.errState,ref r.errString,ref r.soapMessage);
//                if (test.eConnectErrorState > 0)
//                {
//                    foreach (object o in test.ErrorCodes)
//                        r.errString += o.ToString();
//                    ContextUtil.SetAbort();
//                }
//                else
//                    ContextUtil.SetComplete();
//            }
//            catch
//            {
//                ContextUtil.SetAbort();
////				throw;
//            }
//          return r;
            xmlDoc.PreserveWhitespace = true;
            eConnectResult r = new eConnectResult("");
            ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["GPSqlConnectionString"];
            eConnectMethods eConnObject = new eConnectMethods();
            try
            {
                xmlDoc.LoadXml(xmldoc2);
                r.result = eConnObject.eConnect_EntryPoint(ConnectionString, 
EnumTypes.ConnectionStringType.OleDB, xmlDoc.OuterXml, EnumTypes.SchemaValidationType.None, null);
                ContextUtil.SetComplete();
            }
            catch (eConnectException ex)
            {
                r.errString  = ex.Message.ToString();
                ContextUtil.SetAbort();
            }
            catch (System.Data.SqlClient.SqlException ex)
            {
                foreach (object o in ex.Errors )
                    r.errString += o.ToString();
                ContextUtil.SetAbort();
            }
            catch (Exception ex)
            {
                r.errString = ex.Message.ToString();
                ContextUtil.SetAbort();
            }
        
            return r;
		}
        [WebMethod(TransactionOption = TransactionOption.RequiresNew)]
        public String PostDoc200(string xmldoc2)
        {
            bool eConnResult = false;
            String r;
            eConnectMethods eConnObject = new eConnectMethods();
            try 
            {
                r = "";
	            xmlDoc.LoadXml(xmldoc2);
	            if (IsRequesterDoc(xmlDoc) == true) {
		            r = eConnObject.eConnect_Requester(ConnectionString, 
EnumTypes.ConnectionStringType.OleDB, xmlDoc.OuterXml);
	            } 
                else 
                {
		            eConnResult = eConnObject.eConnect_EntryPoint(ConnectionString, 
EnumTypes.ConnectionStringType.OleDB, xmlDoc.OuterXml, EnumTypes.SchemaValidationType.None, null);
		            if (eConnResult == true) {
			            ContextUtil.SetComplete();
		            } else {
			            ContextUtil.SetAbort();
		            }
	            }
            } 
            catch (eConnectException eConnErr) 
            {
	            r= eConnErr.Message;
                ContextUtil.SetAbort();
            } 
            catch (ApplicationException ex) 
            {
	            r= ex.Message;
                ContextUtil.SetAbort();
            }
            return r;
        }

        [WebMethod]
		public DataSet ReadTable(string table,string columns,string condition)
		{
			DataSet s = new DataSet();
			string sql = "select " + columns + " from " + table;
			if (condition != "") sql += " where " + condition;
			OleDbConnection con = new OleDbConnection();
            //SqlDataAdapter.SqlConnection con = new SqlConnection();
            con.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings
["GPSqlConnectionString"];
			OleDbCommand cmd = new OleDbCommand(sql,con);
            //SqlCommand cmd = new SqlCommand(sql, con);
			con.Open();
			OleDbDataAdapter ad = new OleDbDataAdapter(cmd);
            //SqlDataAdapter ad = new SqlDataAdapter(cmd);
			ad.Fill(s,table);
			cmd.Connection.Close();
			return s;
		}

		public struct eConnectResult
		{
			public int errState;
			public string errString;
			public bool result;
			public string soapMessage;

			public eConnectResult(string s)
			{
				errState = 0;
				errString = "";
				result = false;
				soapMessage = "";
			}
		}
        private static bool IsRequesterDoc(XmlDocument doc)
        {
            //Create an XML node and query the document for the <Outgoing> node
            XmlNode RequesterMessage = default(XmlNode);
            RequesterMessage = doc.SelectSingleNode("//Outgoing");

            //Return False if the <Outgoing> node is not found or its value is not equal to TRUE
            //Return True when the <Outgoing> node exists and it's value is equal to TRUE
            if (RequesterMessage == null)
            {
                return false;
            }
            else
            {
                if (RequesterMessage.InnerText == "TRUE")
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
        }
	}
}

On a Win2K8 server, I'm getting an error message when trying to start eConnect:

The eConnect for Microsoft Dynamics GP2010 Integration Service service on <machine name> started and then stopped.

The error message is below.

When installing GP10 on a Win 2003 server, I get a red 'x' next to Microsoft Dexterity Shared Components 10.0.

Then: Initialization failed. Review the log file for more details: C:\DOCUME~1\<USERNAME>\LOCALS~1\Temp\1\log849.tmp

I drilled down in the CD to the Bin\DexCmn folder and ran the Dex Common files setup separately, and I got:

.Net Framework 2.0 is not installed. The installation cannot continue

Then: The Dexterity Shared Components installation has ended prematurely. Click Finish to exit the installation

It won't surprise you to learn that it is installed, in fact the 3.0 and 3.5 framework are also installed.

I'm getting this error:

Unable to open module file 'C:\Users\<app name>\AppData\Local\Temp\3\.NETFramework,Version=v4.0.AssemblyAttributes.vb': The system cannot find the file specified.

When I run a certain application in Visual Studio 2010