Type 1 is a
JDBC ODBC driver
as a result it needs the ODBC code ( native = binary ) on the client
here client = machine that hosts the database connectivity
Type 2 drivers are part
java part native code
so both these drivers have os compatibility issues
Infact type 1 would only run on Microsoft OS
Type 2 drivers would face portability issues
Regarding type 3 driver - havent come across a scenario where I would use one
type 4 is a pure java driver - gives good performance - no portability issues
Thanks ,
-anagha
[ December 28, 2005: Message edited by: anagha patankar ]