Am getting the below error while loading the data from Azure database through the ODBC Connector.
This error basically says( Windows Azure SQL Database does not support four-part names. Three-part name format ( database_name.[schema_name].object_name) is supported only when the database_name is the current database or the database_name is tempdb and the object_name starts with #.
But the strange thing is am able to pull the data from master database which is the default one.(which is also a Three-part name format)
Please let me know is there any work around for this.