1. Big mistake to do it in Activity_Create. Move it to the starter service, or better switch to B4XPages.
2. Better to use JdbcSQL library.
3. Please post the full error message.
this is all that I get:
Logger connected to: samsung SM-T550
--------- beginning of main
*** Service (starter) Create ***
** Service (starter) Start **
** Activity (main) Create, isFirst = true **
** Activity (main) Resume **
** Activity (main) Pause, UserClosed = false **
** Activity (acsetup) Create, isFirst = true **
** Activity (acsetup) Resume **
** Activity (acsetup) Pause, UserClosed = true **
** Activity (main) Resume **
** Activity (main) Pause, UserClosed = false **
** Activity (acsetup) Create, isFirst = false **
** Activity (acsetup) Resume **
** Activity (acsetup) Pause, UserClosed = true **
** Activity (main) Resume **
** Activity (main) Pause, UserClosed = true **
*** Service (starter) Create ***
** Service (starter) Start **
** Activity (main) Create, isFirst = true **
** Activity (main) Resume **
(SocketException) java.net.SocketException: Socket closed
I was looking at JdbcSQL library prior to posting, does this work on all new version of Microsoft SQL?