SDAC 6.6.12 and AZURE

[brad]

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]

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]

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.

[brad]

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