ODBC operation failed. Unable to log on to the database.

(0) Share

Report

Posted on by jr macarilay

470

im trying to connect to a database using odbc in x++. im always getting error that the operation failed. i double checked the server name and the database name and it still wont connect. any thoughts would be appreciated. thanks!

heres a part of my code:

OdbcConnection connection;

LoginProperty loginProp;

;

loginProp = new LoginProperty();

loginProp.setServer("[insert server name here]");

loginProp.setDatabase("[insert database name here]");

try

{

connection = new OdbcConnection(loginProp);

}

catch

{

error ("You do not have access to the database specified");

return;

}

*This post is locked for comments

All responses (2)

Answers (1)

DAXWAR 20 on at

Like (0)

Report

RE: ODBC operation failed. Unable to log on to the database.

Hi Macarilay ,

Hope you are good.

I am facing the very same error "ODBC operation failed.\nUnable to log on to the database.".

I tried with the suggested code change but could not fix it.

logInProperty.setDSN(systemInfo.getloginDSN());

Value is returning in this is null.

It would be great if you could help on this.

Regrds,

DAX
Verified answer

jr macarilay 470 on at

Like (0)

Report

Re: ODBC operation failed. Unable to log on to the database.

solved it. i created a system dsn with the ax database as my default database then i modified my code.

i removed loginProp.setServer and loginProp.setDatabase and replaced it with loginProp.setDSN("[insert DSN name here]")

worked for me.