The basic code is:

using ACCPAC.Advantage;

Session accpacSession;
DBLink mDBLinkCmpRW;
View csQry;

private int OpenDBAndComposeViews(string psCompany)
{
    accpacSession = new Session();
    accpacSession.Init("", "XY", "XY1000", "64A");

    try
    {
        accpacSession.Open("ADMIN", "ADMIN", psCompany, DateTime.Today, 0);
        mDBLinkCmpRW = accpacSession.OpenDBLink(DBLinkType.Company, DBLinkFlags.ReadWrite);
        
        /*
        Compose views here
        */
        csQry = mDBLinkCmpRW.OpenView("CS0120");
        
        return 0;
    }
    catch (Exception ex)
    {
        LogHelper.Log(LogTarget.EventLog, "Unable to connect to Sage. Message: " + ex.Message);

        return 1;
    }
}

private void CloseSageConnectionAndCleanup()
{
    if (csQry != null) csQry.Dispose();
    if (mDBLinkCmpRW != null) mDBLinkCmpRW.Dispose();
    if (accpacSession != null) accpacSession.Dispose();
}

private void DoSomething()
{
    string sDBName = "";
    string sCompanyName = "";
    
    try
    {
        csQry.Browse("select ORGID, CONAME from CSCOM", true);
        csQry.InternalSet(256);

        while (csQry.Fetch(false))
        {
            sDBName = csQry.Fields.FieldByName("ORGID").Value.ToString().Trim());
            sCompanyName = csQry.Fields.FieldByName("CONAME").Value.ToString().Trim();
        }
        
        Console.WriteLine("DB Name: " + sDBName);
        Console.WriteLine("Company Name: " + sCompanyName);
    }
    catch (Exception ex)
    {
        LogHelper.Log(LogTarget.File, $"Error: {ex.Message}");
    }
}

This isn't a fully working piece of code but it gives you the basis of what you need. If you still have problems, let us know.

Thank you so much for the code,

but the exception is as follows:

Invalid Signon Information

Make sure to supply the correct User ID and Password

Thank you so much for the code,

but the exception is as follows:

Invalid Signon Information

Make sure to supply the correct User ID and Password

Have you got the Sage .NET DLLs installed on your machine?

Yes i did, installed properly.

Feels like a permissions thing. Run the app as administrator

yeah i did, nothing same problem.  weird. 

Out of curiosity, what happens if you hard code all of the values, including the org id?

Also can you change your app prefix from XX to XY?

thank you, you got me going on the right path :)

I never noticed you'd put yours as XX. I have always used XY so never thought it could be an issue. Glad it is working.

I think Stephen Smith's blog mentioned, almost in passing, that XY has a specific meaning for the system manager so it knows that it's an external integration/macro. And over the years it seemed to matter more and more. I've used XY for so long that it's just habit now.