-
1. Re: Session EJB and 'jdbc:freetds:sqlserver'
katakyie Apr 3, 2002 9:40 AM (in response to rab)Hi spokes,
i also need to configure Jboss2.4.4_Tomcat4.0.1 to access a database ( MS SQL Server 7.0 ) using the tds driver. Already I have done the following:
1. I made a tds.jar containing the driver.
2. I copied tds.jar into <path_to_jboss>\lib\ext
3. I edited the jboss.jcml files in
<path_to_jboss>\conf\default and
<path_to_jboss>\conf\catalina
Under the JDBC Section, i inserted following tags.
com.inet.tds.TdsDriver
jdbc:inetdae:myIPName:1433?
database=kweb;sql7=true
user
password
When I run Jboss, I can read the following
...
[INFO,JdbcProvider] Initializing
[INFO,JdbcProvider] Loaded JDBC-driver:org.hsqldb.jdbcDriver
[INFO,JdbcProvider] Loaded JDBC-driver:com.inet.tds.TdsDriver
[INFO,JdbcProvider] Initialized
...
So far, so good !
The question is how do I proceed further?
Can you share your experience with me?
kat.