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
Posted by at

2 comments:

  1. AscendersMay 22, 2010 at 1:42 AM

    Just give the DSN, Uname and Password in the LoginProperty class.

    ReplyDelete
  2. Microsoft Dynamics AXMay 26, 2010 at 12:24 AM

    Hi Vasanth,
    You need to create a DSN in your local system.

    Please look into my blog ,

    http://ramesh-technical-consultant.blogspot.com/

    ReplyDelete

Subscribe to: Post Comments (Atom)