I have written this code to connect to external DB with connection string as credential for this connectivity but it is throwing error which i highlighte dat bottom.
Please look into that reply it as soon as possible.
Public static void main(Args _args)
{
ODBCConnection myODBC;
Statement myStatement;
LoginProperty myLoginProperty;
Resultset myResultset;
SqlStatementExecutePermission sqlPermission;
str mySQLStatement;
str myConnectionString;
//str myDSN=“yourdatasourcenamehere”;
str myUserName=“BWCINC\tbwir”;
str myPassword="********";
;
myConnectionString=strfmt(“UID=%1;PWD=%2”,myUserName,myPassword);
myLoginProperty = new LoginProperty();
myLoginProperty.setServer(“BWIRAXSVR04”);
myLoginProperty.setDatabase(“MicrosoftDynamicsAX”);
myLoginProperty.setOther(myConnectionString);
try
{
myODBC = new OdbcConnection(myLoginProperty);
myStatement=myODBC.createStatement();
mySQLStatement=“SELECT * FROM CustTable”;
sqlPermission = new SQLStatementExecutePermission(mySQLStatement);
sqlPermission.assert();
myResultSet=myStatement.executeQuery(mySQLStatement);
while (myResultSet.next())
{
info(strFmt("%1, %2", myResultSet.getString(1), myResultSet.getString(4)));
//info(int2str(myResultSet.getInt(2)));
}
CodeAccessPermission::revertAssert();
} catch
{
error(‘Unexpected error’);
}
}
THSI CODE IS NOT BRING VALUE FROM CUSTTABLE AND SHOWING THE ERROE LIKE THAT—"[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user ‘BWCINC\Jatul’" LIKE THAT".
PLEAE REPLY FOR IT AS SOON AS POSSIBLE.