ODBC does not add entry

  • hi everyone,

    I am trying to add ODBC connection from a user computer to Sql Server 2000. The connection fails and no entry is created under system DSN. However, when I give admin privilages to the user, everything works. Any idea why? I have never seen this problem before. Thanks in advance.

  • Permissions on the registry? Maybe seriously locked down under average user account.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • What is the error message?

    Are you attempting Trusted connection or sql login? What library are you using pipes or TCP/IP? Is the server behind a firewall? Can you ping the server? Is the server name known?

    Sorry if these seem obvious questions but they are the sort of questions I ask myself when I have connection problems.

    Far away is close at hand in the images of elsewhere.
    Anon.

  • We are using TCP/IP, sql login, the server is not behind a firewall, and it can be pinged. Thanks.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply