Error running a query using linked server specified by IP address such as below results in the following error. This query works OK in other applications such as Management Studio.
Select top 1 * from [xx.x.xx.xx].users.dbo.audit --- where [xx.x.xx.xx] is the IP of the linked server
Error
System.ArgumentException
Processing of results from SQL Server failed because of an invalid multipart name "10.1.58.98.users.dbo.audit", the current limit of "4" is insufficient.
Stack Trace:
at System.Data.Common.MultipartIdentifier.ParseMultipartIdentifier(String name, String leftQuote, String rightQuote, Char separator, Int32 limit, Boolean removequotes, String property, Boolean ThrowOnEmptyMultipartName)
at System.Data.SqlClient.MultiPartTableName.ParseMultipartName()
at System.Data.SqlClient.SqlDataReader.BuildSchemaTable()
at System.Data.SqlClient.SqlDataReader.GetSchemaTable()
at Quest.Toad.Db.Connection.CreateTable(IDataReader reader, Boolean spoolData)
at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
Toad does not currently support this.
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad for SQL Server.
