Post reply

Connecting to a SQL 7 database via ODBC

  • July 29, 2002 at 1:05 pm

    #63947

    When doing a test connect via ODBC to a SQL db, I receive the following error:

    Microsoft SQL Server ODBC Driver Version 03.80.0194

    Running connectivity tests...

    Attempting connection

    Connection established

    Verifying option settings

    [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied

    on object 'sysconfigures', database 'master', owner 'dbo'.

    [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied

    on object 'syscharsets', database 'master', owner 'dbo'.

    Disconnecting from server

    TESTS FAILED!

    I am able to ping the server, and the DSN is set to TCP/IP and port 1433.

    Anyone have any ideas as to what else I might check? Thanks!

  • July 31, 2002 at 6:35 pm

    #433761

    I would double check the permissions on those tables. For example, on my machine at home sysconfigures has select permission granted to public. Look for a red X on a permission - that's a deny and you'll need to remove it.

    Andy

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

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

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

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