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

(0) Share

Report

Posted on by Siddhant Singh

518

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

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

Hi Siddhanth,

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

Was this reply helpful? Yes No
Verified answer

ergun sahin 8,826 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
Siddhant Singh 518 on at

Like (0)

Report

Hi Nikoloas/ Ergün,

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

Thanks and regards

Siddhant Singh

Was this reply helpful? Yes No
Suggested answer

Siddhant Singh 518 on at

Like (0)

Report

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

Was this reply helpful? Yes No