Android Question File transfer between android device and windows pc

ViMeAv ICT · Jan 9, 2023

Until now i used smb file transfer between a few android devices and a windows pc.
Herefore we need to make a small network with own wifi router.
But many times i have problems with change of ip adres, smb not installed, firewall etc.
Is there another way to transfer files where these problems don't exist?

John Naylor · Jan 9, 2023

if using a fixed IP address isn't possible then maybe consider a service such as NoIP to keep everything updated. It's cheap (free if you log in every month).

ViMeAv ICT · Jan 10, 2023

A few years ago i used Wince terminals. From these terminals I could connect with the mysql database on the local server.
Actually I'm looking for something similar for the android devices. Does this exists?

ViMeAv ICT · Jan 10, 2023

I guess I have to use JRDC2!
I will give it a try.

emexes · Jan 10, 2023

ViMeAv ICT said:
I guess I have to use JRDC2!

A heads-up: using accessing database via JRDC has some restrictions compared to accessing local database directly eg:

https://www.b4x.com/android/forum/t...able-number-of-parameters.145283/#post-921008

but as long as you're in control at the server end, then is nothing insurmountable.

ViMeAv ICT · Jan 10, 2023

How can I acces local database directly, only using mysql server port 3306, from b4a/b4x terminal?

DonManfred · Jan 10, 2023

ViMeAv ICT said:
b4a/b4x terminal?

no such thing.

You can connect to a db with

JdbcSQL - Directly connect to remote databases

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 databases. JdbcSQL - Any remote SQL database with a supported JDBC driver. MySQL and MS SQL are...

www.b4x.com

but it is not recommended to do so.

Magma · Jan 10, 2023

ViMeAv ICT said:
How can I acces local database directly, only using mysql server port 3306, from b4a/b4x terminal?

...Using jsql lib... for direct access...

ps: also may be it is better using google drive
ps2: or MQTT to avoid firewall problems... but will be a little tricky the whole thing... (i love mqtt option)
ps3: or you can have a more direct using udpsocket... but need firewall settings too..

ViMeAv ICT · Jan 10, 2023

I now use the jrdc2 example but got stuck at : java.lang.ClassNotFoundException: com.mysql.jdbc.Driver.

I changed : #AdditionalJar: jtds-1.3.1
and put the files in the library folder.

What am I doing wrong?

josejad · Jan 10, 2023

ViMeAv ICT said:
What am I doing wrong?

Not openning a new thread for this new problem

DonManfred · Jan 10, 2023

ViMeAv ICT said:
What am I doing wrong?

Not using the forumsearch first?

Search Results

www.b4x.com

ViMeAv ICT · Jan 10, 2023

Of course I first started to search, but could not find a right answer.
Now I tried again, but not finding a useable answer sofar.
But I will try a last time....

ViMeAv ICT · Jan 11, 2023

Now it seems to work, after two changes in the old tutorial files.
I had to install the mysql j connector, where the old name seems deprecated.
I also had to replace the additonal jar by the new mysql jar.
What is jtds-1.3.1?

MicroDrie · Jan 11, 2023

Google is your friend with a direct answer

Intelemarketing · Jan 16, 2023

If all you need is to transfer a file to the Windows PC, the easiest way if to get the Android app to upload the data to a Folder on a website using FTP and get the Windows PC to check the Folder frequently to see if there is anything to download (using FTP). No special IP addresses required. Updates to databases on the Windows PC do not have conflicts or too many files to handle simultaneously.

ViMeAv ICT · Jan 16, 2023

Intelemarketing said:
If all you need is to transfer a file to the Windows PC, the easiest way if to get the Android app to upload the data to a Folder on a website using FTP and get the Windows PC to check the Folder frequently to see if there is anything to download (using FTP). No special IP addresses required. Updates to databases on the Windows PC do not have conflicts or too many files to handle simultaneously.

I use this, works like a charm, when I have internet.
But in some situations there's no internet. (at all)
Therefore i have to exchange files / data between laptop and android terminal without internet.
Using smb is difficult, the people who work with this app don't know anything from pc's.
Sometimes they have a firewall of the anti-virus software etc, sometimes the network settings change.
Even sometimes smb has to put on again, etc.
So I need a bullet proof way of transferring, whatever they did with their laptop.

Intelemarketing · Jan 17, 2023

As you already know - Firewalls are oblivious to FTP, which solves one of your major problems.

I'm quite new at all the ways you can transfer data - I was oblivious to the concept of sending data without the internet.

Closest I get to that is a message sent on my phone, with or without attachments.

An early way of data transfer was to attach a files to an email and send it. This only works where files are not huge of course.
Best feature of this concept is that if the "internet" is down, then the message will be sent later when its up again.

Magma · Jan 18, 2023

Check Intel Unison

Intelemarketing · Jan 18, 2023

Magma said:
Check Intel Unison

Sounds perfect if you are in the same room as the PC

ViMeAv ICT · Jan 23, 2023

Works only from win11. Most of my machines run win10.

Android Question File transfer between android device and windows pc

Member

Active Member

Member

Member

Expert

Member

Expert

Expert

Member

Expert

Expert

Member

Member

Attachments

Well-Known Member

Active Member

Member

Active Member

Expert

Active Member

Member

Similar Threads

Privacy & Transparency

Privacy & Transparency