Connect Android to Pervasive database remotely

0
votes

I hope this doesn't come off as rhetorical, but I've been googling in circles and can't find quite what I'm looking for.

I'm very new to Android development and this is probably a lofty goal, but I'm looking to create an app that can connect to the Pervasive database on my file server remotely (not while on the same local network, but from anywhere).

So far, all I can find are answers saying to use MySQL, but the database is not hosted on a web server. I'm not looking for some one to write code for me, I just need resources.

Is this even possible / advisable?

Are there any posts / articles I should read?

Are there any libraries that I'll need?

1
androidpervasive

1 Answers

0
votes

It is possible. Is it advisable, that depends. To access Pervasive PSQL over the network, port 1583 needs to be open. This is the SQL port. You need port 3351 for Btrieve.
From Android, you can use the Pervasive JDBC driver.