Results 1 to 5 of 5

Thread: Java connect to Access

  1. Dec 3rd, 2003, 11:45 PM #1
    annie613
    annie613 is offline

    Thread Starter
    Addicted Member annie613's Avatar
    Join Date
    May 2003
    Location
    NY, NY
    Posts
    161

    Java connect to Access

    I usually program in VB 6.0 but i was asked if i could develop a Java applet using Borlands JBuilder and connect to a MS Accesss Database....

    is there a certain code string that i need to connect

    thanks in advance
    annie
    Reply With Quote Reply With Quote
  2. Dec 3rd, 2003, 11:48 PM #2
    annie613
    annie613 is offline

    Thread Starter
    Addicted Member annie613's Avatar
    Join Date
    May 2003
    Location
    NY, NY
    Posts
    161
    i am reading the post below on Java and DBs by delta770
    i will go from there

    any suggestions are still welcomed

    thanks
    Reply With Quote Reply With Quote
  3. Dec 4th, 2003, 04:16 AM #3
    CornedBee
    CornedBee is offline
    Kitten CornedBee's Avatar
    Join Date
    Aug 2001
    Location
    In a microchip!
    Posts
    11,594
    Access database from an applet is very difficult. The JDBC-ODBC relies on native code and thus may not be used from an applet.

    Better to use a MySQL database, especially since you have to connect to a remote DB anyway.
    All the buzzt
    CornedBee

    "Writing specifications is like writing a novel. Writing code is like writing poetry."
    - Anonymous, published by Raymond Chen

    Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.
    Reply With Quote Reply With Quote
  4. Dec 4th, 2003, 08:34 AM #4
    annie613
    annie613 is offline

    Thread Starter
    Addicted Member annie613's Avatar
    Join Date
    May 2003
    Location
    NY, NY
    Posts
    161
    i am new to the whole java thing, but could this be done in an app or someone i was talking to said...servlets, or sockets...

    i was confused...

    but i maybe albe to handle the application if you think that will work...

    and thanks for the suggestion on MySQL....i would rather use that anyway
    Reply With Quote Reply With Quote
  6. Dec 4th, 2003, 09:06 AM #5
    CornedBee
    CornedBee is offline
    Kitten CornedBee's Avatar
    Join Date
    Aug 2001
    Location
    In a microchip!
    Posts
    11,594
    A Java application or a Servlet do not have any restrictions beyond those imposed by the servlet container (configured by you).

    An Applet (the stuff running in browsers) has severe security restrictions: you cannot open local files, you cannot connect to anywhere except the originating server, you cannot execute any native code.

    I believe there are true Java JDBC drivers for Access by 3rd party vendors. You can use those even from applets. But they are not free like the MySQL driver is.
    All the buzzt
    CornedBee

    "Writing specifications is like writing a novel. Writing code is like writing poetry."
    - Anonymous, published by Raymond Chen

    Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width