DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
pramodhc 5/28/2008 8:22:20 AM

The stored procedure 'VENDORID' doesn't exist.

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

 

 

 

Version: Unknown or N/A
Section: eConnect