Problems setting up the ODBC Driver Manager on laptop.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Essie
    New Member
    • Dec 2011
    • 4

    Problems setting up the ODBC Driver Manager on laptop.

    When i go to set it up i go to the System DSN, select Add driver,
    the only option there is SQL Server so I click on that
    there is a wizard to create an ODBC data source to connect to SQL Server.
    These are the details i put in
    Name SQL Server
    Description ODBC connector for MS Dynamics
    Server DELPHSQL\DYNAMI CSSQL.
    But i get a SQL Server login error.
    SQL Server Error: 11001

    Any help on what i'm doing wrong or advice on how to set it up?

    Thanks
  • kuldeeprsks
    New Member
    • Dec 2011
    • 22

    #2
    Check whether you are able to login into the mentioned sql server wiht the userid& password used in the DSN connection if not then it may be Admin rights issue. If so then assign rights to your ID or reinstall the same with you loginid.

    Comment

    Working...