Opened 14 years ago
Closed 14 years ago
#721 closed defect (fixed)
SQLServerSpatial: cannot access database with all numbers in name
| Reported by: | brentrobinson | Owned by: | brentrobinson |
|---|---|---|---|
| Priority: | major | Milestone: | 3.6.0 |
| Component: | SQLServer Spatial | Version: | 3.6.0 |
| Severity: | 2 | Keywords: | SQL Server 2008 database name special character |
| Cc: | External ID: |
Description ¶
If SQL Server 2008 database has a name that is all numeric (e.g. "123") or contains embedded spaces then the SQL Server Provider cannot access it. If the database is opened then feature commands executed against it fail with syntax error near "123." messages.
Change History (2)
comment:1 by , 14 years ago
| Component: | FDO API → SQLServer Spatial |
|---|
comment:2 by , 14 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
Revision: 5808 Author: brentrobinson Date: 1:29:58 PM, Friday, November 12, 2010 Message: Ticket#721: SQLServerSpatial: double quote delimit database names in any SQL statements.
Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Rd/BaseObjectReader.cpp Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Rd/ColumnReader.cpp Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Rd/ConstraintReader.cpp Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Rd/DbObjectReader.cpp Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Rd/DbSchemaReader.cpp Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Rd/FkeyReader.cpp Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Rd/IndexReader.cpp Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Rd/OwnerReader.cpp Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Rd/PkeyReader.cpp Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Rd/SpatialContextReader.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/MySql/MySqlConnectionUtil.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/MySql/MySqlFdoForeignSchemaTest.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/MySql/MySqlFdoUpdateTest.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/PostGis/PostGisConnectionUtil.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/PostGis/PostGisFdoUpdateTest.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/SQLServerSpatial/SqlServerConnectionUtil.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/SQLServerSpatial/SqlServerFdoApplySchemaTest.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/SQLServerSpatial/SqlServerFdoForeignSchemaTest.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/SQLServerSpatial/SqlServerFdoUpdateTest.cpp Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Mgr.h Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/DbElement.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Mgr.cpp