Passwords should be uppercase

thank you i will try :)

i tried doing upper case and nothing, still gives me the following error;

COMException: Invalid Signon Information.

Make sure you supply the correct User ID and Password.

What user  profile login in the app using.  Try using the same one as the one used to create the Sage database.  I had this happen last wk and when I used the windows user login I used to create the sql and sage it worked 

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.

i'm not using Windows Authentication to log into Sage on the network.

I was given a User Name and Login and i picked the data on the network when i Installed Sage.

For some reason the login works in Sage, but when i try using it in my own C# code. it does not like it.

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

I was not either but I think it had to do with permissions to some folders, etc 

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

yeah i can list the companies already, but when i send my User Name , Password and Comp name, it bombs.

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.