Opened 14 years ago
Closed 14 years ago
#720 closed defect (fixed)
SQLServerSpatial: more friendly message needed for SQL Server 2000
| Reported by: | brentrobinson | Owned by: | brentrobinson |
|---|---|---|---|
| Priority: | major | Milestone: | 3.6.0 |
| Component: | SQLServer Spatial | Version: | 3.6.0 |
| Severity: | 3 | Keywords: | SQLServerSpatial SQL Server 2000 connect |
| Cc: | External ID: |
Description
If the SQLServerSpatial provider is used to connect to a version 8.0 (2000) instance, an exception with message indicating that sys.objects is missing is throw.
SQL Server 2000 does not have spatial handling so it's not worthwhile supporting connections to it via this provider. These connections can be done using the ODBC provider. However the error message could be made more explanatory.
Note:
See TracTickets
for help on using tickets.
Revision: 5790 Author: brentrobinson Date: 11:11:38 AM, Thursday, November 04, 2010 Message: Ticket#720: SQLServerSpatial: More friendly message when fail to connect to SQL Server 2000:
Cannot connect OSGeo.SQLServerSpatial provider to server with version older than 9.0.
Spatial handling was added to SQL Server 2008 (version 10) so denying access to version 9.0 servers was considered. However, the SQLServerSpatial provider can access these servers as long as it doesn't try to access geometries or spatial contexts. If this type of access is tried, the following exception is now thrown:
OSGeo.SQLServerSpatial provider cannot perform spatial handling on server with version older than 10.0.
Modified : /trunk/Providers/GenericRdbms/Nls/fdordbmsmsg.mc Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/Fdo/FdoRdbmsSqlServerConnection.cpp Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/Fdo/FdoRdbmsSqlServerConnection.h Modified : /trunk/Providers/GenericRdbms/Src/SQLServerSpatial/SchemaMgr/Ph/Rd/SpatialContextReader.cpp