This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

Setting Database driver and DSN for MS SQL Server

Posted by Mohamed Ali on March 30, 2001 at 2:39 AM

Hi,
You have to make the following additions to the default.properties file found in the config directory of J2ee :

jdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver
jdbc.datasources=jdbc/MSSQLServer|jdbc:odbc:DSN;create=true

Add the above two lines to the default.properties file.

While deployment , give the database JNDI name (In deploymant settings) as "jdbc/MSSQLServer" and username as "sa" . Leave the password blank.

Bye

While deploy

> Hi,
> I am sekhar and I am in need of the same resources as you need. Could please let me know how did you do this using j2ee?

> Regards,
> Sekhar

> > hi all,
> > Can anybody tell me how do we set the database driver and database userid and pwd for j2ee server when creating EJB. Which property file to use. What is the syntax for specifying the properties....

> > thanx in advance
> > abcd