HiI'm using i-net OPTAT 2000 Version 4.13, with MSQL 7 and JBOSS 2.4, and I'm having problems for connecting to DBase.The only way I can link it is to add "con.setCatalog(databaseName)" after the DataSource's statement.Could you please let me know how do you connect to dbase through the DataSource's statement only?

The below is the extra info, just in case that you have problem setting things up.

Here you will have to set up the connectionPool for opta2000.You will need the link to the driver:com.inet.tds.TdsDriverand the rest of setings for the poolThis is the file name : jboss.jcml

You will need to add the opta jar to the classpath.this is good place, since jboss will load it whenever you restart the server.jboss/jboss/lib/ext/Opta2000.jaralso the jdbc2_0-stdext.jar ( recommended )jdbc 2.0 optional package.

Hope it helps......

This is extra:NOTE: There is a nice article how to utilize the EjbProxy.Site is: java world (Java Tip 118 )