开发者

Connection to SQL Azure with Delphi?

开发者 https://www.devze.com 2023-01-03 16:25 出处:网络
I am failing to connect to SQL Azure using Delphi 2010 and dbGo. What is wrong and how to resolve that ?

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 开发者_JAVA百科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.


As far I know dbGo does not support SQL Azure.

The only component that support it, it's AnyDAC look at this or better yet this explaining.

Best regards

0

精彩评论

暂无评论...
验证码 换一张
取 消