Thanks, works now. I can finally access the Microsoft DB from EntityModeler and 
from my D2W App.

---markus---



> On 18 Mar 2019, at 14:30, Theodore Petrosky <tedp...@yahoo.com> wrote:
> 
> Markus,
> 
> what about the properties??
> 
> from:   
> Class ERXConfigurationManager
> 
> Global:
>       dbConnectServerGLOBAL = myDatabaseServer
>       dbConnectUserGLOBAL = me
>       dbConnectPasswordGLOBAL = secret
>       dbConnectPluginGLOBAL = com.webobjects.jdbcadaptor.MicrosoftPlugIn
>  Per Model for say model ER:
>       ER.DBServer = myDatabaseServer
>       ER.DBUser = me
>       ER.DBPassword = secret
>       ER.DBPlugin = com.webobjects.jdbcadaptor.MicrosoftPlugIn
>  
> in my case I normally use postgresql:
> 
>  dbConnectDriverGLOBAL=org.postgresql.Driver
> 
> I never set this EOModeler unless I have to reverse compile a database
> 
> is this what you are looking for?
> 
> Ted
> 
> 
> 
>> On Mar 18, 2019, at 6:31 AM, Markus Ruggiero <mailingli...@kataputt.com 
>> <mailto:mailingli...@kataputt.com>> wrote:
>> 
>> Folks, 
>> 
>> It took a while because I was busy with other things but now I have to come 
>> back to this topic.
>> 
>>> On 28 Feb 2019, at 10:19, René Bock <b...@salient-doremus.de 
>>> <mailto:b...@salient-doremus.de>> wrote:
>>> 
>>> Hi, 
>>> 
>>> unless you need to use ERXMigrations for schema creation, you may simply 
>>> use the com.webobjects.jdbcadaptor.MicrosoftPlugIn.  
>> 
>> No migrations required.
>> How would I use the plug-in? Possibly silly question, but when I create an 
>> EOModel I cannot specify the plug-in to use (MSSQL is not in the popup list) 
>> and therefore I have no prototypes available. I might be missing something 
>> here simply because it's possibly too trivial and everything has always 
>> worked out of the box so far.
>> 
>> Thanks for some hand holding
>> ---markus---
>> 
>>> 
>>> If you  need ERXMigrations, things become bit hairy, since Microsoft  did  
>>> some strange sql extensions:
>>> 
>>> utf-8 Support:  varchar don't support UTF-8 characters.  You have to use 
>>> nvarchar, ntext, columns if you need to store utf-8 characters
>>> text-bolb:  text (and ntext)  are deprecated.  Microsoft encourage to use 
>>> varchar(MAX), which is not really standard sql :-(   At least I wasn't able 
>>> varchar(max) text blobs using the default EOSchemaGeneration mechanism.
>>> 
>>> Chuck once did write an (experimental) ERXMicrosoftPlugIn, to address 
>>> migration-support.  Unfortunately, didn't find it's way into WOnder. 
>>> Fortunately I got a copy of chucks plugin and added the nvarchar/ntext 
>>> migration support.  But my implementation required some changes in 
>>> ERPrototypes, which are not backward compatible...
>>> 
>>> 
>>> 
>>>> Am 27.02.2019 um 10:40 schrieb Markus Ruggiero <mailingli...@kataputt.com 
>>>> <mailto:mailingli...@kataputt.com>>:
>>>> 
>>>> We are about to get a new project but the customer requires the 
>>>> application to run against an existing Microsoft SQL Server (version not 
>>>> yet known). When I create a new EOModel there is no selection for an MS 
>>>> SQL Server plug-in. No support in Wonder for Microsoft?
>>>> 
>>>> Does anyone have experience running a Wonder App against a Microssoft 
>>>> database?
>>>> 
>>>> Please help and advise
>>>> ---markus---
>>>> 
>>>> _______________________________________________
>>>> Do not post admin requests to the list. They will be ignored.
>>>> Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com 
>>>> <mailto:Webobjects-dev@lists.apple.com>)
>>>> Help/Unsubscribe/Update your Subscription:
>>>> https://lists.apple.com/mailman/options/webobjects-dev/bock%40salient-doremus.de
>>>>  
>>>> <https://lists.apple.com/mailman/options/webobjects-dev/bock%40salient-doremus.de>
>>>> 
>>>> This email sent to b...@salient-doremus.de <mailto:b...@salient-doremus.de>
>>> 
>>> Mit freundlichen Grüßen 
>>> 
>>> René Bock
>>> 
>>> --
>>> Telefon: +49 69 650096 18
>>> 
>>> salient GmbH, Lindleystraße 12, 60314 Frankfurt
>>> Telefon Zentrale: 069 / 65 00 96 - 0  |  www.salient-doremus.de 
>>> <http://www.salient-doremus.de/>
>> 
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com 
>> <mailto:Webobjects-dev@lists.apple.com>)
>> Help/Unsubscribe/Update your Subscription:
>> https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com 
>> <https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com>
>> 
>> This email sent to tedp...@yahoo.com
> 

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Reply via email to