Saturday, May 22, 2010
Solution to Connect the Remote SQL Server DB
Just give DSN, Username, Password in the LoginProperty.
Friday, May 21, 2010
Facing Problem while connecting Remote Sqlserver DB with Dynamic AX Client using ODBC
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
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
Subscribe to:
Posts (Atom)