RE: Microsoft SQL support
RE: Microsoft SQL support
- Subject: RE: Microsoft SQL support
- From: "Ruenagel, Frank" <email@hidden>
- Date: Fri, 18 May 2007 10:57:08 +0200
- Thread-topic: Microsoft SQL support
Hi,
MS has slighlty changed the name of the driver from SQL Server 2000 to
SQL Server 2005. :-(( I guess this is the problem here?
To use a 2005 jdbc driver from EOF
we had to put the full driver name in the connection-dictionary (WO 5.2.4):
Example SQL Server 2005 with appropirate driver:
EOModelVersion = 2.1;
adaptorName = JDBC;
connectionDictionary = {
URL = "jdbc:sqlserver://88.0.2.107:1433;DatabaseName=TBtest";
driver = com.microsoft.sqlserver.jdbc.SQLServerDriver;
[...]
As "Plugin" we use "Microsoft".
Example SQL Server 2000 with appropriate driver:
EOModelVersion = 2.1;
adaptorName = JDBC;
connectionDictionary = {
URL = "jdbc:microsoft:sqlserver://pe1600:1433;DatabaseName=AMS";
driver = "";
[...]
WO 5.2.4!
The class com.microsoft.jdbc.sqlserver.SQLServerDriver is in the mssqlserver.jar
of the jdbc driver für SQl Server 2000.
The class com.microsoft.sqlserver.jdbc.SQLServerDriver is in the sqljdbc.jar
of the jdbc driver for SQL Server 2005.
The JDBC driver for SQL Server 2000 will not work correctly with a SQL-Server
2005 Database.
HTH
Frank
> -----Original Message-----
> From: webobjects-dev-bounces+webobjects=email@hidden
> [mailto:webobjects-dev-bounces+webobjects=symposion.de@lists.a
> pple.com]O
> n Behalf Of Ute Hoffmann
> Sent: Friday, May 18, 2007 8:07 AM
> To: email@hidden
> Subject: Fwd: Microsoft SQL support
>
>
>
>
> 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:
email@hidden
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