Search Results

required for creating a connection between Android device and a remote server. In this case it is a MySQL database. A tutorial for connecting to SQL Server is available here. Android cannot connect directly to the database server (search for JdbcSQL). Therefore we need to create a simple web service... the database user to SELECT queries (in MySQL configuration). The PHP code: <?php $databasehost....b4x.com/basic4android/images/mysql_1.png PHP Script The web service is made of a single PHP script...

?dl=0 In my attached example the MariaDB Connector/J is deliberately connecting to a MySQL database, this is because the MariaDB Connector/J can connect to both MySQL and MariaDB database engines...
link: look at the attached file. These are the smallest NW databases that I have on my online server...
link: . I'll share it later for you, I'll have to rip it from my server as it maybe one that I covered......
link: Hi Peter, can you please share your northwind db, perhaps its the most up to date. Thanks....

Hi there https://www.ovipanel.in/tutorials/database/how-to-enable-remote-connection-to-a-mysql-database-on-phpmyadmin...

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...

Hi, As said in the title, I am using jdbcSQL to connect to a MySQL server ver 8.0.30 I understand... upgraded the MySQL version to 8.0.3 I am not sure whether it is impossible to connect to MySQL ver 8.0.3...
link: running I uninstalled MySql server ver 8 and went back to MySQL server ver 5. I am sure...
link: have a running mysql 8.0.25 in my dev machine, so I did some tests. I tested connecting my B4A app to...

I already read .. Erel Answer from https://www.b4x.com/android/forum/threads/jrdc-how-to-connect-to-multiple-database.59930/#content But as i'm new member to b4x and not expert in java ... modification of RDCHandler is hard for me. I do Erel answer but i can't success. This is my jRDC config.properties file #DATABASE CONFIGURATION DriverClass=com.mysql.jdbc.Driver JdbcUrl=jdbc:mysql://45.32.xxx.xx/ns_abc8?characterEncoding=utf8 #Local User=root Password=password #Java server port...

see please sub button1_click why in debug mode it can connect to remote database and in release mode it doesn't work? what's the error? com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. thanks #Region Project Attributes... As JdbcSQL Dim jsql As JdbcResultSet sql.Initialize2("com.mysql.jdbc.Driver", "jdbc:mysql://sql2.freesqldatabase.com:3306/databasename","user","password") jsql...

. A button to start the login verification process on a remote MySQL server. The username and password should be validated with records in a MySQL Table (I know that it is not a good habit to keep... the Login screen itself. The MySQL database will have a Table named 'users' with 2 columns...Hi all, I am new to B4A and this is my first thread in the forum. I am a newbie and very much new... the RDC and I have done a setup on my PC and it is working fine. So that part is clear. I have been...

I already connected an android phone via vpn at the server. The ip address of the server is 192.168.0.5 The schema name is casureco2 and i want to display the output of "select * from area" where area is one of the table of casureco2 can you provide me sample code...

to 3.2.0 2) MySQL version fron 5.7.24 to 5.7.28 Doing a simple test with JRDC2 demo, I was not able..., I discovered a small difference between this installation and all the other running: MySQL was configured...
link: Thank you ............
link: https://www.b4x.com/android/forum/threads/jrdc2-server-and-mysql-port.103450/#post-648365...
link: does JRDC2 or MySQL-Connector always expect to work with MySQL port 3306 ? no...