Re: Microsoft SQL support
Re: Microsoft SQL support
- Subject: Re: Microsoft SQL support
- From: Tom Jones <email@hidden>
- Date: Thu, 17 May 2007 21:14:48 -0700
- Thread-topic: Microsoft SQL support
Hmm, I'm getting a driver error...
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 :
/Developer/Applications/WebObjects/EOModeler.app/Contents/Resources/Java/eom
odeler.zip:/Users/cheizer/Library/Java:/Library/Java:/System/Library/Java:/N
etwork/Library/Java:/System/Library/Frameworks/JavaVM.framework/Classes/clas
ses.jar:/System/Library/Frameworks/JavaVM.framework/Classes/ui.jar:/Develope
r/Applications/WebObjects/EOModeler.app/Contents/Resources/Java/eomodeler.zi
p:/System/Library/Frameworks/JavaVM.framework/Versions/1.5.0/Classes/.compat
ibility/14compatibility.jar
Do I need to do anything special, all I've ever done is copy the jar file to
/Library/Java/Extensions and Oracle and MySQL have worked.
Thanks,
tom
On 5/17/07 3:48 PM, "Ute Hoffmann" <email@hidden> wrote:
> What is your driver error message and what have you put into eomodeler
> for the connection to the database.
>
> Question: Has your User the App connects through the right connection
> rights for the MS SQL DB? There are two ways of authentication with MS
> SQL Server (windows and another one). You need to define a User with
> non-window authentication (whindows is the default when you create a
> new User and you cannot change it to the other way by the admin tools,
> at least you could not last summer). I had to open cmd on the windows
> server where the database run and change the user authentification
> scheme via commandline. If you think this may be your problem, please
> contact me and I will find you the file where I saved what I had to
> enter into cmd to get the user rights of the database right.
>
> Secondly make sure your database server is configured to receive
> network requests. I had to change things in the db server admin before
> I got my first connection to my db.
>
> If you need it I can also send you the driver I use with MSSQL server.
> I remember there were two and one did not work, I do not remember why
> it did not work.
>
> regards
>
> Ute
>
> Am Donnerstag, 17.05.07 um 22:59 Uhr schrieb Tom Jones:
>
>> Hello,
>> I'm new to WO and I'm having some issues connecting to MS SQL 2005. I
>> found
>> a jdbc driver for MSSQL2005 on MS site and I thought used the right URL
>> syntax but I keep getting a driver error message.
>>
>> Has anyone set this up before and if so could you please share.
>>
>> Thanks,
>> Tom
>>
>> PS: I'm using WO on a Mac OS X 10.4.9 system.
>>
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>> pixelmind.com
>>
>> 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