Android Question Help: Additional Jar for MSSQL sqljdbc driver error

Please post code and logs as text.

You cannot use modern (I'm pretty sure post 6) versions of MSSQL drivers with Android. If jtds does not work for you, then you have to find an alternate way of accessing your database (via Middleware)

Erel said:

Please post code and logs as text.

Click to expand...

There is no code yet I'm just attaching libraries downloaded from MS website using their jbdc driver....

Thanks i will try that version first before trying middleware i have in mind...

TamersTech said:

Thanks i will try that version first before trying middleware i have in mind...

Click to expand...

Ok, this is a week sold. But, unfortantly, right now? the jDBC drivers from MS simply don't work. And going to Azure would make this even more difficult.

I'm not convinced that even the jtds one would work. (but I not attempted). Without a web service? Hitting that server direct - this will be not be a robust setup.
As you noted, some thing in the middle would be a way to go - even perhaps run a jdbc server that then connects to Azure would/could be a possible road. This also of course would allow you to have a fixed IP address (a often choice for security with Azure).

However, as FYI - not aware that anyone been able to get their jDBC drivers to work on Android - the jtds one does however work, but I never attempted to use them against SQL running on Azure.
R
Albert

Actually connecting directly to sql azure is a robust solution, security is programmers responsibility. Anyways I have successfully made a middleware base on the forums using JRDC2 middleware, i customized it to a dynamic one ( means you will not compile again the system if you have changes in he connection and sql querry part). Screenshot Attach.

If anyone needs it i will be happy to share it. Maybe ill post it the forum so others like me whos searching for it can have it.

TamersTech said:

Actually connecting directly to sql azure is a robust solution, security is programmers responsibility. Anyways I have successfully made a middleware base on the forums using JRDC2 middleware, i customized it to a dynamic one ( means you will not compile again the system if you have changes in he connection and sql querry part). Screenshot Attach.

If anyone needs it i will be happy to share it. Maybe ill post it the forum so others like me whos searching for it can have it.

Click to expand...

If you telling me that you have the Microsoft jdbc driver working without a middle server or service running, and are able to do a jdbc direct connection to SQL server using the Microsoft jdbc driver as opposed to using the jtds one? yes, that is news!

Regards,
Albert D. Kallal
Edmonton, Alberta Canada