Hi
I am using econnect for inserting vendor information into GreatPlain . The code segment is shown below
string strconnstring = "Data Source=192.168.0.75;Initial Catalog=TWO;User ID=sa;password=password-1;Integrated Security=SSPI;
Persist Security Info=False;";
string strdataxml = "<econnect><taUpdateCreateVendorRcd><VENDORID>110TE001</VENDORID><VENDNAME>110 Technology</VENDNAME><VENDSHNM>110 Technology</VENDSHNM><VNDCHKNM>110 Technology</VNDCHKNM><HOLD>1</HOLD><VENDSTTS>1</VENDSTTS><VNDCLSID>F</VNDCLSID>
<VADDCDPR>PRIMARY</VADDCDPR><VADCDPAD>PRIMARY</VADCDPAD><VADCDTRO>PRIMARY</VADCDTRO>
<TXIDNMBR></TXIDNMBR><TEN99TYPE>1</TEN99TYPE></taUpdateCreateVendorRcd><taCreateVendorAddress ><VENDORID>110TE001</VENDORID><ADRSCODE>PRIMARY</ADRSCODE><VNDCNTCT>AR</VNDCNTCT><ADDRESS1>27 Technology Way</ADDRESS1><ADDRESS2>Millyard Technology Park</ADDRESS2><COUNTRY>UNITED STATES OF AMERICA</COUNTRY><CITY>Nashua</CITY><STATE>New Hampshire</STATE><ZIPCODE>03060-3245</ZIPCODE><PHNUMBR1>(999) 999-9999</PHNUMBR1></taCreateVendorAddress ></econnect>";
try
{
Microsoft.GreatPlains.eConnect.eConnectMethods econnectinstance = new Microsoft.GreatPlains.eConnect.eConnectMethods();
econnectinstance.eConnect_EntryPoint(strconnstring, Microsoft.GreatPlains.eConnect.
EnumTypes.ConnectionStringType.SqlClient, strdataxml, Microsoft.GreatPlains.eConnect.EnumTypes.SchemaValidationType.None, "");
}
catch (Exception ex)
{
string strex = ex.ToString();
}
I am getting the exception The stored procedure 'VENDORID' doesn't exist. Can anybody help on this?
thanks in advance