question

Larry avatar image
Larry asked

Tables not shown when creating an ODBC connection

I have two SQL servers, one 2000 server, and a 2005 server. As far as I can tell the permissions are configured the same, when I add an ODBC connection to the 2000 server, in the "Administrative Tools, Data Sources (ODBC)" where is says "Change default database to" I can click the down arrow and see a list of all tables on this server. But when I create a connection to the 2005 server I cannot see all tables, only master and tempdb. Why can I not see all tables on the 2005 server?
sql-server-2005sql-server-2000permissionsodbc
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
Can you please review your question and correct anywhere that you have typed 'tables' but actually meant 'databases'please? master and tempdb are databases, not tables.
0 Likes 0 ·

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
I would hazard a guess that the issue is security. It sounds like the login being used to access the Server doesn't have access to any of the databases. You should try connecting with a different account, one that you know has the access, or have someone else do that for you, and check the security setting for the login attempting to connect.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.