Synonym tables not visible via ODBC native Driver

Question

Synonym tables are not visible when we use SQL 2005 Native Client ODBC driver.

is there any limitation or we need to follow any process to create or view table..?

Answer 1

I don't think that there are limitations. Can you check whether the user used for this connection has the necessary permissions for the synonym?

Answer 2

i guess there is not problem with permissions , as user can see tables via OLEDB connections. This is specific to ODBC connections.

Answer 3

Hi Dayanand,

Thanks for your post!

If we are using ODBC connection synonyms doesn’t get showed up in the hirarchy structure. Try and create a command object which will try and fetch the data from a synonym. See if this works for you or not. Suggest you to submit a feedback to Microsoft.

For submitting a feedback to Microsoft such issues, I would recommend to submit it to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback . This connect site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft Connect.

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 4

can you give some example how to use command objects .

Answer 5

Dayanand,

Please see :http://msdn.microsoft.com/en-us/library/aa905898(v=sql.80).aspx

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.