Options
call reference - F0008957
jdlewis
Posts: 6
Still getting this error even after downloading SQL Prompt 3.7 beta version...
Cannot retrieve database schema.
RedGate.SqlPrompt.Engine.Cache.DatabaseRefreshException ---> System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.
at _12._21(SqlConnection )
at _12._1(_11 )
at RedGate.SQLCompare.Engine.Database.RegisterForSqlPrompt(ConnectionProperties connectionProperties, Options options, Boolean includeSystemObjects)
at _181._2(IAuthenticationTokenProvider )
--- End of inner exception stack trace ---
at _181._2(IAuthenticationTokenProvider )
at _181._1(IAuthenticationTokenProvider )
at _181.GetMetaData(IAuthenticationTokenProvider provider)
at _39._2(_33 , IAuthenticationTokenProvider , Boolean , EventHandler`1 , EventHandler`1 , EventHandler`1 , EventHandler`1 )
Thanks.
Cannot retrieve database schema.
RedGate.SqlPrompt.Engine.Cache.DatabaseRefreshException ---> System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.
at _12._21(SqlConnection )
at _12._1(_11 )
at RedGate.SQLCompare.Engine.Database.RegisterForSqlPrompt(ConnectionProperties connectionProperties, Options options, Boolean includeSystemObjects)
at _181._2(IAuthenticationTokenProvider )
--- End of inner exception stack trace ---
at _181._2(IAuthenticationTokenProvider )
at _181._1(IAuthenticationTokenProvider )
at _181.GetMetaData(IAuthenticationTokenProvider provider)
at _39._2(_33 , IAuthenticationTokenProvider , Boolean , EventHandler`1 , EventHandler`1 , EventHandler`1 , EventHandler`1 )
Thanks.
Comments
many apologies for the delay in getting back to you. This is a problem in the SQL Compare Engine. It will be fixed in the next release of SQL Prompt, hopefully Q1 2008.
Thanks, Tom
Tom Harris
Red Gate Software