Bom dia a todos.
Alguem saberia me dizer se esta é a forma correta para a utilização do driver de conexão jTDS:
[code]import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnectionFactory {
private static final String URL = “jdbc:jtds:sqlserver://dmndiacelsql:1433/QBDADOS”;
private static final String DRIVER = “net.sourceforge.jtds.jdbc.Driver”;
private static final String USUARIO = “usuario”;
private static final String SENHA = “senha”;
public static Connection getConnection() throws SQLException{
try{
Class.forName(DRIVER);
System.out.println("Conectando a Banco de Dados...");
return DriverManager.getConnection(URL, USUARIO, SENHA);
}catch (ClassNotFoundException e) {
throw new SQLException (e.getMessage());
}
}
}[/code]
estou obtendo uma exception:
Exception in thread "main" java.sql.SQLException: Login failed for user 'usuario'. The user is not associated with a trusted SQL Server connection.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:599)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:331)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at br.com.diacel.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:17)
at br.com.diacel.jdbc.teste.TestaConexao.main(TestaConexao.java:16)
e no servidor eu consigo me logar normal…
alguem pode me ajudar por favor?
obrigado
