x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 18 replies
  • Subscribers 119 subscribers
  • Views 1693 views
  • Users 0 members are here
Browse Forums
Announcements
271
topics
260
replies
Databases and Operating Systems
766
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
853
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
877
topics
3k
replies
Sage CRM for Sage 300
183
topics
415
replies
BOB2023

Sage 2017 - 64A can't login through C# App.

SOLVED
Posted By

Wrote simple app to simulate login into Sage 300 in C#

i can query the company names... but when i try to actually use a password and login user it gives me Invalid Signon Information error message, anyone know what i'm doing wrong?

session = new ACCPAC.Advantage.Session();
session.Init("", "XX", "XX1000", "64A");
foreach (Organization org in session.Organizations)
{
if (org.Type.ToString() == "Company")
{
Company.Items.Add(org.Name);
}
Info.Text += "Company ID: " + org.ID + " Name: " + org.Name + " Type: " + org.Type + "\r\n";
}

session.Open("BOB", "somePassword", Company.Text, DateTime.Today, 0);
mDBLinkCmpRW = session.OpenDBLink(ACCPAC.Advantage.DBLinkType.Company, ACCPAC.Advantage.DBLinkFlags.ReadWrite);

Parents
  • 0

    Edit: I see that you've already got this part.  I'll see if I can dig up the Windows Auth code

    Edit 2: If you're going to use a Windows login, be sure to call sess.OpenWin and not sess.Open.

    I haven't checked this code for a while but given that you don't have to be signed on to access the list of Orgs then you can make use of the AccpacOrganizations object.

    Dim Orgs As AccpacCOMAPI.AccpacOrganizations
    Dim sess As AccpacCOMAPI.AccpacSession
    Dim Org As AccpacCOMAPI.AccpacOrganization

    Set sess = New AccpacCOMAPI.AccpacSession
    sess.Init "", "XY", "XY0001", "61"
    Set Orgs = sess.Organizations
    Orgs.Reset

    While Orgs.Next(Org)
      If Org.Type = ORG_COMPANY Then
        debug.print Trim$(Org.Name)
      End If
    Wend


    Set Org = Nothing
    Set Orgs = Nothing
    Set sess = Nothing

Reply
  • 0

    Edit: I see that you've already got this part.  I'll see if I can dig up the Windows Auth code

    Edit 2: If you're going to use a Windows login, be sure to call sess.OpenWin and not sess.Open.

    I haven't checked this code for a while but given that you don't have to be signed on to access the list of Orgs then you can make use of the AccpacOrganizations object.

    Dim Orgs As AccpacCOMAPI.AccpacOrganizations
    Dim sess As AccpacCOMAPI.AccpacSession
    Dim Org As AccpacCOMAPI.AccpacOrganization

    Set sess = New AccpacCOMAPI.AccpacSession
    sess.Init "", "XY", "XY0001", "61"
    Set Orgs = sess.Organizations
    Orgs.Reset

    While Orgs.Next(Org)
      If Org.Type = ORG_COMPANY Then
        debug.print Trim$(Org.Name)
      End If
    Wend


    Set Org = Nothing
    Set Orgs = Nothing
    Set sess = Nothing

Children

*Community Hub is the new name for Sage City