Advanced Search

Results 1 to 3 of 3

Thread: Java and SQL Data Base

  1. #1
    Join Date
    Aug 2008
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Java and SQL Data Base

    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

  2. #2
    Join Date
    Mar 2008
    Posts
    218
    Thanks
    7
    Thanked 19 Times in 19 Posts

    Default

    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.

  3. #3
    Join Date
    Sep 2008
    Location
    London or Slovakia
    Posts
    27
    Thanks
    1
    Thanked 2 Times in 2 Posts

    Default

    Quote Originally Posted by tfit View Post
    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.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •