Which server must the client connect to?

[Former Member]

Hi,

The following is our current setup:

SQL Server database is running on machine X.

SAP Business One Server is running on machine Y.

License Manager is also running on machine Y.

Here is the code to connect to the SAP Business One Server:

SAPbobsCOM.CompanyClass c = new SAPbobsCOM.CompanyClass();

c.Server = "Y";

c.CompanyDB = "SBODemo_US";

c.UserName = "manager";

c.Password = "manager";

c.language = SAPbobsCOM.BoSuppLangs.ln_English;

c.Connect();

This code fails with an error that the connection to SBO_Common could not be established.

However, if I change the server to point to X, the connection goes through.

This is puzzling. Why must I connect to the database server machine and not the machine running SAP Business One Server? Shouldn't I be connecting to the middleware tier and not the database tier?

Thank you in advance for enlightening me.

Sunny

[Former Member · Accepted solution]

Hi Sunny,

As the DI help file says, the Server property specifies the SQL server to which the company object connects.

The company object is a copy of the business tier of SAP Business One (that´s why it is a fat client application). And it needs to connect to the database.

Take a look at a general view of SBO architecture to understand it better.

Regards,

Ibai Peñ