Calling SQLTables() in the ODBC API never returns table synonyms for SQL Server databases

Question

Our product (SAP Crystal Reports 2008/2011) uses ODBC API call SQLTables to retrieve tables information as well as table synonyms, this is worked for DB2 and Oracle, but not for Mircrosoft SQL Server 2005/2008, for both ODBC and OLEDB.

We tried use ODBCTest tool, the result is the same, no synonyms tables returns.

The related information and questions we raised could be found at .. (none are resolved our questions)

Forum:  http://social.msdn.microsoft.com/Forums/en-ZA/transactsql/thread/69bc4576-d65e-474c-af79-c00af41f2613

Connect: http://connect.microsoft.com/SQLServer/feedback/details/615408/calling-sqltables-in-the-odbc-api-never-returns-table-synonyms-for-sql-server-databases   (submitted on 2010/10/20 by others)

 

Would you please give us some feedback on ...
 1) Is this the limitation in SQL Server SQLTables ODBC API to return synonyms? Based on the MSDN API manual of SQLTables()’s link is at  http://msdn.microsoft.com/en-us/library/windows/desktop/ms711831(v=vs.85).aspx

It indicates the Table_Type support Synonym table

TABLE_TYPE (ODBC 1.0)

4

Varchar

Table type name; one of the following: "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM", or a data source–specific type name. The meanings of "ALIAS" and "SYNONYM" are driver-specific.

2) Is there any workaround to have SQLTables to return synonyms? or any other replaceable API to return synonyms.
3) If this is a bug, when we can see the fix? 

 

Answer 1

Hi Elizax,

Welcome to the MSDN Forum.

This is just a quick note to let you know that I am performing research on this issue and will get back to you as soon as possible.

I appreciate your patience.

Best regards,

---

Mike Feng
MSDN Community Support | Feedback to us
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Hi,

I believe the issue is off topic in the forum here.   I would recommend you consult it in SQL Server related forums for better support.   However, we did some research and here is the information we can share.  

I checked our internal database and it's a product issue that the SQLTables function cannot get the table synonyms.  Hopefully the product team will fix it in the next major release, but we are not sure about it since the product team has their priorities. 

For the workarounds, could you use the answer in this thread? http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/d3301ddb-ba8e-4db2-ab12-66c682c4491f. 

Good day!

Thanks

 

---

Michael Sun [MSFT]
MSDN Community Support | Feedback to us