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:
ODBC operation failed.Unable to log on to the database.
[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