SQL Azure: "Database 'XXXYYY' on server '' is not currently available"

There are two reasons you can get this error when using Easysoft's SQL Azure ODBC driver to connect to SQL Azure from Linux.

• You're using Azure client redirection.

  By default, this is the case if your Linux machine is running from with the Azure cloud, that is, you have created a machine from a Linux image in Azure.

  If this is the case, please download and install version 1.10.9 or later of the SQL Azure ODBC driver. You also need to specify both the Server and ServerName attribute in your ODBC data source. For example:

  [Azure-ODBC-DSN]
  Driver=Easysoft ODBC-SQL Server SSL
  Server=myazureserver.database.windows.net
  ServerName=myazureserver
  User=myazureuser@myazureserver
  Password=myazurepassword
  Database=myazuredb
  Encrypt=Yes
  .
  .
  .

• You're using a newly provisioned database which is not publicly available yet. There may be a delay before a newly created Azure database is accessible from the outside world.

Further information

• Accessing Microsoft SQL Azure from Linux and UNIX