RE: Classpath for MSSQLServer JDBC Driver
RE: Classpath for MSSQLServer JDBC Driver
- Subject: RE: Classpath for MSSQLServer JDBC Driver
- From: "Jonathan Fleming" <email@hidden>
- Date: Fri, 23 May 2003 13:59:09 +0100
Hello Jake,
I've used this URL (
jdbc:microsoft:sqlserver://10.0.0.1:1433;DatabaseName=JandM;SelectMethod=cu
rsor )and I still get the same error message every time, I'm now wondering
if there must be something wrong with where I've placed the .jar files
because I can't see what else would be the problem and I've also tried
anumber of variations of the JDBC URL that MSSQLServer2000 states.
These are the variations:
jdbc:microsoft:sqlserver://SILVER-BACK\\DEVBOXSQLSERVER
jdbc:microsoft:sqlserver://192.168.0.5:1433\\DEVBOXSQLSERVER
jdbc:microsoft:sqlserver://192.168.0.5:1433;DatabaseName=JandM;SelectMethod=
cursor
jdbc:microsoft:sqlserver://10.0.0.1:1433;DatabaseName=JandM;SelectMethod=cu
rsor
So since the error message keeps saying that,
JDBC connection failed for driver
:'com.microsoft.jdbc.sqlserver.SQLServerDriver'. Driver not found in Java
Runtime! Please verify your CLASSPATH environment variable,
it seems probable that where I have placed the .jar files are not being
found or something...
any ideas on where these should actually be placed or else I may have to go
down the claspath route which seems like confusing prospect.
Jonathan :^|
From: "MacMullin, Jake (DCS)" <email@hidden>
To: "'Jonathan Fleming'" <email@hidden>
CC: email@hidden, email@hidden
Subject: RE: Classpath for MSSQLServer JDBC Driver
Date: Fri, 23 May 2003 10:37:30 +0930
I've found it works best using the IP address of the database server - e.g.
jdbc:microsoft:sqlserver://10.0.0.1:1433;DatabaseName=dbname;SelectMethod=cu
rsor
This e-mail is personal. It is not authorised by, nor sent on behalf of,
the
Department for Correctional Services or the Government of South Australia.
-----Original Message-----
From: Jonathan Fleming [mailto:email@hidden]
Sent: Friday, 23 May 2003 8:59 AM
To: email@hidden
Cc: email@hidden; email@hidden
Ummm, Jonathan something hasn't worked...
I'm getting the error below after using the given URL where Silver-Back is
the local machine running SQLServer2000 and DevBoxSQLServer is the instance
name...
jdbc:microsoft:sqlserver://Silver-Back\\DevBoxSQLServer
JDBC connection failed for driver
:'com.microsoft.jdbc.sqlserver.SQLServerDriver'. Driver not found in Java
Runtime! Please verify your CLASSPATH environment variable. The current
CLASSPATH for your application is :
C:\Apple\Library\Frameworks\JDBCEOAdaptor.framework\Resources\Java\.;c:\usr\
FrontBase\Java\frontbasejdbc.jar;c:\usr\FrontBase\Java\FrontBasePlugIn.jar;/
Library/Java;C:/Apple/Local/Library/Java;C:/Apple/Library/Java;C:/Apple/Libr
ary/JDK/lib/classes.zip;C:/Apple/Library/Frameworks/JavaVM.framework/Classes
/awt.jar;C:/Apple/Library/JDK/lib/swingall.jar
I have tried the .jar files in --
C:\Apple\Local\Library\WebObjects\Extensions
and also in --
C:\Apple\Library\Frameworks\JDBCEOAdaptor.framework\Resources\Java\
but nothing... got any idea where or what I'm doing wrong?
Jonathan
>From: Jonathan Rochkind <email@hidden>
>To: "Jonathan Fleming" <email@hidden>,
>email@hidden, email@hidden
>Subject: Re: Classpath for MSSQLServer JDBC Driver
>Date: Thu, 22 May 2003 15:03:20 -0500
>
>Yes, it has worked for me to just put my JDBC .jar files in that
directory.
>
>It was not neccesary to set my environmental CLASSPATH to anything at
all.
>You shouldn't have to, and probably should not. Instead, put all those
>JAR files in that directory... and the WOBootstrap architecture will
>find them there and make sure they are included in the CLASSPATH sent
>to the launched Java app, even though they are not included in your
>environmental classpath.
>
>--Jonathan
>
>At 08:40 PM 5/22/2003 +0100, Jonathan Fleming wrote:
>>I've installed MS SQL Server 2000 and have the JDBC .jar files that
>>need to be used in classpath, since I am using WO5.2 can I simply copy
>>these into the C:\Apple\Local\Library\WebObjects\Extensions directory?
>>
>>The documentation says: Set your system CLASSPATH to include the
>>following entries, where install_dir is the path to your SQL Server
>>2000 Driver for JDBC installation directory:
>>install_dir/lib/msbase.jar
>>install_dir/lib/msutil.jar
>>install_dir/lib/mssqlserver.jar
>>I'm using Windows 2000, this is the Windows 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
>>
>>Just conforming. Once this is done I should be able to connect using
>>my EOModel with something like this:
>>jdbc:microsoft:sqlserver://server_name:1433
>>For example, to specify a connection URL that includes the user ID
>>"username" and the password "secret":
>>Connection conn = DriverManager.getConnection
>>("jdbc:microsoft:sqlserver://server1:1433","username","secret");
>>
>>Thanks for any help
>>Jonathan
>>
>>_________________________________________________________________
>>Express yourself with cool emoticons - download MSN Messenger today!
>>http://www.msn.co.uk/messenger
>>
>>_______________________________________________
>>WebObjects-dev mailing list
>>email@hidden
>>http://www.omnigroup.com/mailman/listinfo/webobjects-dev
>
_________________________________________________________________
Stay in touch with absent friends - get MSN Messenger
http://www.msn.co.uk/messenger
_______________________________________________
WebObjects-dev mailing list
email@hidden
http://www.omnigroup.com/mailman/listinfo/webobjects-dev
_______________________________________________
WebObjects-dev mailing list
email@hidden
http://www.omnigroup.com/mailman/listinfo/webobjects-dev
_________________________________________________________________
Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.