Java Forums

Main Menu
Home
Today's Posts
FAQ
Search
Contact Us

Java Network
Linux Archive
Java Tips
Java Tips Blog

Sponsored Links





Welcome to the Java Forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community, you will:

  • have access to post topics
  • communicate privately with other members (PM)
  • not see advertisements between posts
  • have the possibility to earn one of our surprises if you are an active member
  • access many other special features that will be introduced later.

Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 06-26-2008, 08:22 AM
Member
 
Join Date: Jan 2008
Posts: 83
Preethi is on a distinguished road
Connection the sql server
Is there any difference in connecting to the sqlserver2000 and 2005...
i.e.,should i have to use the same code and file which i use to connect to
the sqlserver2000 to connect to 2005???
Quote:
Class.forName("com.microsoft.jdbc.sqlserver.SQLSer verDriver");
connection = DriverManager.getConnection("jdbc:microsoft:sqlser ver://localhost:1433;DatabaseName=Mine", "sa", "sa");
Bookmark Post in Technorati
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 06-26-2008, 12:17 PM
Member
 
Join Date: May 2008
Posts: 24
daGame is an unknown quantity at this point
Yes you can connect to MsSQL 2000 using MsSQL 2005 driver.

just google around.

The documentation has sample examples of which driver to use and to connect to Java applications.

P.S: This is crap, why do i have to have my post count more than 10 to post a link .I mean it doesnt really make any sense to me, does it?

P.S again:@OP:

im sorry i had placed the links for you to see, but this forum software didnt allow me to post the links, so just google around

Last edited by daGame : 06-26-2008 at 12:18 PM. Reason: links
Bookmark Post in Technorati
Reply With Quote
  #3 (permalink)  
Old 06-26-2008, 12:51 PM
Member
 
Join Date: Jan 2008
Posts: 83
Preethi is on a distinguished road
i can able to connect to database as a normal java program,but the problem comes only wen i try to connect from an applet..
Bookmark Post in Technorati
Reply With Quote
  #4 (permalink)  
Old 06-26-2008, 01:28 PM
Member
 
Join Date: May 2008
Posts: 24
daGame is an unknown quantity at this point
Quote:
Originally Posted by Preethi View Post
i can able to connect to database as a normal java program,but the problem comes only wen i try to connect from an applet..
What driver are you using? what errors are you getting?
Bookmark Post in Technorati
Reply With Quote
  #5 (permalink)  
Old 06-26-2008, 01:43 PM
Member
 
Join Date: Jan 2008
Posts: 83
Preethi is on a distinguished road
jdbc driver..
Bookmark Post in Technorati
Reply With Quote
  #6 (permalink)  
Old 06-26-2008, 01:54 PM
Member
 
Join Date: May 2008
Posts: 24
daGame is an unknown quantity at this point
Quote:
Originally Posted by Preethi View Post
jdbc driver..
Of course you are using a jdbc driver, what i meant was which type?,version?

etc error if any? im sure your driver docs has something to say to you that

you havent yet read. Read them and im sure you will have a solution. the

driver docs will have listed support to applets, if not search for a compatible driver.
Bookmark Post in Technorati
Reply With Quote
  #7 (permalink)  
Old 06-26-2008, 04:41 PM
Member
 
Join Date: Jan 2008
Posts: 83
Preethi is on a distinguished road
Can you help me,how to find the driver type in sqlserver 2005....driver version is 2.2.002..
Bookmark Post in Technorati
Reply With Quote
  #8 (permalink)  
Old 06-26-2008, 05:05 PM
Member
 
Join Date: May 2008
Posts: 24
daGame is an unknown quantity at this point
Quote:
Originally Posted by Preethi View Post
Can you help me,how to find the driver type in sqlserver 2005....driver version is 2.2.002..
Did you read the docs?

Google for "jdbc driver to connect to MsSQL server 2005" the very first link

gave me the link to download the MsSQL driver, download and read the docs

carefully. This should work.

Hope That Helps.
Bookmark Post in Technorati
Reply With Quote
Sponsored Links
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Web-App server connection - How to hit the particular app server from the web server maruthi_s Enterprise JavaBeans 2 07-15-2008 08:11 PM
[SOLVED] Connection to file server luislopezco Networking 3 05-21-2008 09:00 AM
Sql server connection problem tanvirtonu Database 1 03-31-2008 02:46 PM
no connection even Database 15 01-02-2008 03:50 PM
SQL Server 2005 Jdbc connection mgt83 JavaServer Pages (JSP) and JSTL 0 07-27-2007 06:52 AM


All times are GMT +3. The time now is 02:37 AM.


VBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright ©2006 - 2007, www.java-forums.org