Hi, I put a hack in the code for the name of the driver to be changed to
com.microsoft.sqlserver.jdbc.SQLServerDriver but I don't know how to go to the connection dictionary and change it. The hack in the code works, but I'd like to do this the right way. Please let me know how to change the name of the driver in the connection dictionary. Thank you, Mersida p.s: I had the jar file in /Library/Java/Extensions and then removed it from there because it was not doing anything. I just included it as resource. --- On Wed, 8/6/08, Chuck Hill <[EMAIL PROTECTED]> wrote: From: Chuck Hill <[EMAIL PROTECTED]> Subject: Re: Microsoft SQL Helpppp! To: "Greg Bartnick" <[EMAIL PROTECTED]> Cc: "Mersida Kurti" <[EMAIL PROTECTED]>, "WebObjects Dev" <[email protected]> Date: Wednesday, August 6, 2008, 4:31 PM 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 PROTECTED]> > 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 protected]) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/gbartnick%40gmail.com >> >> This email sent to [EMAIL PROTECTED] >> > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net > > This email sent to [EMAIL PROTECTED] > -- 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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
