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 that will pass the requests to the database and will return the response. For this example... the database user to SELECT queries (in MySQL configuration). The PHP code: <?php $databasehost...

This is a port of B4J jSQL library. The SQL type was renamed to JdbcSQL and ResultSet was renamed to JdbcResultSet, this allows using it together with the SQL library. SQL library - local SQLite... are supported. Others are also supported. The recommended method to connect to remote databases is jRDC2: https://www.b4x.com/android/forum/threads/61801/#content Connecting to the database directly has... mobile usage. - Reliability issues due to unstable connectivity. I don't recommend using it in...

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... void Page_Load(object sender, EventArgs ec) { using (SqlConnection cn = new SqlConnection...(); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection...

as it should have fewer problems connection to an SQL DB from a Windows machine connected with a wire... containing the instance of SQL. For example on my laptop I am able to connect without a problem using...
link: https://www.b4x.com/search?query=JdbcSQL+library...
link: 94073 Hi MrKim, i dont have JdbcSQL library. how to add JdbcSQL library?...
link: I am aware there are security issues. All of our customers are small shops. Setting up and configuri...

?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...:-UseGCOverheadLimit Waiting for debugger to connect... Program started. ---------- Northwind Database (MySQL...Hello fellow B4X'ers, Here is some example code for connecting your B4J projects to 5 different... Connector/J I decided to add Oracle Connector/J to the attached file named Database5ConnectionTypes...

it is supported: https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server... suitable driver found for at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:702...
link: Thank you all. I figured out what was wrong. The sConnectionString is being returned from a sub...
link: ) Dim sConnectionString As String = $"jdbc:sqlserver://127.0.0.1:1433;databaseName...
link: I have some small experience trying to connect SQL SERVER 2022 via ODBC and I remember that I could...

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 in B4A and the JRDC2 Project in B4J Any questions please ask in the forum Bladimir Silva Toro Teacher programming software...

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

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

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