Archive for July 2010
Just give DSN, Username, Password in the LoginProperty.
Facing Problem while connecting Remote Sqlserver DB with Dynamic AX Client using ODBC
Posted July 16, 2010
on:Hi,
I connect sql server db(not a default one it is a another db) from Dynamics Axapta 2009.
I used odbc to connect and retrive data.
It was work fine in the server.
but when i was woked in ax client it show an error like this:
1) ODBC operation failed.Unable to log on to the database.
2) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘ASCENDERS\vasanth’.
3)Object ‘OdbcConnection’ could not be created
i am also given the user name as sqlserver username “sa” but it take my window authentication.
i don’t know how to solve the problem.plz help me with your valuable ideas..
Thanks in advance
Vasanth.A