Opened 11 years ago

Closed 11 years ago

#853 closed defect (fixed)

ODBC: No identity for SQL Server classes not in dbo

Reported by: brentrobinson Owned by: brentrobinson
Priority: major Milestone: 3.8.0
Component: FDO API Version: 3.8.0
Severity: 2 Keywords: ODBC SQL Server identity non-dbo
Cc: External ID:

Description

Steps:

  • Create a SQLServer database.
  • Add another schema in addition to dbo
  • add a table to the new schema, and add some columns and a primary key column.
  • Create an ODBC DSN for the SQL Server database
  • Create an Fdo ODBC Provider connection to the DSN.
  • Perform an FdoIDescribeschema.

The class for the table has no identity properties. They should be generated from the primary key.

Change History (3)

comment:1 by brentrobinson, 11 years ago

Resolution: fixed
Status: newclosed

Revision: 6632 Author: brentrobinson Date: 3:43:39 PM, Tuesday, November 13, 2012 Message: Ticket#853: ODBC: Add owner to SQLPrimaryKeysW call so that primary keys, for tables not in dbo, can be retrieved.

Also fixed a memory corruption in PhysicalElementMappingCollection.h


Modified : /trunk/Fdo/Unmanaged/Inc/Fdo/Commands/Schema/PhysicalElementMappingCollection.h Modified : /trunk/Providers/GenericRdbms/Src/ODBCDriver/pkeys_.c

comment:2 by brentrobinson, 11 years ago

Resolution: fixed
Status: closedreopened

comment:3 by brentrobinson, 11 years ago

Resolution: fixed
Status: reopenedclosed

Revision: 6761 Author: brentrobinson Date: 11:33:00 AM, Tuesday, January 29, 2013 Message: Ticket#853: ODBC: handle SQL Server databases that have a schema called "Fdo".


Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Lp/Schema.cpp Modified : /trunk/Providers/GenericRdbms/Src/ODBC/SchemaMgr/Ph/Mgr.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcBaseSetup.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcConnectionUtil.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcDescribeSchemaTest.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoSelectTest.cpp

Note: See TracTickets for help on using tickets.