• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

How to link JAVA with SQL Server 2000 using Jbuilder?

I'm doing my final year project.I would like to know to know how to link JAVA with SQL Server 2000 using JBuilder.Please do give me some tutorials on how to  link them as i'm new to this area.I'm not so sure on what driver to use as well.Please give me some codes or anything that can help me.Thank You !
0
Alisha23
Asked:
Alisha23
1 Solution
 
TimYatesCommented:
You will need to use JDBC

You can download the JDBC drivers for SQL Server from here:

http://www.freetds.org/

it's an opensource implementation of it :-)

(you can get it from here)
http://jtds.sourceforge.net/

As they say:

"Being a type 4 JDBC driver, jTDS does not need any kind of installation. Just add jtds.jar (or whatever the name of your specific version of jar is) to your existing classpath and you're done. What's more important is the class name of the driver and DataSource implementations and the URL format. The class names are net.sourceforge.jtds.jdbc.Driver (for the Driver implementation) and net.sourceforge.jtds.jdbcx.TdsDataSource (for the DataSource implementation). The URL format is:

    jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]
where <server_type> is one of either 'sqlserver' or 'sybase' (their meaning is quite obvious), <port> is the port the server is listening to (with a default of 1433 for SQL Server and 4000 for Sybase) and <database> is the database name -- or catalog, by the JDBC terminology -- (default is 'master'). For more information about specific properties supported by jTDS and other questions, check out the Frequently Asked Questions page.
"

Then, it's just a case of learning JDBC :-)

http://java.sun.com/docs/books/tutorial/jdbc/
0
 
umangjoshiCommented:
Connection con=DriverManager.getConnection("jdbc:odbc:DRIVER={SQL Server};DATABASE=databasename;UID=userid;PWD=password;SERVER=sererip;");
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now