Connection the sql server

[Preethi]

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???

Class.forName("com.microsoft.jdbc.sqlserver.SQLSer verDriver");
connection = DriverManager.getConnection("jdbc:microsoft:sqlser ver://localhost:1433;DatabaseName=Mine", "sa", "sa");

[daGame]

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 :confused: .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 :)

[Preethi]

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..

[daGame]

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?

[Preethi]

jdbc driver..

[daGame]

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.

[Preethi]

Can you help me,how to find the driver type in sqlserver 2005....driver version is 2.2.002..

[daGame]

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.