This issue does not occur when you use SQL Native Client or when you use the SQL Server ODBC drivers that are included in Windows XP and in Windows Server 2003.Ī supported hotfix is available from Microsoft.
This issue occurs only when you use the SQL Server ODBC drivers that are included in Windows Vista and in Windows Server 2008. However, the results should represent only the "Fran_k" table. In this scenario, the results that are returned by the function represent both the "Frank" table and the "Fran_k" table. You call the SQLTables function to query tables whose names end in "_k". One of the tables is named "Frank", and the other table is named "Fran_k".
When you call the SQLTables ODBC catalog function by specifying "%_%" as the table name search pattern, the function does not return correct results when a table name includes an underscore character (_).įor example, you have a database that contains two tables. On a computer that is running Windows Vista or Windows Server 2008, the SQLTables function of the Microsoft SQL Server ODBC drivers that are included in the operating system cannot handle the "%_%" pattern correctly. Windows Vista Business Windows Vista Business 64-bit Edition Windows Vista Enterprise Windows Vista Enterprise 64-bit Edition Windows Vista Home Basic Windows Vista Home Basic 64-bit Edition Windows Vista Home Premium Windows Vista Home Premium 64-bit Edition Windows Vista Starter Windows Vista Ultimate Windows Vista Ultimate 64-bit Edition Windows Server 2008 Datacenter Windows Server 2008 Datacenter without Hyper-V Windows Server 2008 Enterprise Windows Server 2008 Enterprise without Hyper-V Windows Server 2008 for Itanium-Based Systems Windows Server 2008 Foundation Windows Server 2008 Standard Windows Server 2008 Standard without Hyper-V Windows Server 2008 Web Edition More.