Connection to SQL Azure with Delphi?

Question

I am failing to connect to SQL Azure using Delphi 2010 and dbGo. What is wrong and how to resolve that ?

The details:

The TADOConnection with the following connection string (the login info is changed):

Provider=SQLNCLI10.1;Integrated Security="";Persist Security Info=False;User ID=me@tyasdgerj5;Initial Catalog=Northwind;Data Source=tcp:tyasdgerj5.database.windows.net;Initial File Name="";Server SPN=""

Returns the following error text:

Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.windows.net). Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername). In addition, if both formats are used, the server names must match..

Note, that SQL Server Management Studio connects without problems.

Answer 1

Hi,

As far I know dbGo does not support SQL Azure.

The only component that support it, it's AnyDAC look at http://www.da-soft.com/forums/anydac-general-english/microsoft-sql-azure.html

Best regards