Java and SQL Data Base

[judy]

We are running Pastel Evolution at work and the Package is not 100
% doing what it is suppose to be.
PASTEL uses a SQL Database and we are running it on a Server.

Can I via a Java Program access the Tables in the SQL Database ?
How?

Fyi
Judy

[tfit]

Yes, but the java database connector was (is?) not installed by default. It depends on which databaseserver and which type of connection you're using. ODBC will always work.

[peter_budo]

Yes, but the java database connector was (is?) not installed by default. It depends on which databaseserver and which type of connection you're using. ODBC will always work.

ODBC drivers are not good suggestions and unfortunately they do not "always" work. They may did work 10 years ago, but now they are generally avoided.
I expect the database will be either MySQL or Oracle so there should be no trouble with proper drivers.