VERIFIED SOLUTION i

Confirm - map error in V15 opening SQL spatial map layer : Unable to open table.: ODBC Error: ODBC RC=-1, ODBC SQLState=37000 DBMS RC=4060, DBMS Msg=[Microsoft][ODBC SQL Server Driver] [SQL Server]Cannot open database "xxxxxxx" requested by the login. T

Product Feature: Mapping Issue


 

Issue

Client encounters "Unable to open table.: ODBC Error: ODBC RC=-1, ODBC SQLState=37000
DBMS RC=4060, DBMS Msg=[Microsoft][ODBC SQL Server Driver] [SQL
Server]Cannot open database "xxxxxxx" requested by the login. The
 login failed.." when opening a SQL Spatial map layer in V15, where xxxxxis the database name.

This occurred when the client migrated their database from one server to another.

Cause

The problem is that when the Use Confirm Database Map Layer is ticked it creates a connection string in the background using the server that it is on currently. If the datbase is then moved, this connection string is now incorrect and will not be able to find the new location for the map schema.


 

Resolution

UPDATED: April 12, 2019
Untick the 'Use Confirm Database Map Layer' tickbox on the Feature group screen and use the 'Do not use the Confirm Database Map Layer' option.

Migrate the server onto the new location, then go back to the feature group and re-select the 'Use Confirm Database Map Layer' option. This will recreate the connection string to the current server.