wood burning stoves 2.0*
The moose likes JDBC and the fly likes type four driver(thin driver) for ms-access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "type four driver(thin driver) for ms-access" Watch "type four driver(thin driver) for ms-access" New topic
Author

type four driver(thin driver) for ms-access

ishan dave
Ranch Hand

Joined: Apr 16, 2007
Posts: 39
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
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2497
    
    8

HXTT Access Pure Java JDBC Drivers for MS Access.
(type 3 only): aveConnect JDBC Driver for MS Access.
Both cost money.
Regards, Jan


OCUP UML fundamental and ITIL foundation
youtube channel
Rahul Bhattacharjee
Ranch Hand

Joined: Nov 29, 2005
Posts: 2308
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.


Rahul Bhattacharjee
LinkedIn - Blog
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41599
    
  55
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.


Ping & DNS - my free Android networking tools app
ishan dave
Ranch Hand

Joined: Apr 16, 2007
Posts: 39
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

Joined: Nov 29, 2005
Posts: 2308
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
Marshal

Joined: Mar 22, 2005
Posts: 41599
    
  55
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

Joined: Dec 20, 2006
Posts: 2497
    
    8

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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: type four driver(thin driver) for ms-access