Error connecting to SQL Azure from IOS/Android

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
WestyOz
Posts: 18
Joined: Tue 23 Jun 2015 06:18

Error connecting to SQL Azure from IOS/Android

Post by WestyOz » Tue 23 Jun 2015 20:00

I am using v7.1.4 (licensed) of the SDAC components on Delphi XE8, and have developed a mobile FMX application that uses a direct connection to SQL Azure instance. This works when compiled and executed as Windows (32bit), but when deployed to both IOS & Android devices the following error is encountered:

TTDSMemoryStream.SetPosition 0, FLength -8 (D:\Projects\Delphi\Dac\SqlServer\Source\TdsNet.pas, line 185)

An earlier post in your forums (Feb 2015) referenced that support for SQL Azure will be forthcoming in a future version of SDAC. Is this nearing release? If so do you have an ETA.

In my opinion the SDAC technology is excellent and works quite well removing middle-tier layers & overhead in order to have a data aware mobile application, so to be able to support the mobile spectrum with SQL Azure seems essential.

Any advice would be appreciated.

Thanks.

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

Re: Error connecting to SQL Azure from IOS/Android

Post by azyk » Thu 25 Jun 2015 09:39

Currently, we are working on implementation for SDAC Direct Mode for Azure SQL Database. We are going to include it in the next SDAC version. The new version will be released within the summer. You can also follow the SDAC news at http://www.devart.com/news .

Thank you for your feedback. We highly appreciate your opinion to our products. We are trying to improve our products and make them multi-functional.

WestyOz
Posts: 18
Joined: Tue 23 Jun 2015 06:18

Re: Error connecting to SQL Azure from IOS/Android

Post by WestyOz » Thu 25 Jun 2015 20:50

Thank you for the update azyk, l am looking forward to the next version at that rate.

While it is possible to utilize an Azure mobile service and extract data via Restful Web services (which I may have to use in the short term), because the apps I develop also need to connect to on-premise SQL servers it is preferable to have a uniform mode of data access across all possible endpoints. The SDAC provides this mechanism.

WestyOz
Posts: 18
Joined: Tue 23 Jun 2015 06:18

Re: Error connecting to SQL Azure from IOS/Android

Post by WestyOz » Wed 08 Jul 2015 05:44

I note v7.1.5 has been released, but is it 7.2.x (major release) we should be expecting this update in? Have tested on Android using v7.1.5 and receive a socket error. Unable to test on IOS at the moment.
Last edited by WestyOz on Wed 08 Jul 2015 05:47, edited 1 time in total.

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

Re: Error connecting to SQL Azure from IOS/Android

Post by azyk » Thu 09 Jul 2015 13:07

Support for Direct Mode for Azure SQL Database wasn't added to the SDAC build 7.1.5. We can't yet name the SDAC version, which will include it. However, this will be mentioned in SDAC History at: https://www.devart.com/sdac/revision_history.html .

WestyOz
Posts: 18
Joined: Tue 23 Jun 2015 06:18

Re: Error connecting to SQL Azure from IOS/Android

Post by WestyOz » Thu 09 Jul 2015 21:03

Understood. Thanks, will keep an eye on the revision notes.

ADILSONREIS
Posts: 1
Joined: Tue 14 Jul 2015 20:03

Re: Error connecting to SQL Azure from IOS/Android

Post by ADILSONREIS » Tue 14 Jul 2015 20:05

Hello I need to use the component to access the SQL Azure. I've got the same error. Someone has already solved this problem?

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

Re: Error connecting to SQL Azure from IOS/Android

Post by azyk » Wed 15 Jul 2015 08:58

You are getting this error, because support for Direct Mode for Azure SQL Database is yet under development. As soon as this feature is implemented and included into the SDAC release, we will mention it in the History: https://www.devart.com/sdac/revision_history.html.

WestyOz
Posts: 18
Joined: Tue 23 Jun 2015 06:18

Re: Error connecting to SQL Azure from IOS/Android

Post by WestyOz » Fri 12 Feb 2016 04:19

Is this functionality still on the development roadmap? If so is there an eta for it?

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

Re: Error connecting to SQL Azure from IOS/Android

Post by azyk » Fri 12 Feb 2016 09:10

We are going to release a new version of SDAC with support for Azure SQL Database for MacOS, iOS, Android within a month.

WestyOz
Posts: 18
Joined: Tue 23 Jun 2015 06:18

Re: Error connecting to SQL Azure from IOS/Android

Post by WestyOz » Sat 13 Feb 2016 00:27

Thanks for the update azyk - much appreciated.

Looking forward to that development.

WestyOz
Posts: 18
Joined: Tue 23 Jun 2015 06:18

Re: Error connecting to SQL Azure from IOS/Android

Post by WestyOz » Fri 18 Mar 2016 00:06

Just a friendly nudge - is there an impending ETA ?

Really keen for this.

thanks.

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

Re: Error connecting to SQL Azure from IOS/Android

Post by azyk » Fri 18 Mar 2016 09:42

We have already implemented support for Azure SQL Database for MacOS, iOS, Android. And we included it in the next version of SDAC/UniDAC. The new version will be released within a month.

If you want to test SDAC/UniDAC for Azure SQL Database (MacOS, iOS, Android) before the official release, write to andreyz*devart*com - and we will send you a night build.

WestyOz
Posts: 18
Joined: Tue 23 Jun 2015 06:18

Re: Error connecting to SQL Azure from IOS/Android

Post by WestyOz » Fri 29 Apr 2016 01:06

I note the next release is now available - but the SQL Azure fix isn't specifically mentioned in the release notes. Is this included? I was going to upgrade Delphi to 10.1 (Berlin) but before doing so am keen to know if this was included before pulling the trigger.

thanks,
WestyOz

ViktorV
Devart Team
Posts: 2299
Joined: Wed 30 Jul 2014 07:16

Re: Error connecting to SQL Azure from IOS/Android

Post by ViktorV » Wed 04 May 2016 13:26

Thank you for your interest in our products. Yes, the latest version of SDAC 7.3.12 supports Azure SQL Database for MacOS, iOS, Android.

Post Reply