Page 1 of 1

SDAC 6.6.12 and AZURE

Posted: Tue 12 Apr 2016 14:07
by 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.

Re: SDAC 6.6.12 and AZURE

Posted: Wed 13 Apr 2016 04:42
by 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.

Re: SDAC 6.6.12 and AZURE

Posted: Wed 13 Apr 2016 06:58
by 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.

Image

Re: SDAC 6.6.12 and AZURE

Posted: Wed 13 Apr 2016 07:37
by brad
Thanks it's been resolved. Somehow "miraculously" started working. (?!)