SDAC Problem on Android

[fayyaz]

Hi
I download SCAD Ver. 7.0.1 Trial and also try to Develop a simple application for android.
I Try to Connect SQL Server By TMSConnection Component and fetch 3 fields of a table by TMSQuery. it work Properly in windows but when I try to Deploy and run application on android device it raise "Only Direct Mode Supported".
Is it Because of Trial Version?

Thanks

[azyk]

The "Only Direct mode is supported" error message you are getting is not a restriction of SDAC Trial Edition. The default value for the TMSConnection.Options.Provider connection property is prAuto. But for mobile applications, the Direct mode is required for TMSConnection. Therefore you are getting this message. To enable the Direct mode, before establishing connection to SQL Server, set the TMSConnection.Options.Provider property to prDirect . For example:

Code: Select all

MSConnection.Options.Provider := prDirect;

Note: to use the prDirect value, add the MSClasses unit to the uses section.

[fayyaz]

Thank you Very much for your guide

[azyk]

Feel free to contact us if you have any further questions about SDAC.