SQL Server - Resource Temporarily Unavaiable

[fernando.xpoint]

Hi,

I'm trying to do a simple query directly to a online SQLServer database hosted in Azure using UniConnection and UniQuery with a mobile app:

query.Close;
query.SQL.Text := 'select [field] from [table]';
query.Open;

But the follow exception rises: 'Error on data reading from the connection: Resource temporarily unavailable. Socket Error Code: 35($23)'.

Connection configuration:
Provider: SQL Server.
ipVersion: ivIPBoth.
ConnectString: Provider Name=SQL Server;Data Source=[my_db].database.windows.net;Initial Catalog=[my_db];Port=0;User ID=[user];Password=[password];IP Version=ivIPBoth;Login Prompt=False;Pooling=True;Validate Connection=True;

Here in Brazil the app is working perfectly with all resources (select, update, delete, drop etc), but in Apple Store test (when the app subimted is waiting for approval) this simple query is rising the exception above.

What this could be? Is there some missing configuration?

Thanks!

[azyk]

The specified issue is not related to UniDAC functionality. Please forward your question to Apple Store support.

[ziclope]

I have the same problem, how can I resolve it ?

[azyk]

Please specify whether this error is reproduced when the property TUniConnection.SpecificOptions.Values['SQL Server.IPVersion'] is assigned the value:
- ivIPv4
- ivIPv6
- ivIPBoth

[ziclope]

TUniConnection.SpecificOptions.Values['SQL Server.IPVersion'] = ivIPv4

this is the default value, I have no changed it

[azyk]

The described problem may occur if on the client machine where the application is running there is no access to SQL Azure through IPV4 protocol. Trace the path from the client to SQL Azure to find out at which route point the access is absent.

[ziclope]

Can I change to ivBoth on SQL Azure ?

[ziclope]

My actual connection string is

Provider Name=SQL Server;Provider=TDS;Data Source=XXXXXX.database.windows.net;Initial Catalog=DATAS;User ID=demos;Password=demos;MultipleActiveResultSets=True;Login Prompt=False

[ziclope]

Apple review team Still rejected my app.

I have try multiple compilations:

- With Encrypt='True' and Encrypt='False'
- Using ipV6 and ipV4

I have created a NAT64 wifi with macs for try simulating IPV6 and app works in my test. Buy rejected when submited.

Any solutions ? Any idea ?

[azyk]

The described problem may occur if at least on one of the route points from a computer/mobile device where the app is running to SQL Azure there is no access to IPV4 protocol. To check the access, use the traceroute command on the computer/mobile device where this problem occurs.

[ziclope]

SQL Azure require at least one route point in IPv4 ?
SQL Azure does not allow connections from ipv6 real networks ?

I don´t know bypass it

[azyk]

UniDAC supports connection to SQL Azure using both protocols - IPv4 and IPv6.

To check if client region is available for SQL Azure through IPv4/IPv6 protocol, please read the following article in Azure documentation: https://azure.microsoft.com/en-us/updat ... azure-vms/ or forward these questions to its developers.

[ziclope]

I think that devart should be create a demo app over ios and mac
connecting to SQL Azure, and try publish to apple store.

Because I wasted a lot of time, 1 week, without solution.

[azyk]

The error message 'Resource temporarily unavailable' is generated not by UniDAC, but by OS. To solve the problem you should find this error cause. Clarify at the Apple Store whether there is access to SQL Azure from the computer/mobile device where this error occurs.