You seem to be missing the end Password attribute tag (</attribute>).
I have just setup that driver with MSQL Server 7 and it appears to work fine,
I don't know if it will work with SQL Server 2000..but I would think so.
I would also just run a test app outside of JBoss to make sure the driver
works with the SQL 2000 server..something simple like:
/*****************************************/
import java.sql.*;
public class JDBCTest
{
public static void main(String args[])
{
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try
{
Class.forName("com.internetcds.jdbc.tds.Driver");
con = DriverManager.getConnection("jdbc:freetds://localhost:1433/NCRMSGB",
"sa", "");
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT SomeColumn FROM SomeTable");
rs.next();
do
{
System.out.println(rs.getString("SomeColumn").trim());
} while ( rs.next() );
}
catch (ClassNotFoundException e)
{
System.err.println("Couldn't load the driver: " + e.getMessage());
}
catch (SQLException e)
{
System.err.println("SQLExecption caught: " + e.getMessage());
}
}
}
/*****************************************/
Daren
On Fri, 6 Apr 2001, Antonio Vazquez wrote:
> Hi all,
> I have some problems creating a connection pool using the FreeTDS driver.The
> database server is MS-SQL Server 2000. I've followed the document "HowTo:
> Use MS SQL Server with JBoss".I don´t know which is the problem.
>
> The lines from jboss.jcml are:
>
> <attribute name="Password" />
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
