Error: OBDC operation failed. Unable to log on database.

(0) Share

Report

Posted on by Siddhant Singh

502

Hi All,

Error:

OBDC operation failed. Unable to log on database.

Object OBDC connection could not be created.

Below is the code which am running.

    loginProperty = new LoginProperty();
    loginProperty.setDSN("SqlServerTest");
    loginProperty.setDatabase("WorkPay");

    odbcConnection = new OdbcConnection(loginProperty);
    if(odbcConnection)

Can someone please help me on this. What is the reason behind the error?

Thanks and regards

Siddhant Singh

All responses (4)

Answers (1)

Suggested answer

Siddhant Singh 502 on at

Like (0)

Report

RE: Error: OBDC operation failed. Unable to log on database.

Hi all,

Please find below link, this also help me.

axvuongbao.blogspot.com/.../how-to-create-dsn-and-connect-to.html

Thanks and regards

Siddhant Singh
Siddhant Singh 502 on at

Like (0)

Report

RE: Error: OBDC operation failed. Unable to log on database.

Hi Nikoloas/ Ergün,

I am getting this error on configuration level. How can we fix this?

Thanks and regards

Siddhant Singh
Verified answer

ergun sahin 8,812 Super User 2024 Season 1 on at

Like (1)

Report

RE: Error: OBDC operation failed. Unable to log on database.

Did you create DSN

docs.microsoft.com/.../how-to-connect-to-an-external-database-from-x-code

Edit: Sorry for a moment I thought you were connecting to an external db
Suggested answer

nmaenpaa 101,156 on at

Like (0)

Report

RE: Error: OBDC operation failed. Unable to log on database.

Hi Siddhanth,

you're not providing any username or password. That's why it fails and that's the reason behind the error.