Opened 12 years ago
Closed 12 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 , 12 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
comment:2 by , 12 years ago
Resolution: | fixed |
---|---|
Status: | closed → reopened |
comment:3 by , 12 years ago
Resolution: | → fixed |
---|---|
Status: | reopened → closed |
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
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