Post reply

Cannot read table via ODBC

  • February 1, 2007 at 12:40 pm

    #62122

    Here is a strange one. I had an Access DB that I converted to SQL using the upsizing wizard.

    The application works fine.

    When trying to do a project import in MS Project, I can attach to the DB, see a list of tables, but I cannot get the list of fields. The weird thing is that I can read the fields in the dtproperties table. I can also see the fields in any other DB (not converted from Access) on the same server.

    I also have DB Artisan and was going to do a data extract, then recreate the table, and push the data back in. DB Artisan reports the correct number of rows, but when I try to extract, it says there are 0 rows.

    I did everything I could think of with permissions, including giving table level permissions.

    Please help, I am stumped.

  • February 2, 2007 at 10:46 am

    #687491

    Log in with the application on another machine then pull up Current Activity in Enterprise manager.

    Look for the machine name in the list and then verify the which login is being used to connect to the database.

    Then look into permissions for that id in the database.

    Sometimes you are connected with a different login then you realize.

    Live to Throw
    Throw to Live
    Will Summers

  • February 11, 2007 at 4:53 pm

    #689065

    The "dtproperties" table is a system table (created and maintained by SQL Server itself) not an application one.  I think it is used to store details of any database diagrams which may have been created for that specific database.  What is your purpose for querying it?  If your purpose is simply curiosity, forget it.  Only use the table if there is something in it you need for your app - in all the databases I have, there are no records probably because there are no db diagrams

    My thinking as to why you can't see into it is that your login would have to give you administrative rights to access a system table.  I am a domain admins member on our network and can link the table in Access without any problems.  You may have to check the admins role property for the SQL logins you are trying to use if you are not.

    Hopes this provides some clarification.

    Regards

     

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

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