Opened 17 years ago
Closed 17 years ago
#76 closed defect (fixed)
ODBC: SQL Server 2005 system views appearing in schema description
| Reported by: | anonymous | Owned by: | anonymous |
|---|---|---|---|
| Priority: | major | Milestone: | 3.3.0 |
| Component: | ODBC Provider | Version: | 3.2.0 |
| Severity: | 2 | Keywords: | |
| Cc: | External ID: |
Description
A recent change allowed views can be seen from a DescribeSchema command in the ODBC Provider. In most data sources, this is fine. However, with SQL Server 2005, dozens of system views are new visible. These add clutter to the visible results and can be a performance problem. MapGuide has even been observed to time out on a DescribeSchema.
The problem does not occur with SQL Server 2000 because that version does not offer system schemas in the results of the ODBC "SQLTables" function. With SQL Server 2005, this function returns results including the "sys" and "INFORMATION_SCHEMA" schemas, which contain the offending views.
Change History (2)
comment:1 by , 17 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
comment:2 by , 17 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
Note:
See TracTickets
for help on using tickets.
A fix has been applied. This is a stop-gap solution. It just skips "sys" and "INFORMATION_SCHEMA" when retrieving schemas from SQL Server. The issue may be revisited in the future to use either "sysobjects" or "INFORMATION_SCHEMA" to allow an expert user to gain access to the suppressed schemas.
Revision: 2757 Author: gavincramer Date: 1:52:34 PM, Tuesday, May 29, 2007 Message: Ticket #76 ODBC: SQL Server 2005 system views appearing in schema description
Modified : /trunk/Providers/GenericRdbms/Src/ODBCDriver/users_.c Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcDescribeSchemaTest.cpp
Revision: 818 Author: gavincramer Date: 1:18:50 PM, Tuesday, May 29, 2007 Message: Ticket #76 ODBC: SQL Server 2005 system views appearing in schema description
Modified : /branches/3.2.x/Providers/GenericRdbms/Src/ODBCDriver/users_.c Modified : /branches/3.2.x/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcDescribeSchemaTest.cpp