x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 3 replies
  • Subscribers 118 subscribers
  • Views 353 views
  • Users 0 members are here
Browse Forums
Announcements
268
topics
260
replies
Databases and Operating Systems
758
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
851
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
876
topics
3k
replies
Sage CRM for Sage 300
182
topics
410
replies
Hein Thu

Using existing connection in Accpac Advantage

Posted By

Hi Everyone,

I am now developing a .NET exe and Accpac.Advantage to open the view and import into Sage. But currently how I design is using the one sage login to open the view and do the stuff inside the program. Now I would like to change it to use the current Sage login User so that I don't have to store the login detail inside the program. Please help to advise. Below is my current code to open the view and I want to change it to use the current sage user. Thank you in advance.

session = new ACCPAC.Advantage.Session();
session.Init("", "XY", "XY1000", "70A");
string userID = Settings.Default.mUsername;
string password = Settings.Default.mUserpassword;
string companyid = Settings.Default.mDatabasename;
session.Open(userID, password, COMPANY, DateTime.Today, 0);
mDBLinkCmpRW = session.OpenDBLink(ACCPAC.Advantage.DBLinkType.Company, ACCPAC.Advantage.DBLinkFlags.ReadWrite);

  • 0

    I use the code below in programs with a form, it will use the existing user's Sage session.  If the user isn't logged into Sage, it will pop up the regular login screen.

    public static AccpacSession session ;
    public static AccpacDBLink a4wLink;
    public static AccpacDBLink a4wLinkRead;
    public static AccpacSessionMgr sessionmgr;

    sessionmgr = new AccpacSessionMgr(); // As New AccpacSessionMgr
    Int32 sid = 0;

    sessionmgr.AppID = "XY";
    sessionmgr.ProgramName = "XY1000";
    sessionmgr.AppVersion = "60A";
    sessionmgr.CreateSession("", sid, out Globals.session);
    a4wLink = Globals.session.OpenDBLink(tagDBLinkTypeEnum.DBLINK_COMPANY, tagDBLinkFlagsEnum.DBLINK_FLG_READWRITE);
    a4wLinkRead = Globals.session.OpenDBLink(tagDBLinkTypeEnum.DBLINK_COMPANY, tagDBLinkFlagsEnum.DBLINK_FLG_READONLY);
    sMigratorUser = Globals.a4wLink.Session.UserID;
    sMigratorCompany = Globals.a4wLink.Session.CompanyID;

  • 0 in reply to Jay Converse Acumen

    Hi Sir, Thank you for your help and showing me how to do it. But i would like to ask one thing. Where does this Globals.session come from? Thanks again.

*Community Hub is the new name for Sage City