Connecting to SQLServer 2000 using JDBC

msi_333 · **Posted:** Sat Apr 07, 2007 2:59 pm

Connecting to SQLServer 2000 take from me 2 days until i discovered the problem,
I tried all the solutions on the net until i installed the Service Pack 3,
In fact the TCP server of SQL-Server 2000 was not working . u can check that using :
Telnet localhost portnumber
in the command line

But after installation of Service pack3 finally TCP server work fine and i connected to the Database Server :lol:

So the first thing to do is to check the TCP server.
Second if it not working try to install Service pack3 from Microsoft

Here is the code to Open A connection to SQL-server 2000 using Microsoft JDBC

Code:

  try {
         Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            System.out.println("Driver Exits !!!");
            
           connection = DriverManager.getConnection(
    "jdbc:microsoft:sqlserver://computer_name:port","username","password");
         
            } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
          catch (SQLException ex) {
             ex.printStackTrace();
        }

Xline · **Posted:** Fri Jun 08, 2007 12:50 am

Thanks for Code

as JDK1.6 no need for Class.forName(..etc)

msi_333 · **Posted:** Fri Jun 08, 2007 10:42 am

Xline wrote:

Thanks for Code

as JDK1.6 no need for Class.forName(..etc)

But , I think we may need Class.forName to specify the Driver you are using :?:

. For Example

For Mysql:

Code:

Class.forName("com.mysql.jdbc.Driver").newInstance();

For PostGrelsql :

Code:

Class.forName("org.postgresql.Driver").newInstance();

Mohamed Alzahar · **Posted:** Mon Jun 18, 2007 12:56 am

This Code learn you how to connect your java application with sql server using JDBC-ODBC:

Code for Database Connection in Java

Code:

Import java.sql.*;
try   
{ 
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection connection = DriverManager.getConnection("jdbc:odbc:WSD");
  Statement statement = connection.createStatement();
  ResultSet result = statement.executeQuery("SELECT * from student"); 
  statement.execute("insert into student values (1,12)");
}
catch (Exception e)
{
}

Notes :
WSD is the name of the connection name you made in the ODBC.
Line 4 is used if you want to execute a select statement and you can read data using string return = result.getString(Ø·Â£Ø¢Â¢Ø£Â¢Ã¢â‚¬Ú‘Ø¢Â¬Ø·Â¥Ã¢â‚¬Å“here you put the columns index you want to get its valueØ·Â£Ø¢Â¢Ø£Â¢Ã¢â‚¬Ú‘Ø¢Â¬Ø£Â¢Ã¢â€šÂ¬Ø¥â€™); // 1 as an example
To move the pointer of reading you write result.next();
DonØ·Â£Ø¢Â¢Ø£Â¢Ã¢â‚¬Ú‘Ø¢Â¬Ø£Â¢Ã¢â‚¬â€Ø¢Â¢t forget the import statement.
Line 4 is used to execute any non- select statement.

To make a connection name called Ø·Â£Ø¢Â¢Ø£Â¢Ã¢â‚¬Ú‘Ø¢Â¬Ø·Â¥Ã¢â‚¬Å“mydbØ·Â£Ø¢Â¢Ø£Â¢Ã¢â‚¬Ú‘Ø¢Â¬Ø£Â¢Ã¢â€šÂ¬Ø¥â€™ do the followings:
Control Panel -> Administrative Tools - >Data Sources (ODBC) -> add
Search for SQL Server then - > choose it and then click Finish
Write a name, description and name of your server - > name is Ø·Â£Ø¢Â¢Ø£Â¢Ã¢â‚¬Ú‘Ø¢Â¬Ø·Â¥Ã¢â‚¬Å“mydbØ·Â£Ø¢Â¢Ø£Â¢Ã¢â‚¬Ú‘Ø¢Â¬Ø£Â¢Ã¢â€šÂ¬Ø¥â€™ and server is your SQL Server Name Then click next, then another next.
Change the default database to Ø·Â£Ø¢Â¢Ø£Â¢Ã¢â‚¬Ú‘Ø¢Â¬Ø·Â¥Ã¢â‚¬Å“and choose your oneØ·Â£Ø¢Â¢Ø£Â¢Ã¢â‚¬Ú‘Ø¢Â¬Ø£Â¢Ã¢â€šÂ¬Ø¥â€™, example Ø·Â£Ø¢Â¢Ø£Â¢Ã¢â‚¬Ú‘Ø¢Â¬Ø·Â¥Ã¢â‚¬Å“NorthWindØ·Â£Ø¢Â¢Ø£Â¢Ã¢â‚¬Ú‘Ø¢Â¬Ø£Â¢Ã¢â€šÂ¬Ø¥â€™ then next and then finish.
You may test Data Source , then click ok

Now, you made a Data Source than is connected to your database, for my example it is Ø·Â£Ø¢Â¢Ø£Â¢Ã¢â‚¬Ú‘Ø¢Â¬Ø·Â¥Ã¢â‚¬Å“NorthWindØ·Â£Ø¢Â¢Ø£Â¢Ã¢â‚¬Ú‘Ø¢Â¬Ø£Â¢Ã¢â€šÂ¬Ø¥â€™
And now Line 4 and 5 must be from the tables in NorthWind Ø·Â£Ø¢Â¢Ø£Â¢Ã¢â‚¬Ú‘Ø¢Â¬Ø·Â¢Ø¢Â¦ and now you may change WSD in line 2 to be mydb.

tetosoft · **Posted:** Mon Jun 18, 2007 5:38 pm

Thanks for your code zahar

Connecting to SQLServer 2000 using JDBC

Users browsing similar posts