Home All Groups Group Topic Archive Search About

SQL Server 2000 Driver for JDBC SP3

Author
7 Sep 2006 12:18 PM
Yman
Hi

I'm trying to register the JDBC driver, I found the articles on how to do it
but there are no instruction on which tool to use or the command.

If any one has any idea that would greatful.

thanks

Author
7 Sep 2006 12:59 PM
John Bell
Hi

What do you mean by register?

From:
http://download.microsoft.com/download/4/1/d/41d3e9c0-64d1-451e-947b-7a4cba273b2d/Install_Guide.txt
To install it on a Windows Computer just run setup.exe
If on a unix platform tar is an OS command.

On the windows version it will install into C:\Program Files\Microsoft SQL
Server 2000 Driver for JDBC. Once setup you will have an installation and
user guide in the books directory. The user guide shows you how to set the
CLASSPATH  and registering it using Class.forName() e.g

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")

If you wish to use the driver to connect to the database it should be called
in the form
jdbc:Microsoft:sqlserver://my-virtualserver:1433;DatabaseName=Pubs

e.g.
Connection conn = DriveManger.getConnection
("jdbc:Microsoft:sqlserver://dbserver:1433;DatabaseName=Pubs;User=username;Password=password")

John

Show quote
"Yman" <Y***@discussions.microsoft.com> wrote in message
news:B772594B-CFEA-4A0F-8C1E-2FDA96F9000D@microsoft.com...
> Hi
>
> I'm trying to register the JDBC driver, I found the articles on how to do
> it
> but there are no instruction on which tool to use or the command.
>
> If any one has any idea that would greatful.
>
> thanks
Author
7 Sep 2006 1:22 PM
Yman
I've already looked at these documentation, when I try to install IBM
Director 5.1.3, in the configuration I have to select the SQL Database I've
created. The message from Director "Unable to register the JDBC Driver. It's
missing from the Classpath or might not be installed".

My Classpath is set properly, and the JDBC driver is installed in the proper
location according to the IBM documentation.

So I thought I need to register the driver according to the message from
director. The article you already sent to me I already looked at it.

Show quote
"John Bell" wrote:

> Hi
>
> What do you mean by register?
>
> From:
> http://download.microsoft.com/download/4/1/d/41d3e9c0-64d1-451e-947b-7a4cba273b2d/Install_Guide.txt
> To install it on a Windows Computer just run setup.exe
> If on a unix platform tar is an OS command.
>
> On the windows version it will install into C:\Program Files\Microsoft SQL
> Server 2000 Driver for JDBC. Once setup you will have an installation and
> user guide in the books directory. The user guide shows you how to set the
> CLASSPATH  and registering it using Class.forName() e.g
>
> Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
>
> If you wish to use the driver to connect to the database it should be called
> in the form
> jdbc:Microsoft:sqlserver://my-virtualserver:1433;DatabaseName=Pubs
>
> e.g.
> Connection conn = DriveManger.getConnection
> ("jdbc:Microsoft:sqlserver://dbserver:1433;DatabaseName=Pubs;User=username;Password=password")
>
> John
>
> "Yman" <Y***@discussions.microsoft.com> wrote in message
> news:B772594B-CFEA-4A0F-8C1E-2FDA96F9000D@microsoft.com...
> > Hi
> >
> > I'm trying to register the JDBC driver, I found the articles on how to do
> > it
> > but there are no instruction on which tool to use or the command.
> >
> > If any one has any idea that would greatful.
> >
> > thanks
>
>
>
Author
7 Sep 2006 7:45 PM
John Bell
Hi

If you follow the instructions in the installation guide they do work. You
may want to try and copy the three .jar files into a different directory in
the CLASSPATH.

John

Show quote
"Yman" <Y***@discussions.microsoft.com> wrote in message
news:7C9E7B95-D885-465C-8E80-9CC727D37640@microsoft.com...
> I've already looked at these documentation, when I try to install IBM
> Director 5.1.3, in the configuration I have to select the SQL Database
> I've
> created. The message from Director "Unable to register the JDBC Driver.
> It's
> missing from the Classpath or might not be installed".
>
> My Classpath is set properly, and the JDBC driver is installed in the
> proper
> location according to the IBM documentation.
>
> So I thought I need to register the driver according to the message from
> director. The article you already sent to me I already looked at it.
>
> "John Bell" wrote:
>
>> Hi
>>
>> What do you mean by register?
>>
>> From:
>> http://download.microsoft.com/download/4/1/d/41d3e9c0-64d1-451e-947b-7a4cba273b2d/Install_Guide.txt
>> To install it on a Windows Computer just run setup.exe
>> If on a unix platform tar is an OS command.
>>
>> On the windows version it will install into C:\Program Files\Microsoft
>> SQL
>> Server 2000 Driver for JDBC. Once setup you will have an installation and
>> user guide in the books directory. The user guide shows you how to set
>> the
>> CLASSPATH  and registering it using Class.forName() e.g
>>
>> Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
>>
>> If you wish to use the driver to connect to the database it should be
>> called
>> in the form
>> jdbc:Microsoft:sqlserver://my-virtualserver:1433;DatabaseName=Pubs
>>
>> e.g.
>> Connection conn = DriveManger.getConnection
>> ("jdbc:Microsoft:sqlserver://dbserver:1433;DatabaseName=Pubs;User=username;Password=password")
>>
>> John
>>
>> "Yman" <Y***@discussions.microsoft.com> wrote in message
>> news:B772594B-CFEA-4A0F-8C1E-2FDA96F9000D@microsoft.com...
>> > Hi
>> >
>> > I'm trying to register the JDBC driver, I found the articles on how to
>> > do
>> > it
>> > but there are no instruction on which tool to use or the command.
>> >
>> > If any one has any idea that would greatful.
>> >
>> > thanks
>>
>>
>>

AddThis Social Bookmark Button