Re: Microsoft SQL Helpppp!
Re: Microsoft SQL Helpppp!
- Subject: Re: Microsoft SQL Helpppp!
- From: Chuck Hill <email@hidden>
- Date: Wed, 6 Aug 2008 13:31:22 -0700
Also check the connection dictionary, the driver should be
com.microsoft.sqlserver.jdbc.SQLServerDriver
And the URL like
jdbc:sqlserver://host:1433;databaseName=Database
Chuck
On Aug 6, 2008, at 1:29 PM, Greg Bartnick wrote:
Hi Mersida,
Where did you place the sqljdbc.jar file? I don't see it being
included in the classpath that was printed out. If you put it in
/Library/WebObjects/Extensions/ or /Library/Java/Extensions/ it should
get added to the classpage automatically.
Regards,
Greg
On Wed, Aug 6, 2008 at 1:14 PM, Mersida Kurti <email@hidden>
wrote:
Hi everyone,
Seems like our sql database that one of our apps connects to has
changed
from sql 2000 to 2005 (yay!) Well not good news for us, because
apparently
it won't connect anymore. I added the new jar file in there
sqljdbc.jar and
changed the url to reflect the change; therefore from
jdbc:microsoft:sqlserver I changed it to jdbc:sqlserver. However,
I'm still
getting an error that says:
Could not connect to a database DBname because 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 forDriver not found in Java Runtime! Please verify your
CLASSPATH
environment variable. The current CLASSPATH for your application is :
/Users/muc154/Projects/V5/SOARData/dist/SOARData.woa/Contents/
Resources/Java/soardata.jar:/System/Library/Frameworks/
JavaWOExtensions.framework/Resources/Java/JavaWOExtensions.jar:/
Library/Frameworks/CipherUtility.framework/Resources/Java/
cipherutility.jar:/Library/Frameworks/ISSOFramework.framework/
Resources/Java/issoframework.jar:/Library/Frameworks/
ISSOFramework.framework/Resources/Java/xmlrpc-1.2-b1.jar:/System/
Library/Frameworks/JavaEOAccess.framework/Resources/Java/
javaeoaccess.jar:/System/Library/Frameworks/JavaEOControl.framework/
Resources/Java/javaeocontrol.jar:/System/Library/Frameworks/
JavaFoundation.framework/Resources/Java/javafoundation.jar:/System/
Library/Frameworks/JavaJDBCAdaptor.framework/Resources/Java/
javajdbcadaptor.jar:/System/Library/Frameworks/
JavaWebObjects.framework/Resources/Java/javawebobjects.jar:/System/
Library/Frameworks/JavaXML.framework/Resources/Java/javaxml.jar:/
System/Library/Frameworks/JavaVM.framework/Versions/1.5.
0/Classes/.compatibility/14compatibility.jar
Anyone seen this before? Gotten it fixed? I'd really appreciate
your help!
Regards,
Mersida
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden