conecting database

Discussion in 'QnA (read only)' started by adityabakle, Aug 3, 2004.

Thread Status:
Not open for further replies.
  1. adityabakle

    adityabakle New Member

    Joined:
    Aug 3, 2004
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Solapur
    Hello

    For connecting Access file to programs in Java or VB, one needs to configure the Access file using ODBC (provided in control panel). This task is done explicitly and not through program, Can I know how to do this through program in Java/VB both. Is there any code?? :!:
     
  2. GNUrag

    GNUrag FooBar Guy

    Joined:
    Jun 22, 2004
    Messages:
    1,246
    Likes Received:
    5
    Trophy Points:
    0
    Location:
    Interwebs
    ODBC is an open standard developed for the purpose of data access by programming architecture other that microsoft's one, like from a java environment... However, data access from ODBC drivers is consistently slow. For Microsoft development environment, you'd better use ADO or Jet. Java based database access can be done using the JDBC:ODBC driver only.
     
  3. it_waaznt_me

    it_waaznt_me Coming back to life ..

    Joined:
    Nov 30, 2003
    Messages:
    2,023
    Likes Received:
    10
    Trophy Points:
    38
    Location:
    A bit closer to heaven
    You Should use Jet 4.0 or greater in VB for Access dbs ..
    When you select Jet 4 as your driver you just have to tell the location of your db file and the Table that you wanna use as recordset ...

    btw .. If I misunderstood then please clarify it what u reallly wanna do ..
     
Thread Status:
Not open for further replies.

Share This Page