type four driver(thin driver) for ms-access

[ishan dave]

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]

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

[Rahul Bhattacharjee]

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.

[Ulf Dittmer]

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]

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]

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]

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]

If you don't want to set up a Windows Datasource, you can use this URL, using a direct path to the access database:

String url = "jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=c:/path/to/MyAccessDB.mdb";

(solution from http://www.techbookreport.com/tutorials/jdbcodbc.html)

Regards, Jan

[Edit: added reference]
[ May 28, 2007: Message edited by: Jan Cumps ]