Android Question How can I use a Sybase 16/17 SQL-Database with B4A

[sirolav]

Hello.
it is possible to connect an application in b4a with sqlanywhere 16/17 database.
If possible, I would like some examples. I can't find examples and help.
Thanks in advance

 

[roerGarcia]

You can try jrdc, needs the SQL Anywhere JDBC
JRDC - Search in the forum about it.

RDC is a middleware server that makes it simple to safely connect clients and remote SQL database servers.

jRDC2 is the latest version. All new projects should use this version.

jRDC2 is made of two components:

- B4J server. The server receives the requests from the clients, issues the SQL commands against the database and returns the results.
In many cases the server will be hosted on the same computer that hosts the database server.
- Client module. The client which is compatible with B4A, B4J and B4i is responsible for sending the requests and handling the responses.

jRDC2 can work with any database that provides a JDBC driver. All popular databases are supported.
It is much more powerful than the PHP based solution and it has excellent performance.
It is also safer as the SQL commands are set in the server side.

[B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)

RDC is a middleware server that makes it simple to safely connect clients and remote SQL database servers. jRDC2 is the latest version. All new projects should use this version. jRDC2 is made of two components: - B4J server. The server receives the requests from the clients, issues the SQL...

www.b4x.com

 

[thinktank]

How can I use a Sybase 15.7 SQL-Database with B4A

How can I use a Sybase 15.7 SQL-Database with B4A Best Regards Jürgen

www.b4x.com

 

[sirolav]

Hello.
it is possible to connect an application in b4a with sqlanywhere 16/17 database.
If possible, I would like some examples. I can't find examples and help.
Thanks in advance. Can you send example of jdbc string connection with sqlanywhere with connect with pc odbc name ?

 

[roerGarcia]

Do yo see the post #3 here?

 

[Bladimir Silva Toro]

Hello @sirolav

I think it is possible to connect to this database.

It is possible to connect with jTDS according to what I have read in various forums.

Follow my example where I connect to SQL Server and switch to your database. Link: https://www.b4x.com/android/forum/t...-android-to-ms-sql-server-using-jrdc2.114856/

Check your connection string and test.

Remember that we can always help you.