RE: Microsoft SQL support
RE: Microsoft SQL support
- Subject: RE: Microsoft SQL support
- From: email@hidden
- Date: Fri, 18 May 2007 09:38:10 -0700 (PDT)
This was it, thanks!
The 2005 docs still used the 2000 info.
Thanks again,
tom
On Fri, May 18, 2007 1:57 am, Ruenagel, Frank wrote:
> 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
>
>
_______________________________________________
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