SDAC 6.6.12 and AZURE

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
brad
Posts: 3
Joined: Tue 12 Apr 2016 14:02

SDAC 6.6.12 and AZURE

Post by brad » Tue 12 Apr 2016 14:07

Can anyone tell me if SDAC 6.6.12 with Delphi 7 will work with Azure?

I can't seem to get it to connect with any of the providers even though I can connect from that machine with SSMS.

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: SDAC 6.6.12 and AZURE

Post by azyk » Wed 13 Apr 2016 04:42

SDAC 6.6.12 with Delphi 7 supports Azure SQL Database. Please specify whether you get any warning/error on an attempt to connect to this server using SDAC? If yes, please specify the full text of the error message.

brad
Posts: 3
Joined: Tue 12 Apr 2016 14:02

Re: SDAC 6.6.12 and AZURE

Post by brad » Wed 13 Apr 2016 06:58

With prNativeClient: Named Pipes Provider: Could not open a connection to SQL Server [53].
With prSQL: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

This screenshot shows SSMS open in the background and connected, with the SDAC login for prSQL and the error in the foreground.

Image

brad
Posts: 3
Joined: Tue 12 Apr 2016 14:02

Re: SDAC 6.6.12 and AZURE

Post by brad » Wed 13 Apr 2016 07:37

Thanks it's been resolved. Somehow "miraculously" started working. (?!)

Post Reply