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 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/webobjects%40avendasora.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/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
