Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
karthick.jayavelu 8/21/2009 12:48:58 PM

Vendor record creation

Hi,

 I am using GP10 with SQL server 2005.

Since i am new to econnect i am trying out some sample integration to get an hold on it.  I tried out an sample integration with Vendor master creation, but i am stuck up with a porblem . The XML file was created (under bin>>debug folder) which looks fine. But the problem is with the connection string were the eConnect_EntryPoint throws a exception "Integrated security is required".

 catch (Exception exc)
 {
 //string strmessge = "";
 //strmessge = exc.Message;

 Console.WriteLine(exc.ToString());
 }

 Integrated Security is required.Please ensure that the ConnectionString input parameter is valid.
Examples:SQLCLIENT Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TWO;Data Source=MySQLServerName
Examples:SQLOLEDB Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TWO;Data Source=MySQLServerName
 

But my connection string contain Integrated security = SSPI. I cant figure out whats the exact problem is about, this happens with both my SQL instance. My SQL server instances are AFG5850 and AFG5850\V2 (AFG5850 is my local system name)

string sqlconnec = @"Data Source=AFG5850;Initial Catalog=TWO;integrated security = SSPI;persist security info=False;packet size = 4096";

// Instance2

//string sqlconnec = @"Data Source=AFG5850\V2;Initial Catalog=TWO;integrated security = SSPI;persist security info=False;packet size = 4096";

en.eConnect_EntryPoint(sqlconnec, EnumTypes.ConnectionStringType.SqlClient, svendmstr, EnumTypes.SchemaValidationType.None, "");

 I have included the following namespaces

using System.Collections.Generic;
using System.Text;
using System.Xml;
using System.IO;
using System.Data.SqlClient;
using System.Globalization;
using System.Xml.Serialization;
using System.EnterpriseServices;
using Microsoft.Dynamics.GP.eConnect;
using Microsoft.Dynamics.GP.eConnect.MiscRoutines;
using Microsoft.Dynamics.GP.eConnect.Serialization;

I have tried some security settings which i found in the forum under component service. I have also created my window login account in GP and provided access to DYNAMICS and company db with DYNGRP role.

 Can any one guide me in solving it.

 Thanks!

Version: Unknown or N/A
Section: eConnect








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
site