I have been using the built-in JDBC driver from JDK1.3 and MS SQL 2000 for my windows database application.

How do I use it in an EJB. Will the way I create the connection and statement still the same.

I read the J2EE SDK JDBC configuration guide. It says that if I want to use a database different from CloudScape I have to modify the enviroment variable J2EE_CLASSPATH in 'userconfig.bat' to include my JDBC driver. How do I do this IF I still want to use 'jdbc.odbc' driver from Sun SDK1.3, please!


Thank You Greatly!
Pete