Notice of Maintenance on October 9th. Click here for further details.

x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 3 replies
  • Subscribers 115 subscribers
  • Views 626 views
  • Users 0 members are here
Browse Forums
Announcements
295
topics
270
replies
Databases and Operating Systems
752
topics
3k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
761
topics
2k
replies
Reporting and Analytics
1k
topics
4k
replies
Reports, Macros, and Customizations
800
topics
3k
replies
Sage CRM for Sage 300
189
topics
421
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);

Parents
  • 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.

  • 0 in reply to Hein Thu

    They are global variables.

Reply Children
No Data

*Community Hub is the new name for Sage City