Fwd: Microsoft SQL support
Fwd: Microsoft SQL support
- Subject: Fwd: Microsoft SQL support
- From: Ute Hoffmann <email@hidden>
- Date: Fri, 18 May 2007 08:07:22 +0200
Anfang der weitergeleiteten E-Mail:
Von: Ute Hoffmann <email@hidden>
Datum: Fr, 18. Mai 2007 08:05:59 Europe/Berlin
An: Tom Jones <email@hidden>
Betreff: Re: Microsoft SQL support
Am Freitag, 18.05.07 um 06:14 Uhr schrieb Tom Jones:
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.
No, nothing special here. I have my driver under
/Library/Java/Extensions and it just works.
Have you tried to use a different driver? I cannot recall what was the
matter with the one driver, which did not work.
A permission problem?
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:
u.hoffmann@tt-
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