Dynamics Community Forum Thread Details

pls review my code for gp connection

Hi, Friends

I had write the following code to retrieve data from gp sql server..But an error "login failed for user is shown"..why this happen? pls help me

//code

           string    connectionString = "Data Source=servername;Initial Catalog=dbname;Integrated Security=SSPI;Persist Security Info = false;Packet Size = 4096";
             eConnectMethods eConnectObject = new eConnectMethods();
            eConnectOut myRequest = new eConnectOut();

            myRequest.DOCTYPE = "Customers";
           myRequest.OUTPUTTYPE = 1;
           myRequest.INDEX1FROM = "AARONFIT0001";
          myRequest.INDEX1TO = "AARONFIT0001";
            myRequest.FORLIST = 1;

RQeConnectOutType eConnectOutType = new RQeConnectOutType();

            eConnectOutType[0].eConnectOut = myRequest; // error appears in this line
            eConnectType eConnectDoc = new eConnectType();
            eConnectDoc.RQeConnectOutType = new RQeConnectOutType[1] {eConnectOutType};

            MemoryStream memStream = new MemoryStream();
            XmlSerializer serializer = new XmlSerializer(typeof(eConnectType));
            serializer.Serialize(memStream, eConnectDoc);
            memStream.Position = 0;
            XmlDocument myDoc = new XmlDocument();
            myDoc.Load(memStream);

txtUsername.Text = eConnectObject.eConnect_Requester(connectionString, EnumTypes.ConnectionStringType.SqlClient, myDoc.OuterXml);// error shown in this line

Is there is any other method to retrieve the specified data (other than the last line)?

Quick Links

Leaderboard