B4J Question MSSQL connection

[Anurag Jain]

Hi,

Can someone guide me on a simplest program (Desktop application on B4J) ,

1. which connects to MSSQL server and uploads data to server.
2. Additionally, It should also be able to create a user id

Have checked the literature on the blog, even though there are brilliant tutorials, it left me utterly confused.



Regards,

Anurag

 

[Erel]

Start here: https://www.b4x.com/android/forum/threads/sql-tutorial.35185/#content
And here: https://www.b4x.com/android/forum/threads/jtds-jdbc-driver-with-standalone-package.133728/#content

 

[Anurag Jain]

Thanks Erel, I have used the jdbc driver. The work is done by using only two commands, initialize and insert.

Although it took time for me, once it was done, appears to be efficient.

Ofcourse, had to add libraries properly, but I searched the community forum and got answers. This is my feedback, will keep asking more questions. I did my programming during 86 - 89, and than never needed. Had to do some work for creating an experimental setup, and I find B4x to be great.