sqlServer connection

[omar bili]

hi, i want to create a connection with
sqlServer can someone tell me what are
the steps that i shoul do .
thx for any help

[Julian Kennedy]

Go find yourself a SQL Server JDBC driver. Microsoft's or Sybase's websites (depending on which SQL Server) would be a good start. Then read the instructions it comes with and come back here if you have problems.

Jules

[Martin Lira]

This should help
http://support.microsoft.com/default.aspx?scid=kb;en-us;313100
http://www.microsoft.com/downloads/details.aspx?FamilyID=9f1874b6-f8e1-4bd6-947c-0fc5bf05bf71&displaylang=en

[omar bili]

thx for the help

[Prashant Jain]

Micorsofts JDBC driver for SQL Server 2000 is freely available on their site.(Something is Free at Microsoft :-))The documentation is not very exhaustive but will definitely guide you through to configuring the connection.Here is a sample code,

public String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

public String connectionString ="jdbc:microsoft:sqlserver://<<servername>>"+
";User=,,username>>"+";Password=<<password>>"+";SelectMethod=cursor";
Class.forName(driverName);
final Connection conn = DriverManager.getConnection(connectionString1);

Hope it helps!

Happpy Programming!
Prashant Jain
[e-mail]