1. Hey Guest Did you know you can win an Honor 10 phone worth ₹33,000 and an additional ₹70,000 in paytm vouchers, just by replying to some threads and taking part in the discussions happening in the Honor Hub?

    What are you waiting for? Start commenting and start winning! Remember to read the instructions posted here.

    Dismiss Notice

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