question about "com.microsoft.jdbc.sqlserver"

[Eddie Chu]

hi all,
i am doing a project that require me to write a java program connecting with
sql server 2000.
i have found that i need a package called "com.microsoft.jdbc.sqlserver".
However, i do not know where can i download or buy it.

can anyone tell me how i can get the package?

http://msdn.microsoft.com/asp.net/using/migrating/jspmig/phase1/adonet/

thanks

Simon

[Carb Simien [MSFT]]

Hello,

It looks like you just need to download and install the JDBC driver from
our website:

Microsoft SQL Server 2000 Driver for JDBC - Service Pack 1
http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7-4c4d-
8f7b-3d47969e66ae&DisplayLang=en

Hope that helps!

Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

--------------------
| From: "Eddie Chu" <cs_...@stu.ust.hk>
| Subject: question about "com.microsoft.jdbc.sqlserver"
| Date: Tue, 4 Nov 2003 00:12:59 +0800
| Lines: 15
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <ug49aVio...@TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: dmb037.resnet.ust.hk 143.89.64.37
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.jdbcdriver:5281
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver

[Eddie Chu]

hi
i have installed the driver that you mentioned and try to exectue a simple
program.
import java.sql.*;

class GetData
{
public static void main(String[] args)
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SqlServerDriver");
}
catch (Exception e){ e.printStackTrace(); }
}
}

However, when i run the program, it displays following lines

java.lang.ClassNotFoundException:
com.microsoft.jdbc.sqlserver.SqlServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:198)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at GetData.main(GetData.java:9)

Could you tell me why?
Thanks

"Carb Simien [MSFT]" <Carb...@online.microsoft.com> 在郵件
news:VYuhbqjo...@cpmsftngxa06.phx.gbl 中撰寫...

[Carb Simien [MSFT]]

Be sure that you have followed all of the instructions, as you must first
add the 3 .jar files to your CLASSPATH environment variable.

For example:

CLASSPATH=.;c:\Microsoft SQL Server 2000 Driver for
JDBC\lib\msbase.jar;c:\Microsoft SQL Server 2000 Driver for
JDBC\lib\msutil.jar;c:\Microsoft SQL Server 2000 Driver for JDBC
\lib\mssqlserver.jar

Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

--------------------
| From: "Eddie Chu" <cs_...@stu.ust.hk>

| References: <ug49aVio...@TK2MSFTNGP09.phx.gbl>
<VYuhbqjo...@cpmsftngxa06.phx.gbl>
| Subject: Re: question about "com.microsoft.jdbc.sqlserver"
| Date: Tue, 4 Nov 2003 08:55:22 +0800
| Lines: 97

| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165

| Message-ID: <u#s0V5moD...@tk2msftngp13.phx.gbl>

| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: dmb037.resnet.ust.hk 143.89.64.37

| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.jdbcdriver:5289
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver