[ jeremycod @ 21.08.2003. 20:45 ] @
Kako uspostaviti vezu izmedju Java aplikacije i MS SQL Servera? U ovom primeru koji sam radio uvek prijavljuje istu gresku. java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user 'zoran'. Reason: Not associated with a trusted SQL Server connection. Da li neko moze da mi pomogne u cemu gresim. Nemam bas iskustva u radu sa SQL Serverom. import java.sql.*; public class Demo1 { public static void main(String[] args) { try{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection conn=DriverManager.getConnection( "jdbc:microsoft:sqlserver://localhost:1433;User=zoran"); String query="SELECT ime,prezime FROM MojaTabela"; Statement stmt=conn.createStatement(); ResultSet rset=stmt.executeQuery(query); while(rset.next()){ System.out.println(rset.getString(1)+" "+ rset.getString(2)); } rset.close(); stmt.close(); conn.close(); } catch (Exception ex){ ex.printStackTrace(); } } } |