connection to sbo common failed

[former_member344412]

hello all,

I have a little problem.

I have created a little programm who use UI and DI object.

When I launch it with administrator session no trouble.

If I launch it on user session there is an error message : connection to sbo common failed

The user have administrator right but same trouble.

Is there someone who can help me please ?

Laetitia

[Former Member · Accepted solution]

Hi Laetitia,

your user has the admin privilege on Windows or SQL Server ?

Maybe check that the user has a valid login to connect to the SQl server.

Sébastien

[former_member344412 · Accepted solution]

Hi Sébastien,

The user have admin privilege on Windows.

In my code I am connected to the database with admin user and ode.

Laetitia

[Former Member · Accepted solution]

when you connect if you use

oCompany.UseTrusted = True

You have to be sure that the user has an access to SQL Server (it may be admin on Windows, but without access to SQL Server. The login on SQl Server and Windows are different.)

if you use

oCompany.UseTrusted = False

then I guess you know that you have to specify something like that

oCompany.DbUserName = "sa or any SQL Server login"
oCompany.DbPassword = "password"

Sebastien

[former_member344412 · Accepted solution]

oCompany.UseTrusted = True ====> Ok

User has access to sql server and I specify the user and password

I found the problem. The user must have admin right on Windows. And i found a mistake in the sql ODBC link configuration.

Tks for your help