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.
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.
Joined: Apr 16, 2007
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
Joined: Nov 29, 2005
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. ;)
Joined: Mar 22, 2005
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).