You’re offline. This is a read only version of the page.
87
Hello everyone.
I have a little problem, I wrote a class in AX 2009 witch imports data from a DB2 database. For the connection I use ODBC (System-DNS).
The class runs directly without any problems, only as batch job, I get an error: The user can not login to Database. But tht user and the password are part of the odbc settings.
public void run()
{
loginProperty loginProperty = new LoginProperty();
ODBCConnection odbcConnection;
Statement sql;
ResultSet result;
;
//BP Deviation documented
loginProperty.setDSN('DNSNAME');
//BP Deviation documented
odbcConnection = new ODBCConnection(loginProperty);
if (odbcConnection)
{
//BP Deviation documented
sql = odbcConnection.createStatement();
//BP Deviation documented
result = sql.executeQuery("Select * from DEMOTbl");
while (result.next())
{
......
}
*This post is locked for comments
Hello.
An entry must be made on the batch server in the DNS system. Important, if you open it via the start menu, probably the 64 bit version will be opened, I have also entered it in the 32 bit version. Of course as a system DNS entry.
In addition, I have entered it on the AOS server, which is not running as a batch server.
Unfortunately, that was a few years ago, at the moment I am working more with 2012 and 365.
Best wishes from my holiday in Norway
Jens
Hi,
in my case I cratered the connection on the Batch Server.
Create the DSN on the batch server and try..
where is your DSN created? is it on the local machine form where you are running it?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,219
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (