• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

type four driver(thin driver) for ms-access

 
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Dear all,

i need the type four driver(thin driver) for ms-access. so anyone please guide me that from where i get the same or how can i create a data source for odbc bridge by which data source i can directly use by ms-access database whithout going to setting->adminstrtor tool->data source(odbc)->msaccessdriver etc.. in ms-winodows.

thank you,
Ishan dave
 
Bartender
Posts: 2661
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
HXTT Access Pure Java JDBC Drivers for MS Access.
(type 3 only): aveConnect JDBC Driver for MS Access.
Both cost money.
Regards, Jan
 
Ranch Hand
Posts: 2308
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I was not aware that MS access also have type 4 drivers.

I do not think access has any listening socket for accepting requests , I think usually this is the way a type 4 driver establishes connection with a database.

You might have to put the access file in some location that your application can access.
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

I do not think access has any listening socket for accepting requests , I think usually this is the way a type 4 driver establishes connection with a database.



Type 4 means Java-only - it does not specify what access technology is used (although it most often is TCP). But an Access DB is not a server, it's just a file, and that is not accessible through TCP.
 
ishan dave
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Dear Friends,
Thanks a lot for your valueable reply. Actually i was not aware about the listening socket of ms-access that is why used the term type four. And Jan I could not afford to buy a driver as it is a small project.
Now can you people please guide me that how can I develop a class that creats a data source and then i can use that data source in my project.

thank you again,

regards,
Ishan Dave
 
Rahul Bhattacharjee
Ranch Hand
Posts: 2308
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by ishan dave:
Actually i was not aware about the listening socket of ms-access that is why used the term type four


Apologies for my misleading post.
Learnt a new thing. ;)
 
Ulf Dittmer
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by ishan dave:
Now can you people please guide me that how can I develop a class that creats a data source and then i can use that data source in my project.



What kind of class is that you want to write? If you can't use the commercial drivers, then that leaves the JDBC/ODBC bridge as the only option. From your first post it seems that you already know how to set that up.

(Unless you want to use Jackcess, which can access MDB files without using JDBC).
 
Jan Cumps
Bartender
Posts: 2661
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
If you don't want to set up a Windows Datasource, you can use this URL, using a direct path to the access database:(solution from http://www.techbookreport.com/tutorials/jdbcodbc.html)

Regards, Jan

[Edit: added reference]
[ May 28, 2007: Message edited by: Jan Cumps ]
 
reply
    Bookmark Topic Watch Topic
  • New Topic