File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and Relational Databases and the fly likes jdbc with microsoft SQl Server 2008 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "jdbc with microsoft SQl Server 2008" Watch "jdbc with microsoft SQl Server 2008" New topic
Author

jdbc with microsoft SQl Server 2008

Rajeev Kumarjamshedpur
Greenhorn

Joined: Apr 27, 2009
Posts: 5
hi
I am wrinting a simple java code that communicate with microsoft SQL Server 2008

and after this set classpath of sqljdbc4.jar
and after this i comile the program i got following error
C:\Documents and Settings\r6876046\Desktop>javac Test.java
Test.java:7: package com.microsoft.sqlserver.jdbc does not exist
DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQ
LServerDriver());
^
1 error


here is my source code

import java.sql.*;
class Test
{
public static void main(String[] args) throws Exception
{
// Register the driver
DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver());
// Establish connection with the Database
Connection con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433:10.87.1.4","sa","jeffrey");
//cfreate a sql statement
Statement stmt=con.createStatement();
//Execute the stmt
ResultSet rs=stmt.executeQuery("select * from studentinfo");
//all row of student table are in rs Now retrive column data from rs and display
while(rs.next()){
System.out.println(rs.getInt(1));
System.out.println(rs.getString(2));
//System.out.println(rs.getInt(1));
System.out.println("===================================");
}
// close the connection
con.close();
}
}


Please help me about this and where i need to change and how i achive the goal please guide me properly i am waiting for Your Response


thanks In Advance

Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3882

Use,


to load and register the driver class with the DriverManager.


SCJP 5 | SCWCD 5
[How to ask questions] [Twitter]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jdbc with microsoft SQl Server 2008