PDA

View Full Version : Java and SQL Data Base



judy
08-28-2008, 11:52 AM
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:D

tfit
08-28-2008, 12:09 PM
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
09-14-2008, 11:40 AM
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.