Sorry, i'm very busy at this time, so i doesn't take time
to search the precise response.
But i'm sure that the version MSDAC 2 & 2.11 don't works.
The right version of ODBC driver may be one prior to MSDAC 1.5
(odbc library #3.510.???).

Deinstall/reinstall ODBC is not an  easy job, and i my opinion,  this is for
a poor result,
so except if  you really had to use the jdbc:odbc bridge
(because there is no JDBC driver available for the
sgbdr you plan to use  for example) it's better to use JDBC.

To perform the tests
i was used jdk 1.2.2/jswdk 1.0.1 on NT4/SP5 server,
but now for the real job i'm using Apache/Tomcat on Linux with a JDBC
connection to SGBD wich stay on a NT server and everything works fine.

Using JDBC is not much complicated than use JDBC:ODBC bridge, and
(for me) it's much more efficient.
Interbase (www.interbase.com) provides a very good cross plateform
solutions, and it's free for test
and development (not for distribution). All of them are freely
downloadables.
On NT system all that you had to do is to install
the SGBDR engine (interbase)
the JDBC software (interclient)
and run them as a services.
On your code you should replace
the "sun.jdbc.odbc.JdbcOdbcDriver" by "interbase.interclient.Driver"
(in your .properties file or on Class.forName () depending on the method
you choose)
and the odbc source name by the database url "jdbc:interbase://...".
on the method DriverManager.getConnection ().
The rest remains the same.
That's all and that's work.

Be carefull, this is just based on my experiences, i don't
think (and i don't tell) that's the only and the better way.

Hope that help you.

Brb (Brb@N...)












--- 
NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?
Visit EarthWeb for the latest in IT Management, Software Development, 
Web Development, Networking & Communications, and Hardware & Systems.  
Click on http://www.earthweb.com for FREE articles, tutorials,
and discussions from the experts.
---
You are currently subscribed to pro_java_server as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-pro_java_server-$subst('Recip.MemberIDChar')@p2p.wrox.com