Search Results

Ok... I am trying to get B4A to connect to an in-house MSSQL server (2014) using a direct JDBC connection. However, things are a bit confusing for an outsider new to B4A and I keep getting "unknown error (14) Can't open database" in the log. This server is running other in-house... to SQL in the libraries manager. #AdditionalJar: mssql-jdbc-6.2.2.jre7.jar I declared an sql...
link: Very disappointing at the level of difficulty for something that should be fairly basic and relatively poorly documented; not everyone wants to make something cloud based with middleware when operatin...

. Disclaimer: This code with some minor changes may also work in B4A. MySQL and MSSQL connectors definitely do... (MSSQL) ---------- CustomerDemographics Region Employees Categories Customers Shippers Suppliers...
link: can you please share your northwind db, perhaps its the most up to date. Hello @Mashiane, please l...
link: Hi Peter, can you please share your northwind db, perhaps its the most up to date. Thanks. I'...
link: Hi Peter, can you please share your northwind db, perhaps its the most up to date. Thanks....

I have added #AdditionalJar:mssql-jdbc-9.4.0.jre8.jar Other Steps 1. FireWall should be opened...

/android/forum/threads/solved-using-windows-auth-to-connect-to-a-mssql-db.82346/#post-521438 for...

Ola For a while I have been exploring backend connectivity using BANano for BANanoSQL, SQLite, MSSQL and MySQL. The purpose of this lib is for a one place for all your connectivity with these backends. This library as a couple of class utilities for connecting to BANAnoSQL, SQLite, MSSQL and MySQL. SQLite, MSSQL and MySQL use PHP. BANAnoAlaSQLE - CRUD functionality for BANanoSQL BANanoMSSQLE - CRUD functionality for MSSQL (uses PHP) BANanoMySQLE - CRUD functionality for MySQL (uses PHP...

Not quite understand what changes should be made if I want to connect to a MSSQL #AdditionalJar: jtds-1.3.1 Public mysql As JdbcSQL Private driver As String = "com.mysql.jdbc.Driver" <- what to change?? Private jdbcUrl As String = "jdbc:mssql://192.168.0.6/test" Private Username As String = "username" Private Password As String = "password"...

php settings BANano.PHP_NAME = &quot;mssql.php" BANano.PHPHost = $"http...
link: be what is actual data. Dim dbsql As BANanoMSSQL dbsql.Initialize(&quot;BANanoMSSQL"...

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 = db.Query("select * from tablename") '--> return... . . . You can also write create, update or delete queries. You must copy MSSQL.jar, MSSQL...

Hello All, I have a old VB6 application that connects to a local MSSQL Server. I wanted to try to change to B4J, but i don't find any reliable way to work with MSSQL and B4J. To my knowledge the jSQL work only with MySQL, correct ? Is there any way to work with MSSQL (without those HTTP Calls and similar stuff :) ) Regards...

Hi all, Finally I have developed and put in production my first B4J web app following the instructions of the different B4J tutorials . Some features: - Use MsSQL database to report work requests daily. - Use ABMaterial framework - Login page with initial generic password. - Reset password page at first login. - Work request details page including images and GPS location to report. - Send websocket message to mobile devices (with B4A app) to notify a new request created. - Requests list...