• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Microsoft SQL Helpppp!
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Microsoft SQL Helpppp!


  • Subject: Re: Microsoft SQL Helpppp!
  • From: David Avendasora <email@hidden>
  • Date: Wed, 6 Aug 2008 17:20:50 -0400

Maybe I missed it, but is there a reason you are not setting it in the .eomodel file? 

Dave


On Aug 6, 2008, at 4:56 PM, Mersida Kurti wrote:

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@hidden> wrote:
From: Chuck Hill <email@hidden>
Subject: Re: Microsoft SQL Helpppp!
To: "Greg Bartnick" <email@hidden>
Cc: "Mersida Kurti" <email@hidden>, "WebObjects Dev" <email@hidden>
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@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/
>> 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

References: 
 >Re: Microsoft SQL Helpppp! (From: Mersida Kurti <email@hidden>)

  • Prev by Date: Re: Microsoft SQL Helpppp!
  • Next by Date: Tiger/5.3 v Leopard/5.3
  • Previous by thread: Re: Microsoft SQL Helpppp!
  • Next by thread: Tiger/5.3 v Leopard/5.3
  • Index(es):
    • Date
    • Thread