- The microsoft driver is not working for Android.
So, if you want to implement security to encrypt the sending of information, the only solution I have discovered is to use the HTTPS protocol like this
RDC is a middleware server that makes it simple to safely connect clients and remote SQL database servers. jRDC2 is the latest version. All new projects should use this version. jRDC2 is made of two components: - B4J server. The server receives the requests from the clients, issues the SQL...
www.b4x.com
or create a webservice and use this webservice in your app.
There may be a workaround. Looks like there is an issue in the code of the official release. Someone in the jTDS forums produced a patch and another user posted the patched version of the driver on the forum. You would have to take the risk on using the patched version (since it was user supplied and is not from the official repository of jTDS).
One more time.
someone know any thenic, proyect or metoth to connect to SQL SERVER with SSL.
i read something and doit testint with a patch in jdbc 1.3.1 but in Android not work.
I don't know if it really worked for someone on Android, or when they say it worked for them they meant JAVA. I have tried the latest drive from microsoft, but as expected, it still doesn't work. It doesn't even compile. I am surprised that at this technological stage, this option does not exist, but I think it will be what it is. The WEBService forces me to rethink my entire project, which will generate a lot of work for me, so I continue with this option. Ideas welcome
That's to be expected. Android's Java implementation is from the 1.7 era. All the newer JDBC drivers are based on 1.8 and above. Plus, they (the drivers) target desktops, not mobile devices. It just happens that for awhile, JDBC drivers were able to be used with Android. And you still can, as long as you stick with older JDBC drivers. Even MySQL's newest drivers do not work on Android. It is not the fault of the JDBC authors. It's not the fault of Java. It's not even the fault of Android, since Android is not a Desktop OS replacement.
Please note that in the B4i environment, there are zero direct database connection drivers available. So just for cross platform reasons, using JDBC drivers is not the best solution for accessing databases. On the other hand, if you can live with the limitations of using JDBC, it can be a solution for your problem (as it is for @MrKim)
One more time.
someone know any project or method to connect to SQL SERVER with SSL.
i read something -- with a patch in jdbc 1.3.1 but in Android not work.
for a direct connection to sql server? Nope - no working solution I know of. Now to be fair, a direct connection to sql server is of limited value, and tends to not be such a good idea. So hitting a web service of course the most common approach and suggestion. And you can use a "bridge"
The only really nice advantage of the direct connection? Well, you don't need a web server or any server of any kind (so setup time - really nice!!!).
However, I will say that in one case, yes - I am hitting sql server direct. And I am using a VPN to do this. However the the encryption and network connection is already secured at the network level via the VPN - so I don't need nor care if I can't and am not using SSL to sql server, since the network connection is already secured.
But at this time? No, the Microsoft drivers don't work, and the jdbc one does not work with SSL .
R
Albert