Getting error while establishing ODBC connection in AX2012

(0) Share

Report

Posted on by Rhushikesh R

758

Hi,

Need urgent help.

I am using below code for establishing ODBC connection but getting error as

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

Please help.

static void SITestODBC(Args _args)
{
    OdbcConnection           oDBCConnection;
    LoginProperty            loginProperty;
    str                      connectionString;


    try
    {
        connectionString = "DSN=RFIDDB_UAT;Database=myTest_db;UID=sa;PWD=$1234;";

        loginProperty = new LoginProperty();
        loginProperty.setOther(connectionString);
        oDBCConnection = new ODBCConnection(loginProperty);
        if(oDBCConnection)
        {
            info("success");
        }
    }
    catch
    {
        throw error("@CHI814");
    }

}

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

WillWU 22,363 on at

Like (2)

Report
Copy link

Link copied!
Hi Rhushikesh Raut,

How did you create your DSN?

You don't need to put the username and password in your connection string.

Try the following code:
loginProperty = new LoginProperty(); loginProperty.setDSN("dsnName"); loginProperty.setDatabase("databaseName"); odbcConnection = new OdbcConnection(loginProperty);

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

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report
Copy link

Link copied!

Hi Will, I will test the connection directly from Administrative tools first and will update you. It might be the case that the credentials have been changed as before this error I was able establish connection with same code.

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report
Copy link

Link copied!

Hi Rhiushikesh,

Please check if any permissions have been changed on the external database as well. That could also cause this issue.

Was this reply helpful? Yes No
Suggested answer

A.Prasanna 8,225 on at

Like (1)

Report
Copy link

Link copied!

also maks sure you are allow required Ports through firewall(s)

1433 (ODBC)

netbios (UDP ports 137, 138 & TCP 139 for NetBIOS over TCP)

Regards,

Amith Prasanna

Was this reply helpful? Yes No