Search Results

database and tables in MySQL server. jAPI.zip - Source code for server app (B4J). B4A.zip - Source code... Updates: Latest B4XPages user login client apps (using B4J server): https://www.b4x.com/android...
link: Is it worth remaking this old project (server) using Web API Server Template 2 and convert...
link: Web API server backend. MySQL database is not yet tested. The client has been tested for B4A and...
link: API server backend. MySQL database is not yet tested. The client has been tested for B4A and...

is a follow up to the previous tutorial that explained how to connect to a MySQL database using a PHP web service. This time we will use an ASP.NET web service to connect to a Microsoft SQL Server. Android cannot directly connect to the database server. Instead we will use HttpUtils to connect to a simple... that handles any query and passes it directly to the server. You can of course modify it and make... %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ Import Namespace...

at "Apache" and MySql. Both servers should start now without any problems. Take care that both can communicate via your firwall. Congrats. Now you have a working Web- and MySql Server. Next step is to...Update: Newer releases of XAMPP come with MariaDB except of MySQL. Basically the same but the php... that holds the connection) has to be added to every sql statement "mysqli_query($con..." installation package to have an own webserver including php and MySql 2. create a database and...

Hi Here is a tutorial that shows the steps of how to make an Android connection to MS SQL Server using jRDC2. Download tutorial here: 1UEVTNelsTChMe1diehmOyHghHTi-qr_L Attached the Mobile Project...
link: (or another server side languaje) or JdbcSQL...
link: I tried a lot but I can't get it. I want to connect in b4a. I have OviPanel. In that I have to c...
link: This is a very old thread and topic. I think you better start a new thread/question series....

Updates jRDC2 Server v2 is available jRDC2 Server Template Version: 1.12 (based on jRDC2 version 2.23) Create a new project and run it! To be accompanied with jRDC2 Client Template Introduction: To be edited 147014 Version 1.00 : 9KB Version 1.11 : 127KB Version 1.12 : 127KB Version 2.00 (beta) : 127KB Note: If you think the latest version is big, you can use version 1.00 otherwise you can remove the images inside www/img or use smaller size images....

It requires jDateUtils library Sub GetDatetimeValueSqlServerFromUnixDatetime(dt As Long) As Double Dim p As Period = DateUtils.PeriodBetweenInDays(DateTime.DateTimeParse("1/1/1900", "0:0:0"), dt) Return p.Days + ((p.Hours * 3600 + p.Minutes * 60 + p.Seconds)/(3600*24)) End Sub Sub GetDatetimeValueUnixFromSqlServerDatetime(days As Double) As Long Dim p As Period p.Initialize p.Days = Floor(days) p.Seconds = Floor((days - p.Days) * (3600*24...

Thought I would share this. Sometimes it is just easier to go SQL direct rather than a jrdc server... LOCAL networks and works both wired and wireless. Below is an SQL Server Function that will return...
link: that)... actually i wanted to share Erel's way (if someone don't want sql server) and then my mouth/hands...
link: - you need also run your webserver (jserver) - it is also great if you don't want sql server: https...

the PORT I am using through the firewall. I AM ABLE TO SUCCESSFULLY CONNECT TO AN SQL SERVER... ON THE SUBJECT. IF YOU CANNOT GET IT TO WORK THEN MORE THAN LIKELY YOUR ISSUE IS FIREWALL/DOMAIN/SQL SERVER.... I have connected to SQL server versions 2008 - 2014 successfully. IF you want to connect to any other DB other than MS SQL Server then I cannot help you. If your SQL Server is on anything other than... SELECT &#39;SQL Server and Windows Authentication Mode'. I HAVE NEVER TRIED WINDOWS AUTHENTICATION!...

it is supported: https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver16 I have Microsoft JDBC driver 12.2.0 and also the latest 12.8...
link: Thank you all. I figured out what was wrong. The sConnectionString is being returned from a sub. I ...
link: =TrialDB;encrypt=false;trustServerCertificate=true;user=${""};password=${""}"$ Dim...
link: I have some small experience trying to connect SQL SERVER 2022 via ODBC and I remember that I could...

an instance of the MySQL Flex Server. This is used for secure connections and can be used for your...Ola Curious, so Im testing if I can deploy an app that will use Microsoft Azure MySQL. Things to... (mysqli_connect_errno()) { die('Failed to connect to MySQL: '.mysqli_connect_error()); } or...}"); If you happen to have an idea of how we can connect via b4j using the jSQL library, please impress us. ;) So far MySQL wokbench has been able to access this back-end. Will continue testing...