Opened 12 years ago

Closed 12 years ago

#851 closed defect (fixed)

ODBC: SQL Server table mappings wrong for non-dbo schemas.

Reported by: brentrobinson Owned by: brentrobinson
Priority: major Milestone: 3.8.0
Component: ODBC Provider Version: 3.8.0
Severity: 2 Keywords: ODBC Schema Mappings table name
Cc: External ID:

Description

Steps:

  • Using ODBC provider create an FdoIConnection to a SQL Server database that has tables in more than one feature schema.
  • Create and execute an FdoIDescribeSchemaMapping command.
  • Write the resulting schema mappings to a XML file for viewing.

The table name mappings for the non-dbo tables are not qualified by schema, meaning if these mappings are used as the configuration for the connection, these table mappings will point to the dbo schema and pick up the wrong or a non-existing table.

Change History (1)

comment:1 by brentrobinson, 12 years ago

Resolution: fixed
Status: newclosed

Revision: 6615 Author: brentrobinson Date: 3:22:01 PM, Tuesday, October 30, 2012 Message: Ticket#851: ODBC: Qualify table name mapping if table in non-default owner.


Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Lp/ClassDefinition.cpp Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Mgr.cpp Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Mgr.h Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcBaseSetup.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcDescribeSchemaTest.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoDeleteTest.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoDeleteTest.h Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoInsertTest.h Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoSelectTest.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoSelectTest.h Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoUpdateTest.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoUpdateTest.h

Note: See TracTickets for help on using tickets.