Android Question MSSQL library for direct connection to SQL Server does not work b4a 13 64bit (Resolved)!

[Andre Pagliuso]

Good afternoon everyone. My apps made with a previous version of B4A are no longer running on Android 14, after I updated my B4a to version 13, only the MSSQL library is no longer running, it is not even detected in the project. Has anyone been through this? Is there an updated MSSQL library that I can use without having to change the projects, or if this solution is not available, can anyone recommend another library that makes this direct connection to SQL Server so that I can use it without having to make profound changes to the project? from my app.

Thank you for your attention.

 

[Erel]

I don't see anything in B4A v13 that can cause it. Something else changed.

 

[aeric]

Good afternoon everyone. My apps made with a previous version of B4A are no longer running on Android 14, after I updated my B4a to version 13, only the MSSQL library is no longer running, it is not even detected in the project. Has anyone been through this? Is there an updated MSSQL library that I can use without having to change the projects, or if this solution is not available, can anyone recommend another library that makes this direct connection to SQL Server so that I can use it without having to make profound changes to the project? from my app.

Thank you for your attention.

It is always useful if what you mean by no longer running is accompanying by an error message.

 

[Andre Pagliuso]

Only when I open the project does a warning appear indicating that the MSSQL library is missing, but it doesn't even detect it in the list so I can select it. The attached images show the MSSQL library in version 11, while in the other images the message appears that the MSSQL library is missing, the folder where the library is launched and the list of version 13 libraries where MSSQL does not appear.

 

[aeric]

Do you mean the following library? I don't think it is an internal library. You should put the required files inside additional libraries folder.

MSSQL with JDBC Library v1.00

Hello everyone, This is my first library. There are only three functions. Dim db As MSSQL Dim L As List db = setDatabase("Server IPNUMBER (not name)","databasename","username","password") Try 'select query L =...

www.b4x.com

 

[Andre Pagliuso]

thanks for the feedback. I inserted the libraries in the folder and it recognized the MSSQL 1.0 library but now when I compile it it returns the error below:


=======================================================

B4A Version: 13.00
Parsing code. (0.07s)
Java Version: 19
Building folders structure. (0.16s)
Compiling code. (0.14s)
Compiling layouts code. (0.02s)
Organizing libraries. (0.04s)
(AndroidX SDK)
Compiling resources (1.27s)
Linking resources (0.30s)
build tools: 34.0.0, android jar: android-34
Compiling debugger engine code. (2.18s)
Compiling generated Java code. (3.50s)
Finding libraries that need to be dexed. (0.01s)
Dex code (6.34s)
Dex merge Error
Error in C:\Android\tools\..\extras\b4a_local\unpacked-mssql-63861489478209\dex_v1\mssql.zip:classes.dex:
Type com.tomlost.MSSQL.MSSQL is defined multiple times: C:\Android\tools\..\extras\b4a_local\unpacked-mssql-63861489478209\dex_v1\mssql.zip:classes.dex, D:\D_Backup\AndroidProjetos\VSoftPDroid\Objects\dexed\com\tomlost\MSSQL\MSSQL.dex
Compilation failed
Exception in thread "main" java.lang.RuntimeException: com.android.tools.r8.CompilationFailedException: Compilation failed to complete, origin: C:\Android\tools\..\extras\b4a_local\unpacked-mssql-63861489478209\dex_v1\mssql.zip:classes.dex
at com.android.tools.r8.internal.po.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:1269)
at com.android.tools.r8.D8.main(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:5)
Caused by: com.android.tools.r8.CompilationFailedException: Compilation failed to complete, origin: C:\Android\tools\..\extras\b4a_local\unpacked-mssql-63861489478209\dex_v1\mssql.zip:classes.dex
at Version.fakeStackEntry(Version_8.3.37.java:0)
at com.android.tools.r8.Q.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:5)
at com.android.tools.r8.internal.po.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:244)
at com.android.tools.r8.internal.po.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:90)
at com.android.tools.r8.internal.po.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:909)
at com.android.tools.r8.internal.po.b(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:99)
at com.android.tools.r8.D8.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:1041)
at com.android.tools.r8.D8.b(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:514)
at com.android.tools.r8.D8.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:1076)
at com.android.tools.r8.internal.po.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:1256)
... 1 more
Caused by: com.android.tools.r8.internal.h: Type com.tomlost.MSSQL.MSSQL is defined multiple times: C:\Android\tools\..\extras\b4a_local\unpacked-mssql-63861489478209\dex_v1\mssql.zip:classes.dex, D:\D_Backup\AndroidProjetos\VSoftPDroid\Objects\dexed\com\tomlost\MSSQL\MSSQL.dex
at com.android.tools.r8.internal.X30.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:346)
at com.android.tools.r8.internal.pX.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:232)
at com.android.tools.r8.internal.pX.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:91)
at java.base/java.util.concurrent.ConcurrentHashMap.merge(ConcurrentHashMap.java:2056)
at com.android.tools.r8.internal.pX.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:32)
at com.android.tools.r8.graph.q4$a.d(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:6)
at com.android.tools.r8.dex.c.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:264)
at com.android.tools.r8.dex.c.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:222)
at com.android.tools.r8.dex.c.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:219)
at com.android.tools.r8.D8.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:809)
at com.android.tools.r8.D8.d(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:212)
at com.android.tools.r8.D8.c(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:163)
at com.android.tools.r8.internal.po.a(R8_8.3.37_d0b8d9dfe8720e37c27d2233931d9d72dbd696ffd92111cc9b36e58b4baad1cc:906)
... 6 more

 

[Andre Pagliuso]

Finally I found the problem. At the beginning of the project in Main() I added

#ExcludedLib: MSSQL.jar

Here's a tip!