Hi,

I am new in sage ERP 100. I want to access sage webservice through SOAP UI. Please find the below Request and response. 

Please advise where I missed out!!!!!!!!

SOAP REQUEST

<soapenv:Envelope xmlns:soapenv="schemas.xmlsoap.org/.../" xmlns:ws="http://mas90.sage.com/ws">
<soapenv:Header/>
<soapenv:Body>
<ws:GetCustomer>
<!--Optional:-->
<ws:logon>
<!--Optional:-->
<ws:Password>XXXXXXXX</ws:Password>
<!--Optional:-->
<ws:Username>XXXXX</ws:Username>
</ws:logon>
<!--Optional:-->
<ws:companyCode>XXXXX</ws:companyCode>
<!--Optional:-->
<ws:arDivisionNo>XXXX</ws:arDivisionNo>
<!--Optional:-->
<ws:customerNo>XXXX</ws:customerNo>
</ws:GetCustomer>
</soapenv:Body>
</soapenv:Envelope>

SOAP RESPONSE

<s:Envelope xmlns:s="schemas.xmlsoap.org/.../">
<s:Body>
<s:Fault>
<faultcode xmlns:a="schemas.microsoft.com/.../faultcode>
<faultstring xml:lang="en-US">An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.</faultstring>
<detail>
<ExceptionDetail xmlns="schemas.datacontract.org/.../System.ServiceModel" xmlns:i="www.w3.org/.../XMLSchema-instance">
<HelpLink i:nil="true"/>
<InnerException i:nil="true"/>
<Message>An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.</Message>
<StackTrace><![CDATA[at System.Data.OleDb.OleDbConnectionString.ValidateProvider(String progid)
at System.Data.OleDb.OleDbConnectionString.ValidateConnectionString(String connectionString)
at System.Data.OleDb.OleDbConnectionString..ctor(String connectionString, Boolean validate)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
at System.Data.OleDb.OleDbConnection.ConnectionString_Set(DbConnectionPoolKey key)
at Sage100ERP.WebServices.ObjectManager.Logon(ObjectPool objectPool, Boolean firstLogon, String sqlConnect)
at Sage100ERP.WebServices.ObjectManager.GetObjectPool(MasBusinessObject& masObject, String classKey)
at Sage100ERP.WebServices.ObjectManager.GetObject(String className, String displayClassName, String moduleCode)
at Sage100ERP.WebServices.MasService.GetCustomer(Logon logon, String companyCode, String arDivisionNo, String customerNo)
at SyncInvokeGetCustomer(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)]]></StackTrace>
<Type>System.ArgumentException</Type>
</ExceptionDetail>
</detail>
</s:Fault>
</s:Body>
</s:Envelope>